Understanding SQL Server protection considerations
This section will provide you with the necessary information needed to understand what to consider before enabling a SQL data source for DPM protection.
Before you start to plan your protection for your SQL server workload, it is important that you understand the SQL server protection considerations. For all SQL Server versions, you must consider that SCDPM 2012 R2 does not support the protection of SQL Server data that is located on a remote file share. The protection will fail and generate the error ID 104.
Note
Never use both SCDPM 2012 R2 and the SQL Management Studio backup feature; the SQL Management Studio backup function will not update the SQL VSS information, so the DPM agent will lose track of the changed blocks, which can results in an inconsistent replica.
The supported SQL Server versions that could be protected using DPM are:
- SQL Server 2012
- SQL Server 2008 R2
- SQL Server 2008
- SQL Server 2005
Note
For DPM to protect SQL Server 2005...
