You work as a database administrator at ABC.com.ABC.com is making use of a SQL Server 2008
R2 instance that contains a database named ABC_Prod1.
You have been instructed to devise a strategy that produces a read-only duplication of
ABC_Prod1 at the start of each business day. This duplication will be used as a reporting tool.
Your strategy should also have a minimal effect on ABC_Prod1.
Which of the following actions should you take?
A.
You should consider configuring the use of the simple recovery model.
B.
You should consider frequent backups of the event log.
C.
You should consider making use of the database snapshots.
D.
You should consider configuring the use of transaction log backups that runs frequently.
Explanation: