Which three tasks should you include?

You administer a SQL Server 2008 infrastructure. You design a corporate backup and
recovery strategy that has to be validated. You need to ensure the successful recovery of
any single database from a catastrophic failure without requiring a backup data center in a
different location. Which three tasks should you include? (Each correct answer presents
part of the solution. Choose three.)

You administer a SQL Server 2008 infrastructure. You design a corporate backup and
recovery strategy that has to be validated. You need to ensure the successful recovery of
any single database from a catastrophic failure without requiring a backup data center in a
different location. Which three tasks should you include? (Each correct answer presents
part of the solution. Choose three.)

A.
Document the administrative processes and application access requirements.

B.
Maintain one list of all Windows logins and passwords.

C.
Install all SQL Server instances on a failover cluster.

D.
Script SQL login accounts and credentials.

E.
Store all backup media offsite.



Leave a Reply 0

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