what should you do to achieve to ensure that the database can be restored to a specific point in time?

You are the administrator of your company network. You are in charge of a SQL Server 2008 instance which contains a database named Funds. Minimally logged operations are performed on the Funds database. You have to ensure that the database can be restored to a specific point in time. So what should you do to achieve this?

You are the administrator of your company network. You are in charge of a SQL Server 2008 instance which contains a database named Funds. Minimally logged operations are performed on the Funds database. You have to ensure that the database can be restored to a specific point in time. So what should you do to achieve this?

A.
You should identify that the database uses the full recovery model.

B.
You should identify that the database uses the simple recovery model.

C.
You should identify that the database uses the bulk-logged recovery model.

D.
You should identify that the database uses the checksum page verify option.



Leave a Reply 0

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