To minimize the effects of a server failure or other troubleshooting situation:
- Develop and test a backup and disaster recovery plan.
- Use the Database Maintenance Plan Wizard to schedule the scripts to run during periods of low activity.
- Verify the security permissions and roles you have planned for your databases.
Disaster Recovery Plan
The importance of disaster recovery assessment cannot be overstated. What is the business risk if you cannot get your data back? What is the cost for each hour's delay in getting your system back up and running? Do not assume that your data is quickly recoverable. Thoroughly understanding the steps for recovery ahead of time will minimize the stress and uncertainty imposed by a future disaster. Some important points to consider are:
- Periodically assess the validity of the current disaster recovery plan.
- Have sufficient hardware and staff to implement recovery procedures.