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.)
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.