Tutorial

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

  • Join the conversationComment

    Share
    Comments

      Results

      Contribute to the conversation

      All fields are required. Comments will appear at the bottom of the article.