How should you complete the Transact-SQL statement?

DRAG DROP

You have a test server that contains a database named DB1. Backups of the database are written to a single backup device. The backup device has a full, differential, and transaction log backup.

You discover that the database is damaged. You restore the database to the point at which the differential backup was taken.

You need to rebuild the database with data stored in the latest transaction logs.

How should you complete the Transact-SQL statement? To answer. drag the appropriate Transact-SQL segments to the correct locations. Each Transact-SQL segment may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.

View Answer

Answer:

Explanation:

Box 1: RESTORE

Box 2: RECOVERY

The RESTORE … WITH RECOVERY option puts the database into a useable state, so users can access a restored database.

References: https://www.mssqltips.com/sqlservertutorial/112/recovering-a-database-that-is-in-the­restoring-state/