Exam 70-764 topic 1 question 36 discussion

Actual exam question from Microsoft's 70-764

Question #: 36
Topic #: 1

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.
Select and Place:

Show Suggested Answer

Suggested Answer:

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/

by MSSucks at Feb. 14, 2020, 12:52 p.m.

Comments

Submit Cancel

Hoglet

4 years, 11 months ago

Not a clear question It is a TEST box. We are restoring for some unknown purpose and the original database was damaged. Rather than WITH RECOVERY or NORECOVERY they are looking for CONTINUE_AFTER_ERROR. We know the DB is damaged, so their may be errors, and this is a TEST box so data loss is less and issue.

upvoted 1 times

...

KC

4 years, 12 months ago

Seems like a misleading or incomplete question. It would imply that the differential has already been completed, and you're working on the log restore. If that's the case, RESTORE LOG should be an option. But, I believe Microsoft recommends not using WITH RECOVERY at that stage (although, it can be done that way): https://docs.microsoft.com/en-us/sql/relational-databases/backup-restore/apply-transaction-log-backups-sql-server?view=sql-server-ver15 Also, the.bak extension, along with RESTORE LOG not being an option would lead me to believe that we aren't restoring the log in this step at all. If that's the case, we may be completing the differential restore with this TSQL command, so we would RESTORE DATABASE... WITH NORECOVERY; : https://docs.microsoft.com/en-us/sql/relational-databases/backup-restore/restore-a-differential-database-backup-sql-server?view=sql-server-ver15

upvoted 1 times

KC

4 years, 12 months ago

Also, since the RECOVERY option is the default, I am leaning even more toward the idea that we are actually still on the RESTORE DATABASE step using WITH NOREOVERY.

upvoted 1 times

jolsca

4 years, 11 months ago

You restore the database to the point at which the differential backup was taken. RESTORE DATABASE step using WITH NOREOVERY.

upvoted 3 times

...

MSSucks

5 years, 5 months ago

Box 1 should be "RESTORE LOG" but it is not among the possible answers. Only "RESTORE" or "LOG", not both combined. :-(

upvoted 2 times

...