Which Transact-SQL statement should you run?

Posted by: Pdfprep Category: 70-764 Tags: , ,

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 . Option A
B . Option B
C . Option C
D . Option D

Answer: B

Leave a Reply

Your email address will not be published.