Which strategy should you implement?

You maintain an instance of Microsoft SQL Server 2008. The instance contains a database
named
Finance. The recovery model of the Finance database is set to Full.
You deploy a new process that modifies 10.000 records from the Accounts table at 19:00
hours daily.
You need to ensure that any modification to the data can be reverted without the database
going offline.
Which strategy should you implement?

You maintain an instance of Microsoft SQL Server 2008. The instance contains a database
named
Finance. The recovery model of the Finance database is set to Full.
You deploy a new process that modifies 10.000 records from the Accounts table at 19:00
hours daily.
You need to ensure that any modification to the data can be reverted without the database
going offline.
Which strategy should you implement?

A.
Database snapshots

B.
Differential backup

C.
Transaction log backup

D.
Primary filegroup backup



Leave a Reply 0

Your email address will not be published. Required fields are marked *