Dell R810 User Manual

Page 35

Advertising
background image

Servers: Database consolidation on Dell PowerEdge R810 servers


35

4.

Database level

a.

Database properties and options

b.

Recovery model, auto-shrink, etc.

c.

Files and filegroups (size and location)

d.

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?

e.

Other database issues

i. Is this database in a replication configuration?

ii. Is this database a partner in a mirroring session

(2005/2008 only)?

iii. Do any SSIS/DTS packages reference this

database?

iv. Do any SQL Agent jobs reference this database?

f.

Users/Logins

i. Number of users this database affects

ii. 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

Advertising