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?
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?