You work as the database administrator at Miracle Info.com. The Miracle Info.com network consists of a single Active Directo ry 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 7.0 database server named Miracle Info -DB01 that runs on Windows 2000 Server. Service Pack 4 for Windows 2000 Server id installed on Miracle Info -DB01. Miracle Info.com wants to migrate Miracle Info -DB01 to SQL Server 2005. You decide to perform an in-place upgrade to SQL Server 2005. You verify that Miracle Info -DB01 exceeds the recommended hardware requirements for SQL Server 2005. What should you do next?
A. A.Up grade Miracle Info -DB01 to Windows Sever 2003.
B. Install Service Pack 4 for SQL Server 7.0 on Miracle Info -DB01.
C. C.Upgrade SQL Server 7.0 on Miracle Info -DB01 to SQL Server 2000.
D. D.Run the SQL Server 2005 Setup utility on Miracle Info -DB01 and upgrade directly to SQL Server 2005.
Answer:B
You work as the database administrator at Miracle Info.com. The Miracle Info.com network consists of a single Active Directo ry 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 7.0 database server named Miracle Info -DB01 that runs on Windows 2000 Server. Service Pack 4 for Windows 2000 Server id installed on Miracle Info -DB01. Miracle Info.com wants to migrate Miracle Info -DB01 to SQL Server 2005. You decide to perform an in-place upgrade to SQL Server 2005. You verify that Miracle Info -DB01 exceeds the recommended hardware requirements for SQL Server 2005. What should you do next?
A. A.Up grade Miracle Info -DB01 to Windows Sever 2003. B. Install Service Pack 4 for SQL Server 7.0 on Miracle Info -DB01. C. C.Upgrade SQL Server 7.0 on Miracle Info -DB01 to SQL Server 2000. D. D.Run the SQL Server 2005 Setup utility on Miracle Info -DB01 and upgrade directly to SQL Server 2005.