Which Transact-SQL command should you use?

You administer a Windows Azure SQL Database database named Orders.
You need to create a copy of Orders named Orders_Reporting.
Which Transact-SQL command should you use?

You administer a Windows Azure SQL Database database named Orders.
You need to create a copy of Orders named Orders_Reporting.
Which Transact-SQL command should you use?

A.
BACKUP DATABASE Orders TO DISK = ‘D:\Orders.bak’RESTORE DATABASE Orders_Reporting FROM
DISK = ‘D:\Orders.bak

B.
BACKUP DATABASE Orders TO DISK = ‘D:\Orders.bak’CREATE DATABASE Orders_Reporting FROM
DISK = ‘D:\Orders.bak

C.
CREATE DATABASE Orders_Reporting AS COPY OF Orders

D.
BACKUP DATABASE Orders TO DISK = ‘D:\Orders.bak’MIRROR TO DISK = ‘Orders_Reporting



Leave a Reply 3

Your email address will not be published. Required fields are marked *


Milen

Milen

I tried “C” – returns error, for incorrect syntax.
The write answer is “A”