Chapter 15. Restoring Data

In Chapter 14, we discussed taking backups of critical database data and their importance for data protection because they provide the ability to recover from system or disk failures which could cause data loss. In addition to taking backups, another one of the most important roles of a database administrator (DBA) is being able to restore data that has been backed up. Taking backups is just one side of the story. Successfully restoring that data is the other side.

In this chapter we discuss the fundatmentals of the restore process and define terminology and concepts. Then we discuss the different ways to restore ...

Get Microsoft® SQL Server™ 2005 Administrator's Companion now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.