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
You administer a Microsoft Azure SQL Database database named Orders. You need to create a copy of Orders named Orders_Re
-
answerhappygod
- Site Admin
- Posts: 899604
- Joined: Mon Aug 02, 2021 8:13 am
You administer a Microsoft Azure SQL Database database named Orders. You need to create a copy of Orders named Orders_Re
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!