Chapter 17. Backing Up and Restoring the SQL Server 2005 Environment

Although the key to implementing database technologies is installing the software in a production environment, it is equally important to ensure the new technology environment is being correctly backed up. Having a proper plan and backup process lends assurance that a successful recovery process can be initiated if an organization experiences problems with its systems, servers, or sites.

This chapter covers the areas database administrators and organizations need to consider when conducting SQL Server backups and recoveries. Specifically, this chapter highlights the new facts about backup and recovery included in SQL Server 2005 Service Pack 2. A discussion of the items that ...

Get Microsoft now with O’Reilly online learning.

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