You administer a Microsoft 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

  Discussion forum

Question
0

Leave an answer