Preparing a remote SQL Server for DPMDB

This recipe will cover the procedure to prepare a remote SQL server for hosting the DPMDB.

Getting ready

In the scenario where you build a large hosted DPM service solution delivering BaaS (Backup as a Service), RaaS (Restore as a Service), or DRaaS (Disaster Recovery as a Service) within your modern data center, you may want to use a dedicated backend SQL server that is either a standalone SQL server or a clustered one, for high availability.

Note

It is not advisable to use SQL Server Always-On to host the DPMDB.

Regardless of whether you put the DPMDB on a cluster or a backend standalone SQL server, you still need to perform some initial configurations prior to the actual DPM server installation.

How to do it…

After installing your backend SQL server solution you must prepare it for hosting the DPMDB.

Insert the DPM2012R2 media and run the setup. In the setup screen, click on the DPM Remote SQL Prep link.

The installation wizard will start and install...