PrepAway - Latest Free Exam Questions & Answers

Tag: copy database wizard the destination server must be sql 2005

What should you do to use the Copy Database Wizard to accomplish this task?

You work as the database administrator at Domain.com. All servers on the Domain.com network run Windows Server 2003 and all database servers run SQL Server 2005. The Domain.com network contains two database servers named Certkiller -DB01 and Certkiller -DB02. Certkiller -DB01 hosts a database named CK_Orders that stores sales data for the company. The tables in the CK_Orders database are shown in the following database diagram.

A full-text index has been created on the ProductID column of the Products table. You need to move the CK_Orders database from Certkiller -DB01 to Certkiller -DB02. You need to ensure that users can run queries against the CK_Orders database while it is being moved, and that the full-text index can be queried once the database has been moved to Certkiller -DB02. You plan to use the Copy Database Wizard to accomplish this task.
exhibit What should you do? (Each correct answer presents part of the solution. Choose THREE.)