SQL Server Disaster Recovery

About.com:

The first step in developing a solid disaster recovery plan is to develop an idea of what constitutes an acceptable loss for your organization. First, consider the impact of losing data stored in your database. Would you be able to recover from the loss of an hour's worth of data? If you're managing a human resources database, chances are that you could deal with this situation by instructing your personnel to reenter data entered during that period. If you're running the database supporting a financial institution, the loss of an hour's data could bring the instant wrath of clients and industry regulators along with significant monetary losses. Protection against these types of losses is provided by backups of the database and use of transaction logging. We'll discuss these in further detail.

Second, consider the loss of access to the database itself. What would be the ultimate result if your end users were not able to access information for an extended period of time. The loss of access to our human resources database would likely result in frustration, but minimal loss to the business. On the other hand, if doctors at a hospital were unable to access test results and laboratory findings in a timely manner it could result in the loss of life or limb. If you find that these issues are a concern in your organization, you may want to consider the use of failover clustering to ensure the continuous availability of your database. This concept will be discussed in a future article.

Once you've determined the level of acceptable loss for your organization and received buy-in from the users you support and your management, it's time to begin developing a strategy to minimize the impact of a catastrophic event on your database. Our first step is to develop a comprehensive backup strategy. We'll discuss this in the next section of this article. Read on!

Comments

0 comments.

Thanks for participating. Comments are now closed.

Trackbacks

0 so far. To trackback this entry, ping this url:

http://www.nicheblogs.net/mt/mt-tb.cgi/157

« Recover A Dead Hard Drive Using dd | Main | Could Data Recovery Void Your Warranty? »