View a list of the current whitepapers.


Best Practices for Backup and Restore in SQL Server 2005


Javier Loria

In an ideal world, hard drives and other hardware never fail, software is never defective, users do not make mistakes, and hackers are never successful. However, we live in a less than perfect world and we should plan and prepare to handle adverse events. In our database environment, that plan is called the Data Recovery Plan (DRP). The DRP is the set of actions that database administrators (DBAs) take to handle adverse events that may affect the availability of their database environments. Microsoft SQL Server 2005 has a variety of different technologies that can help DBAs build a DRP. These technologies include: Failover Cluster, Database Mirroring, Database Replication and Log Shipping. In spite of the advantages these technologies might offer, DBAs should always plan backups and restores as the last line of defense of the DRP. In this whitepaper, we will discuss some of the best practices in Backup and Restore operations when using SQL Server 2005. In this whitepaper we will cover:

• What types of Backup and Restore options SQL Server offers

• How to combine Backup and Restore types in a DRP

• Best practices you should follow in your backup and restore strategy


In order to download Best Practices for Backup and Restore in SQL Server 2005 whitepaper, please fill out the form below. This is a sponsored offer, as specified in our privacy statement. The information you submit on this form will be shared with the sponsor and used in accordance with the sponsor's privacy policy.

Required fields marked with a *
Login Information
Only numbers and letters may be used in username - no special characters
Username: *
Password: *
 Confirm Password: *


Contact Information:
First: * Last: *
Job Title: * Company: *
Address: * Address 2:
Floor/Suite: City: *
State/Province: * Country: *
Postal Code: *
(for US & Canada)
 Phone: *
Email: *    

Terms of Use
By submitting this form, you agree to abide by the terms of use of this site, and consent to have the information you submit stored and used in accordance with our privacy statement. (Revised on January 23, 2009) You may change your privacy and communication preferences at any time. *

You will be receiving an email to validate your email address
 

ADS BY GOOGLE