Monday, October 8, 2007

Database consolidation

You have three databases: Accounting, HR, and Customer. Each is hosted on a dedicated SQL Server computer. All SQL Servers use Windows Authentication mode and belong to the single Active Directory domain. The Global Group dba_accounting is responsible for managing all databases and SQL Server configuration on the Accounting Computer. The dbaAdmin global group is responsible for managing the HR and Customer databases on the other two SQL Server computers.

How do you consolidate the three SQL Server computers?

Based on the security boundary requirement, one SQL Server 2005 computer with two instances will be designed.