Export (0) Print
Expand All

Troubleshooting Planning

SQL Server 2000

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.

See Also

Data Integrity Validation

Database Maintenance Plan Wizard

Designing a Backup and Restore Strategy

Disaster Recovery Planning

Managing Permissions

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
© 2015 Microsoft