What should you do?

You work as a database administrator at Domain.com. Domain.com is using a SQL Server
2008 instance that contains a database named CK_Prod. CK_Prod database does execute the logged operations.
You have received instructions to ensure that the database can be recovered to a specific point in time.

What should you do?

You work as a database administrator at Domain.com. Domain.com is using a SQL Server
2008 instance that contains a database named CK_Prod. CK_Prod database does execute the logged operations.
You have received instructions to ensure that the database can be recovered to a specific point in time.

What should you do?

A.
You should consider ensuring that CK_Prod uses the full recovery model.

B.
You should consider ensuring that CK_Prod uses the half recovery model.

C.
You should consider ensuring that CK_Prod uses the Transactions Log.

D.
You should consider ensuring that CK_Prod uses the store procedure.



Leave a Reply 0

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