You work as the database administrator at Miracle Info.com. The Miracle Info.com network consists of a single Active Directory domain named Miracle Info.com. All servers on the Miracle Info.com network run Windows 2000 Server. The Miracle Info.com network contains a SQL Server 2000 database server named Miracle Info -DB01 that runs on Windows 2000 Server Service Pack 4. Miracle Info – DB01 contains a database n amed CK_Trading.Miracle Info.com wants to migrate Miracle Info -DB01 to SQL Server 2005 but wants to retain the CK_Trading database with the same instance name. You decide to perform an in-place upgrade to SQL Server 2005. You verify that Miracle Info -DB01 exceeds the minimum recommended hardware requirements for SQL Server 2005. What should you do next?
A. A.Upgrade Miracle Info -DB01 to Windows Sever 2003 Service Pack
B. Run the SQL Server Upgrade Advisor on Miracle Info -DB01.
C. C.Detach th e CK_Trading database on Miracle Info –
D. D.B01. D.Run the SQL Server 2005 Setup utility.
Answer:B
You work as the database administrator at Miracle Info.com. The Miracle Info.com network consists of a single Active Directory domain named Miracle Info.com. All servers on the Miracle Info.com network run Windows 2000 Server. The Miracle Info.com network contains a SQL Server 2000 database server named Miracle Info -DB01 that runs on Windows 2000 Server Service Pack 4. Miracle Info – DB01 contains a database n amed CK_Trading.Miracle Info.com wants to migrate Miracle Info -DB01 to SQL Server 2005 but wants to retain the CK_Trading database with the same instance name. You decide to perform an in-place upgrade to SQL Server 2005. You verify that Miracle Info -DB01 exceeds the minimum recommended hardware requirements for SQL Server 2005. What should you do next?
A. A.Upgrade Miracle Info -DB01 to Windows Sever 2003 Service Pack B. Run the SQL Server Upgrade Advisor on Miracle Info -DB01. C. C.Detach th e CK_Trading database on Miracle Info – D. D.B01. D.Run the SQL Server 2005 Setup utility.