SQL Server 2005 backup and recovery: 5 handy tips

Backup and recovery capabilities with SQL Server 2005 are relatively unchanged from SQL Server 2000, but there are several new features worthy of your attention. These features include database mirroring and database snapshots, which have been hailed as "gems" in terms of overall new features in this latest version of SQL Server. Below, you'll find five tips to help you navigate through backup and recovery enhancements in SQL Server 2005.

    Requires Free Membership to View

Piecemeal restore with SQL Server 2005
SQL Server 2005 extends the partial restore functionality with piecemeal restore, a feature that ultimately allows you to recover your entire database as your schedule permits. SQL Server expert Baya Pavliashvili details the benefits of piecemeal restore and outlines an example of how it is implemented.

Q&A: Database mirroring and its witness
Database mirroring in SQL Server 2005 will increase your system's availability by allowing a quick and automatic failover. This feature involves three SQL Server instances: the principal, mirror and witness. Edgewood Solutions' Greg Robidoux answers some common questions about the witness to help you better understand the role of this intricate team player in database mirroring.

SQL Server 2005: When and how to use Database Snapshots
Database Snapshots, a new feature in SQL Server 2005, lets you easily create a read-only copy of your database. Know the pros and cons of using this feature.

Partial backup options in SQL Server 2005
SQL Server 2005 offers new backup enhancements to help ease the pain of backing up only changed data. Contributor Serdar Yegulalp compares your options.

Online restore feature in SQL Server 2005
SQL Server 2005's online restore feature eliminates the need to have exclusive access to the database when restoring a backup. Learn about the restore procedure and how it requires the Enterprise or Developer Edition for implementation to take place.

More on SearchSQLServer.com

  • SQL Server Backup and Recovery Learning Guide
  • SQL Server backup encryption for improved security
  • Speed up SQL Server backup and restore time

    This was first published in February 2007

  • There are Comments. Add yours.

    TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

    REGISTER or login:

    Forgot Password?
    By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
    Sort by: OldestNewest

    Forgot Password?

    No problem! Submit your e-mail address below. We'll send you an email containing your password.

    Your password has been sent to: