Microsoft SQL Server Protection

This chapter describes procedures used to protect Microsoft SQL Server 2005 and later environments. This chapter covers protecting Microsoft SQL 2005 and later with agent- based backups. If your SQL server is a VMware virtual machine, you can either run vProtect application-aware backups as described in the Protecting VMware Infrastructure chapter, or install the Windows agent and implement protection as described here. For a comparison of each strategy, see Best practices for protecting VMware virtual machines. If you’re using SQL 2000, see Legacy SQL Server agent.

See the following topics for details:

     About SQL Server protection

     Executing SQL backups

     SQL Server backups status

     Restoring SQL backups

     SQL restore from the replication target