Protecting a SharePoint Farm by Using Databases With SQL Server Aliases

  • Article

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

System Center 2012 – Data Protection Manager (DPM) supports protection of a SharePoint farm that uses SQL Server databases configured with SQL Server aliases. This additional support does not require any major changes in the procedure you use to protect or recover SharePoint data with DPM.

Important

You can use only TCP/IP aliases.

Prerequisites

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

  • The SQL Server client connectivity components must be installed on the front-end Web Server.

See Also

Other Resources

How to: Create a Server Alias for Use by a Client (SQL Server Configuration Manager)