10.3. Perform Restore Operations

The best backup processes in the world will not help you much if you do not have a plan for restoration. The first section of this chapter, "Understand Recovery Concepts," covered backup strategies and also addressed restore options, so you should already be somewhat familiar with how you will approach the restoration of your databases. In fact, it is critical that you consider how you will implement the restore process as this will directly affect the backup strategy that you will select.

SQL Server tracks information about backup processes in two places. First, SQL Server stores a backup history in the system catalog. This can be convenient as you perform restore operations because SQL Server will know through ...

Get SQL Server® 2008 Administration: Instant Reference now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.