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 fully logs all transactions and keeps the transaction log records
until after they are backed up. The solution should also allow for ABCSales to be restored to the
point of failure.
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 fully logs all transactions and keeps the transaction log records
until after they are backed up. The solution should also allow for ABCSales to be restored to the
point of failure.
Which of the following actions should you take?

A.
You should consider 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 *