Non-Microsoft backup solutions tend to take generic backup functionality and adapt it to support-specific applications. In contrast, Microsoft created DPM 2010 to leverage fully supported Microsoft technologies in order to provide near-continuous data protection including Windows Server hosts running Microsoft SQL Server 2005, 2008 and 2008 R2. This support includes:
DPM 2010 is engineered to provide the best possible protection for SQL Server. In fact, the team that built DPM 2010 worked in consultation with the team that built SQL Server to ensure that SQL Server workloads are reliably protected.
DPM 2010 seamlessly interacts in the following ways with the SQL Server VSS writer to capture consistent versions of an SQL deployment without interrupting access databases:
Best Practices when backup SQL with DPM 2010
Here are some basic best practices for managing data with a DPM 2010 deployment: