You administer a SQL Server 2008 instance that hosts a large financial database. The
database has the following backup strategies: A full database backup is performed once
a week. A differential backup is performed every day. A transaction log backup is
performed every hour. You plan to execute an end-of-year batch process that takes two
hours to run. The batch process will modify about five percent of data within the database.
You need to ensure that if the Finance department does not approve the batch process, the
batch operation can be rolled back in minimum possible time. What should you do prior to
starting the batch process?
A.
Perform a differential backup.
B.
Create a database snapshot.
C.
Create a marked transaction. Perform a transaction log backup.
D.
Record the time before the batch operation. Perform a transaction log backup.
Explanation: