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 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.