找考题网-背景图
多项选择题

Your company uses a mission-critical database named DB1, which is located on a server named SQL1. You want to mirror DB1 on a second server named SQL2. Before you can establish database mirroring, you need to prepare DB1 and the servers for mirroring. Which three actions should you perform?()

A. Set the recovery model of DB1 on SQL1 to bulk-logged recovery. 
B. Set the recovery model of DB1 on SQL1 to full recovery. 
C. Back up DB1 on SQL1. Restore the backup on SQL2; specify the NORECOVERY option. 
D. Back up DB1 on SQL1. Restore the backup on SQL2; specify the STANDBY option. 
E. Back up DB1 on SQL1. Restore the backup on SQL2; specify the RECOVERY option.
F. Create endpoints on all participating servers. 
G. Set the AutoShrink property of DB1 on SQL1 to false.

热门试题

单项选择题You work with a SQL Server 2005 database that provides banking information for customers. You want customers to see banking reports that combine data that is retrieved from the database with real-time investment information that comes from a Web service provided by a third party. The investment information must be current when the reports are executed. You need to create the appropriate objects that support the reports.  What should you do?()

A. Publish the data in the database as an XML Web service by using the FOR XML AUTO clause. 
B. Create a table to store the banking information for each customer. Create a trigger that fires when data is inserted into the table that joins with the data coming from the Web service. 
C. Create a Transact-SQL stored procedure that uses a temporary table to store the banking information for each customer. Update the table with the values from the Web service. 
D. Have a developer in your company create an assembly that calls the remote Web service. Create aCLR function by using the assembly. Call the CLR function and combine the results with banking information in the database.