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.
Here are a number of the web-sites we suggest for our visitors.