O'Reilly logo

SQL Server® 2008 Administration: Real World Skills for MCITP Certification and Beyond by Tom Carpenter

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Restore a Database

The reason so much effort should be put into backing up your databases is to provide you with the ability to recover from these backups in the event of failures. This section provides the basic information you'll need to be able to restore your databases completely to a point in time or to the point of failure. It will also review the methods you can use to restore the system databases should they become corrupted.

Choosing a Restore Method

You can restore databases to a point in time, to the point of failure, or to a full backup made at a specific point. Before you begin, however, it is important that you understand the limitations you impose on yourself through your backup plan. Here are some examples:

  • If your backup plan ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required