How should you complete the Transact-SQL statement?

HOTSPOT

You manage a sales database that uses the full recovery model.

You use the following backup schedule:

The date is April 15, 2018. A developer creates a transaction named modificationtest and runs the transaction at 9:20 AM.

You determine that the change implemented by the transaction must be undone. You immediately back up the database log to L:LogbackupSalestaillog.bak using the NORECOVERY and INIT options. Then, you restore the full database backup from the previous night using the NORECOVERY option.

You need to recover as much data as possible without recovering the change implemented by the transaction.

How should you complete the Transact-SQL statement? To answer, select the appropriate

Transact-SQL segments in the answer area. NOTE: Each correct selection is worth one point.

View Answer

Answer: