Enabling parallel backups
For the protection of larger SQL implementations using DPM, it is important to understand how to design the protection in an optimal way to gain the benefits that reside in both products. This recipe will explain the design considerations that must be done to be able to use the parallel backup feature.
Getting ready
The possibility to optimize a SQL database backup is something that is already present within the SQL Server code. The function parallel backup was written in the 2008 version of SQL Server; to be able to use it, you need to set up your DPM protection in a specific way.
How to do it…
When DPM backs up the SQL databases that are present in a SQL instance, the backup will be provided in a serial fashion. If the SQL implementation hosts databases that have a low value of RPO, the SQL team should place the databases in another SQL instance to enable the parallel backup feature.
How it works...
System Center 2012 R2 Data Protection Manger will adapt to the SQL...
