Chapter 5. SQL Protection
In this chapter, we will cover how System Center 2012 R2 Data Protection Manager can protect the SQL Server workloads within your datacenter.
We will cover the following topics:
- Understanding SQL Server's protection considerations
- Configuring your SQL Server 2012 for DPM protection
- Understanding the SQL Server management tasks from a DPM perspective
- Protecting SQL Server 2012 AlwaysOn
- Protecting an availability group using SQL Server's AlwaysOn configuration
- Protecting your SQL Server databases
- Enabling parallel backups
- Configuring the auto-protection feature
- Configuring online protection
- Restoring a SQL Server database to its original location
- Restoring a SQL Server database to an alternative location
- Restoring a SQL Server database and renaming the database
- Restoring a SQL Server database to a network location
- Restoring a SQL Server database from Azure
- Restoring a SQL Server database from tape
- Restoring a SQL databases using the Latest feature