You work as a database administrator at ABC.com. ABC.com is using a SQL Server 2008 R2
instance that contains a database named ABC_Prod. The ABC_Prod database uses a full
recovery model.
To adapt to business requirements, ABC.com now need to make use of a process which changes
20,000 records from the Sales table every day at 10 PM.
You have received instruction to devise a solution that allows any changes to the records to be
changed back while remaining online.
Which of the following actions should you take?
A.
You should consider making use of Database Recovery.
B.
You should consider making use of stored procedures.
C.
You should consider changing to the simple recovery model.
D.
You should consider making use of Database snapshots.
Explanation: