11-11
21

SQL Server 2008/2005/2000 disaster recovery plan

Fine Happy

AuthorEASEUS   Category Data Backup   Comments0   Post Time 2011-11-21 01:09:40 -0500

After completing the process of installing and configuring Microsoft SQL Server, have you taken the time to develop a contingency plan to cover unforeseen catastrophes that might threaten your database in the future? Disaster recovery is all-too-often ignored until it's too late. Busy database administrators can easily push this task onto the back burner with promises to themselves that they'll "take care of backups right after I finish this big project." However, take a moment and consider the value of your data to your organization? What would be the result if an hour's worth of database changes were lost? A day's worth? What about a complete loss of the database?

The following is an example for sites that do not operate on a 24-hour basis (that is, sites that have available maintenance windows): To prepare for disaster, do the following every day (or whenever the maintenance window is):

Shut down SQL Server.
Copy all database device files, preferably to another computer in another building (but beware of network load), and also to a tape device (with the server down, the device files can be copied just like any other files).
Maintain system logs in a secure fashion. Record the directory where all SQL Server files are located, especially the Master.dat file. Keep records of all service packs installed for both Windows NT Server and SQL Server. Keep records of Net-libraries used, the security mode, and the SA password.
More …

Here, we suggest backup SQL Server with
SQL backup software and have a SQL disaster recovery when needed. In this article, I'll recommend professional backup software for SQL Server 2000, 2005, 2008 (R2) - EaseUS Todo Backup Advanced Server.

Free download it and install on your computer, backup database with MS SQL backup and recovery module (see how to backup SQL Server database with EaseUS Todo Backup Advanced Server?) and then recover the SQL backups when facing with SQL disaster.

This backup software supports differential backup (How to create differential backup of SQL Server database?), transaction log backup (How to backup SQL Server transaction log?). It can also backup SQL to disk or tape (refer to Backup SQL Server to hard drive, how to backup SQL to tape?)

Trackback URL Trackback: http://blog.easeus.com/action.php?action=tb&id=509

Tags Tags: sql server disaster recovery plan

Comments List

Post a Comment

  • Name:
  • Email:
  • HomePage:
  • Comment:
  • Question:

Home | Solution | About Company | Contacts | Resource | Blog | Forum | Directory | Links | Sitemap

Copyright © 2005-2008 CHENGDU YIWO Tech Development Co., Ltd. ALL RIGHTS RESERVED.

Privacy Policy | License | Legal Counsel