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

Configuring your SQL Server 2012 for DPM protection


This recipe will cover how you configure your SQL Server 2012 for System Center 2012 R2 Data Protection Manager to be able to protect the SQL Server 2012 databases.

Getting ready

Microsoft took a new security approach with the release of Microsoft SQL Server 2012 and further restricted who actually is granted SA rights. This is a great approach, but it also causes some headaches for some backup administrators who are not familiar with how the SA rights work or operate in SQL Server.

As a DPM administrator, it is important that you implement the right security approach to protect and recover the SQL Server technology. It is not a recommended idea to grant too many rights in a system; instead, provide just the needed security rights so that DPM can operate without causing unnecessary security exposure.

If you don't give DPM the appropriate security rights, your DPM server will generate a critical alert stating Unable to configure protection,...