You administer a SQL Server instance. A database named DB1 is corrupted.
Backups of DB1 are available on a disk backup device located at Z:\Backups\Backup.bak. The backup device has the following backups sets:
* a full database backup that is the first backup set on the device (FILE = 1)
* a differential database backup that is the second backup set on the device (FILE = 2)
* a transaction log backup that is the third backup set on the device (FILE = 3) You restore the full database backup and the differential database backup without rolling back the uncommitted transactions.
You need to restore the transaction log backup and ensure the database is ready for use after restoring the transaction log.
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.