Exam 70-764 topic 1 question 37 discussion

Actual exam question from Microsoft's 70-764

Question #: 37
Topic #: 1

You have a database named DB1 that is configured to use the full recovery model. You have a full daily backup job that runs at 02:00. The job backs up data from
DB1 to the file B:\DB1.bak.
You need to restore the DB1 database to the point in time of May 25, 2016 at 02:23 and ensure that the database is functional and starts to accept connections.
Which Transact-SQL statement should you run?

A.

B.

C.

D.

Show Suggested Answer

Suggested Answer: B

by TheSwedishGuy at Jan. 28, 2020, 7:36 a.m.

Comments

Submit Cancel

vescafi

4 years, 7 months ago

but when does the database remain functional for users, if it never leaves the "no recovery"

upvoted 3 times

Hoglet

4 years, 5 months ago

RECOVERY is the default option, hence B

upvoted 1 times

...

mrkathyd

4 years, 9 months ago

B is the right answer

upvoted 1 times

...

mrn0107

5 years, 5 months ago

As i see, we should take tail_log backup. The database will go in restoring state.

upvoted 4 times

...

TheSwedishGuy

5 years, 5 months ago

Interestingly, you start the restore phase by taking a log backup with no recovery, so as to prevent any transactions occuring before the restore is done.

upvoted 2 times

Hoglet

4 years, 5 months ago

I would phrase it differently. There hasn’t been a LOG backup since the FULL backup so this is the only one. Putting it into NORECOVERY means that existing connections are dropped so they don’t block the restore.

upvoted 1 times

...