MSDN Library

Protecting Farms Using Databases With SQL Server Aliases

Updated: February 1, 2010

Applies To: System Center Data Protection Manager 2007

System Center Data Protection Manager (DPM) 2007 SP1 extends DPM support for SharePoint to include support for SharePoint farm that uses SQL Server databases configured with SQL Server aliases. This additional support does not translate into any major changes in the procedure to protect or recover SharePoint data in DPM.

You can only use TCP/IP aliases.


For farms using mirrored databases

  • You must configure SQL Server aliases on the front-end Web Server. All SQL Server aliases in the farm must be defined on the front-end Web Server. We recommend that you use one SQL Server alias per database.

  • Front-end Web Server must have SQL Server client connectivity components installed.

If you do not define all the SQL Server aliases on the front-end Web Server on which the SharePoint VSS Writer is running, DPM will be unable to find the databases that uses these SQL Server aliases in the farm.

See Also

Community Additions

© 2016 Microsoft