SQL Server 2005 backup and recovery: 5 handy tips

Backup and recovery with SQL Server 2005 include 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. Below, you'll find five tips to help you navigate through backup and recovery enhancements in SQL Server 2005.

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.

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

    Dig deeper on Microsoft SQL Server 2005

    Pro+

    Features

    Enjoy the benefits of Pro+ membership, learn more and join.

    0 comments

    Oldest 

    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:

    SearchBusinessAnalytics

    SearchDataCenter

    SearchDataManagement

    SearchAWS

    SearchOracle

    SearchContentManagement

    SearchWindowsServer

    Close