Book Image

Microsoft System Center Data Protection Manager Cookbook

By : Charbel Nemnom, Patrick Lownds
Book Image

Microsoft System Center Data Protection Manager Cookbook

By: Charbel Nemnom, Patrick Lownds

Overview of this book

System Center Data Protection Manager (SCDPM) is a robust enterprise backup and recovery system that contributes to your BCDR strategy by facilitating the backup and recovery of enterprise data. With an increase in data recovery and protection problems faced in organizations, it has become important to keep data safe and recoverable. This book contains recipes that will help you upgrade to SCDPM and it covers the advanced features and functionality of SCDPM. This book starts by helping you install SCDPM and then moves on to post-installation and management tasks. You will come across a lot of useful recipes that will help you recover your VMware and Hyper-V VMs. It will also walk you through tips for monitoring SCDPM in different scenarios. Next, the book will also offer insights into protecting windows workloads followed by best practices on SCDPM. You will also learn to back up your Azure Stack Infrastructure using Azure Backup. You will also learn about recovering data from backup and implementing disaster recovery. Finally, the book will show you how to configure the protection groups to enable online protection and troubleshoot Microsoft Azure Backup Agent.
Table of Contents (17 chapters)
Title Page
Dedication
About Packt
Contributors
Preface
Index

Enabling SQL Server protection with DPM


One of the most important Microsoft workloads present in any modern data center is the SQL Server, on account of the majority of enterprise applications that use its functionality. 

With Microsoft SCDPM, you can enable SQL Server protection in various configurations. Typical SQL Server configurations include standalone SQL Server, SQL Server Failover Cluster Instance (FCI) with Windows Server failover clustering, as well as SQL Server deployed as an AlwaysOn availability group.

In this recipe, we will provide you with the necessary information to protect SQL Server workloads.

Getting ready

You can deploy Microsoft SQL Server in a VM or in a physical machine. In either case, you must install the DPM agent on the SQL Server machine. If SQL Server is deployed in a clustered mode or as a SQL AlwaysOn, then the DPM agent must be installed on all the nodes that are part of the failover cluster for the SQL Server instance. And if you add any node to the cluster...