Configuring the SQL Backend Servers

Applies To: System Center 2012 - Data Protection Manager, System Center 2012 R2 Data Protection Manager, System Center 2012 SP1 - Data Protection Manager

The following prerequisites are required on the SQL Server backend servers:

SQL Server Prerequisites

If you are running Windows Server 2003 and have installed Knowledge Base article 940349, then you must install at least Microsoft SQL Server 2005 with Service Pack (SP1) or Microsoft SQL Server 2000 with SP4.

Note

System Center 2012 – Data Protection Manager (DPM) supports Standard, Enterprise, Workgroup, and Express Editions of SQL Server.

You must start the SQL Server VSS Writer Service on computers running SQL Server before you can start protecting SQL Server data. The SQL Server VSS Writer Service is turned on by default on computers running SQL Server. To start the SQL Server VSS Writer service, in the Services console, right-click SQL Server VSS writer, and then click Start.