You work as a database administrator at Domain.com. Domain.com is using a SQL Server
2008 instance that contains a database named CK_Prod. The CK_Prod database uses a full recovery model.
To adapt to business requirements, Domain.com now need to make use of a
process which changes 20,000 records from the Accounts table at 22:00 hours, which is published, daily.
You have received instruction to ensure that any changes to the records could be effected without the database going offline.
What should you do?
A.
You should consider using Database Recovery.
B.
You should consider using stored procedure.
C.
You should consider using Transaction log backup.
D.
You should consider using Database snapshots.