Book Image

Microsoft System Center Data Protection Manager 2012 R2 Cookbook

By : Robert Heldblom, Robert Hedblom
Book Image

Microsoft System Center Data Protection Manager 2012 R2 Cookbook

By: Robert Heldblom, Robert Hedblom

Overview of this book

Table of Contents (21 chapters)
Microsoft System Center Data Protection Manager 2012 R2 Cookbook
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
Index

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 the...