You are a database administrator for AIOTestKing.com. You manage a database named Invoicing. The Invoicing database is backed up with a full backup nightly and transaction log backups once every two hours from 08:00 to 17:00. You implement database snapshots for the Invoicing database. A database snapshot is created each day at 07:00.
At 09:30 today, a user inadvertently deleted all of the invoices that were entered into the CurrentInvoice table yesterday. None of these invoices had been changed today prior to the deletion. It is now 11:45 and many other changes have occurred in the database. You need to recover the lost rows with as few administrative steps as possible while minimizing data loss. What should you do?
A.
Use the SELECT subquery in the INSERT statement to move the deleted rows from yesterday mornings database snapshot to the CurrentInvoice table.
B.
Restore last nights Full Backup and all transaction log backups until the 10:00 backup.
Use the STOP AT statement on all restores to stop the restores at 09:29.
C.
Use the SELECT subquery in the INSERT statement to move the deleted rows from this mornings database snapshot to the CurrentInvoice table.
D.
Restore last nights Full Backup and all transaction log backups until the 10:00 backup.
Use the STOP AT statement on the last restore to stop the restore at 09:29.