You need to verify that the database can be restored to a specific point in time

You maintain a SQL Server 2008 instance that contains a database named Finance.
Minimally logged operations are performed on the Finance database.
You need to verify that the database can be restored to a specific point in time.
What should you do?

You maintain a SQL Server 2008 instance that contains a database named Finance.
Minimally logged operations are performed on the Finance database.
You need to verify that the database can be restored to a specific point in time.
What should you do?

A.
Verify that the database uses the full recovery model.

B.
Verify that the database uses the simple recovery model.

C.
Verify that the database uses the bulk-logged recovery model.

D.
Verify that the database uses the checksum page verify option.



Leave a Reply 0

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