You are a professional level SQL Sever 2008 Database Administrator in an international corporation named Wiikigo. You are experienced in managing databases in an enterprise-level organization, optimizing and sustaining the database life cycle. In the company, your job is to implement solutions on security, troubleshooting, deployment and optimization. A SQL Server 2008 infrastructure is managed by you. A corporate backup and recovery strategy that has to be validated is designed. You are required to make sure that any single database can be restored successfully from a severe failure, and during the restoration, a backup data center should not be required in a different location. Which three actions should be contained by your solution?()
- AAll SQL Server instances should be installed on a failover cluster.
- BOne list of all Windows logins and passwords should be sustained.
- CAll backup media offsite should be stored.
- DSQL login accounts and credentials should be scripted.
- EThe administrative processes and application access requirements should be documented.&e