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 contains 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 minimizes administrative overhead for the transaction log of
ABCSales.
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 contains 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 minimizes administrative overhead for the transaction log of
ABCSales.
Which of the following actions should you take?

A.
You should consider making having the full recovery model configured for ABCSales.

B.
You should consider having the simple recovery model is configured for ABCSales.

C.
You should consider running the SQL Server Profiler on ABCSales.

D.
You should consider configuring ABCSales to make use of the checksum page verify option.

Explanation:



Leave a Reply 0

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