O'Reilly logo

Microsoft® SQL Server™ 2005 Administrator's Pocket Consultant by William R. Stanek

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

Restoring a Database

Occasional database corruption, hardware failure, and natural disasters do happen, and as a database administrator, you need to be able to restore the database if any of these events occur. Even if you are a pro at backup and restore, keep in mind that restoring a database is different from restoring an operating system or recovering other types of applications. The mix of full, differential, and transaction log backups ensures that you can get up-to-the-minute recovery of a database, but it complicates the recovery process.

In the following subsection, you will find tips and advice on troubleshooting database corruption. After that you will find step-by-step procedures for restoring a database in various situations, including: ...

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