PrepAway - Latest Free Exam Questions & Answers

Which two actions should you perform?

You are the administrator of a SQL Server 2005 computer named SQL1. SQL1 hosts a database named AssetTrack. You need to design a strategy to quickly perform point-in-time and page-level restores of the AssetTrack database. Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)

PrepAway - Latest Free Exam Questions & Answers

A.
Design a backup strategy that involves full and differential backups.

B.
Configure the Recovery model database option as Full.

C.
Configure the Recovery model database option as Simple.

D.
Design a backup strategy that involves full and transaction log backups.

E.
Configure the Restrict access database option as Restricted.

Explanation:
Point-in-time and page-level restores require the bulk-logged or full recovery model.


Leave a Reply