You work as the database administrator at Domain.com. The Domain.com network consists of a single Active Directory domain named Domain.com. All servers on the Domain.com network run Windows Server 2003 and all client computers run Windows XP Professional. The Domain.com network contains two SQL Server 2000 database servers named Certkiller -DB01 and Certkiller -DB02 that are configured fro log shipping. Certkiller -DB01 is the primary server and hosts a database named CK_Trading. Both Certkiller -DB01 and Certkiller -DB02 have Service Pack 3 for SQL Server 2000 installed. Domain.com wants to upgrade Certkiller -DB01 and Certkiller -DB02 to SQL Server 2005 Enterprise Edition but the CK_Trading database must remain available during the upgrade process. You verify that both Certkiller -DB01 and Certkiller -DB02 exceed the recommended hardware requirements for SQL Server 2005 Enterprise Edition. You then install Service Pack 1 for Windows Server 2003 on Certkiller -DB01 and Certkiller -DB02.
What should you do next?
A.
Install Service Pack 4 for SQL Server 2000 on both database servers.
B.
Enable failover in the SQL Server 2000 log shipping configuration and upgrade Certkiller -DB02 to SQL Server 2005.
C.
Run the Database Maintenance Plan Wizard on Certkiller -DB01 to upgrade it to SQL Server 2005.
D.
Upgrade Certkiller -DB02 to SQL Server 2005 and then upgrade Certkiller -DB01 to SQL Server 2005.
Explanation:
SQL Server 2005 does not support the Database Maintenance Plan Wizard which was integral to log shipping in SQL Server 2000. Hence, log shipping stops functioning when you upgrade a SQL Server 2000 log shipping configuration directly to SQL Server 2005. To upgrade log shipping to SQL Server 2005, you must migrate the database servers to SQL Server 2005. If you want the database to remain available during the migration process, you must migrate with failover. To migrate with failover you must enable failover and upgrade Certkiller -DB02. Then you need to failover to Certkiller -DB02 and upgrade Certkiller -DB01. Then configure log shipping with the Certkiller -DB02 becoming the primary server and Certkiller -DB01 becoming the secondary server.
Incorrect Answers:
A: You do not need to install Service Pack 4 for SQL Server 2000 on the database servers as SQL Server 2000 with Service Pack 3 can be upgraded to SQL Server 2005. However, SQL Server 2005 does not support the Database Maintenance Plan Wizard which was integral to log shipping in SQL Server 2000. Hence, log shipping stops functioning when you upgrade a SQL Server 2000 log shipping configuration directly to SQL Server 2005.
C: SQL Server 2005 does not support the Database Maintenance Plan Wizard which was integral to log shipping in SQL Server 2000. Hence, log shipping stops functioning when you upgrade a SQL Server 2000 log shipping configuration directly to SQL Server 2005.
D: Removing log shipping from Certkiller -DB02 and upgrading Certkiller -DB01 to SQL Server 2005 will not ensure that the CK_Trading database remains available.
Reference:
Microsoft SQL Server 2005 Books Online (2006), Index: log shipping [SQL Server], upgrading