You are the administrator of your company network. There’s a SQL Server 2008 instance which hosts a large sales database in your company. The database uses the following backup strategies: A transaction log backup is performed hourly.
A differential backup is performed every day.
A full database backup is performed once a week.
You intend to run an end-of-year batch process which will change about four percent of data within the database. And the process takes about two hours to run. If something unexpected happens, such as the Sales department disapprove the process, you must make sure that the batch operation can be rolled back as soon as possible. What should you do before starting the batch process?
A.
You should create a database snapshot.
B.
You should perform a differential backup.
C.
You should create a marked transaction. Perform a transaction log backup.
D.
You should record the time before the batch operation. Perform a transaction log backup.