Dell POWEREDGE R515 Manual de usuario descargar pdf (Pagina 28)

Migrating to a Dell PowerEdge R515 server from two legacy database servers

f. Service account and all service permission information

(does SQL Server Agent run under a different service

account?)

g. Are there any non-default master or model database

objects?

h. Are there any linked server objects?

i. Are other SQL modules involved or dependent on this

instance (e.g., Analysis Services, Reporting Services, etc.)?

j. Default installation directories, data directories, and log

directories

k. Tempdb – highly volatile? Slightly volatile? Medium usage?

4. Database level

a. Database properties and options

i. Recovery model, auto-shrink, etc.

ii. Files and filegroups (size and location)

b. Backups

i. How many full backups, and on what schedule?

ii. How many differential backups, and on what

schedule?

iii. How many log backups, and on what schedule?

iv. Current backup window?

v. Can backup window shift to accommodate the

consolidated backup window?

c. Other database issues

vi. Is this database in a replication configuration?

vii. Is this database a partner in a mirroring session

(2005/2008 only)?

viii. Do any SSIS/DTS packages reference this database?

ix. Do any SQL Server Agent jobs reference this

database?

d. Users/Logins

x. Number of users this database affects

xi. Would this database require a login whose name

conflicts with another name on the target

consolidation server? If so, you would need to

create the login and map the database user using

sp_change_users_login

1 2 ... 23 24 25 26 27 28 29 30 31 32 33 ... 44 45

Sin comentarios

Dell POWEREDGE R515 Manual de usuario Pagina 28