Which Transact-SQL statement should you run?

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?

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.



Leave a Reply 0

Your email address will not be published. Required fields are marked *