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?()
- A、All SQL Server instances should be installed on a failover cluster.
- B、One list of all Windows logins and passwords should be sustained.
- C、All backup media offsite should be stored.
- D、SQL login accounts and credentials should be scripted.
- E、The administrative processes and application access requirements should be documented.
微信扫一扫手机做题