Which of the following actions should you take?

You work as a database administrator at ABC.com. ABC.com is using a SQL Server 2008 R2
instance that includes a database named ABCSales.
Minimal changes to the information in ABCSales take place on a daily basis. You have been
instructed to devise a solution that produces for a read-only copy of the database. Furthermore,
the solution has to run every morning and should consume as little disk resources as possible.
Which of the following actions should you take?

You work as a database administrator at ABC.com. ABC.com is using a SQL Server 2008 R2
instance that includes a database named ABCSales.
Minimal changes to the information in ABCSales take place on a daily basis. You have been
instructed to devise a solution that produces for a read-only copy of the database. Furthermore,
the solution has to run every morning and should consume as little disk resources as possible.
Which of the following actions should you take?

A.
You should consider configuring the use of database snapshots.

B.
You should consider configuring the use of transaction log backups.

C.
You should consider configuring the use of differential backups.

D.
You should consider configuring the use of incremental backups.

Explanation:



Leave a Reply 0

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