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

Related Content you might be interested in

Current Title:

Small book image
Microsoft System Center Data Protection Manager 2012 R2 Cookbook
Robert Heldblom | Robert Hedblom
Apr, 2015 | 408 pages
No titles found
Table of Contents (21 chapters)
Microsoft System Center Data Protection Manager 2012 R2 Cookbook
Microsoft System Center Data Protection Manager 2012 R2 Cookbook
Credits
Credits
About the Author
About the Author
About the Reviewers
About the Reviewers
www.PacktPub.com
www.PacktPub.com
Preface
Preface
Free Chapter
1
Pre-installation Tasks
Pre-installation Tasks
Introduction
What is System Center Data Protection Manager 2012 R2
Change tracking process
Planning your DPM pre-installation tasks
Planning the DPM disk pool
Firewall configuration
2
Installation and Upgrade
Installation and Upgrade
Introduction
Installing a SQL Server locally on the DPM server
Preparing a remote SQL Server for DPMDB
Installing SCDPM 2012 R2
Installing SCDPM 2012 R2 using a remote SQL server or cluster
Understanding the supported upgrade scenarios
3
Post-installation Tasks
Post-installation Tasks
Introduction
Understanding the DPM terminology
Configuring the DPM disk pool
Adding disk to the DPM disk pool
Growing volumes automatically in the DPM disk pool
Creating a replica manually
Installing the DPM agent via the DPM console
Installing the DPM agent manually
Upgrading the DPM agents
Configuring DPM agent throttling
Understanding DPM Protection Groups
Optimizing the Protection Group
DPMDB optimization
Report management
Configuring a dedicated backup network
Configuring e-mail notifications
Applying update rollups (UR) to the DPM server
Working with filters
4
File Server Protection
File Server Protection
Introduction
Understanding the prerequisites for supported file server protection
Protecting file shares, volumes, and catalogs
Restoring file data to its original location
Restoring file data to an alternative location
Copying protected data to tape
Restoring file data from tape
Restoring file data from Azure
Protecting file server clusters
Understanding file server maintenance and management tasks
Creating recovery points manually
Using Migrate-Datasource.ps1
5
SQL Protection
SQL Protection
Introduction
Understanding SQL Server protection considerations
Configuring your SQL Server 2012 for DPM protection
Understanding the SQL Server management tasks from a DPM perspective
Protecting SQL Server 2012 AlwaysOn
Protecting an availability group using SQL Server AlwaysOn configuration
Protecting your SQL Server databases
Enabling parallel backups
Configuring the auto-protection feature
Configuring online protection
Restoring a SQL Server database to its original location
Restoring a SQL Server database to an alternative location
Restoring a SQL Server database and renaming the database
Restoring a SQL database to a network location
Restoring a SQL database from Azure
Restoring a SQL Server database from tape
Restoring SQL databases using the Latest feature
6
Hyper-V Protection
Hyper-V Protection
Introduction
Understanding the prerequisites for Hyper-V protection
Understanding the considerations for Hyper-V protection
Protecting large-scale Hyper-V environments
Protecting System Center Virtual Machine Manager
Integrating SCDPM with SCVMM
Restoring a Hyper-V virtual machine
Restoring a VHD or VHDX
Using ILR (Item Level Restore)
Understanding Hyper-V management tasks
7
SharePoint Protection
SharePoint Protection
Introduction
Understanding the prerequisites for supported SharePoint server protection
Configuring the SharePoint VSS
Protecting a SharePoint farm
Protecting a SharePoint search
Protecting a SharePoint farm that uses SQL aliases
Restoring a SharePoint farm
Restoring individual objects (Item-level recovery)
Understanding SharePoint maintenance tasks
Understanding SharePoint management tasks
8
Exchange Server Protection
Exchange Server Protection
Introduction
Understanding the prerequisites for supported Exchange server protection
Configuring Exchange server protection
Understanding how to adapt DPM to Exchange server management tasks
Understanding how to adapt DPM to Exchange server maintenance tasks
Protecting a single Exchange mailbox database
Understanding how DPM protects DAG configurations
Understanding how DPM can verify data integrity using ESEUTIL
Restoring an Exchange mailbox database to its original location
Restoring an Exchange mailbox database to an alternative location
Restoring an Exchange mailbox database to an Exchange Recovery Database
Restoring an Exchange mailbox database to a network folder
Copying the Exchange mailbox database to tape
9
Client Protection
Client Protection
Introduction
Finding and understanding Company Protection Policy
Understanding the prerequisites of client protection
Creating a Protection Group for client protection
Restoring client data via the DPM client
Restoring client data from the DPM server
Setting up the end user recovery feature
Setting up the DPM self service recovery for SQL
10
Workgroup Protection and CBA
Workgroup Protection and CBA
Introduction
Understanding workgroup protection
Understanding CBA protection
Setting up workgroup protection
Setting up certificate-based authentication
11
Azure Integration
Azure Integration
Introduction
Understanding the prerequisites for the Microsoft Azure backup service
Configuring your DPM server for online protection
Registering your DPM server
Configuring the protection groups to enable online protection
Manually creating online recovery points
Recovering production data from Azure
Troubleshooting Microsoft Azure Backup Agent
12
Disaster Recovery
Disaster Recovery
Introduction
Understanding the primary/secondary DPM server scenario
Enabling a DPM server to be a secondary DPM server
Enabling the chaining of DPM servers
Understanding the replication process from the primary to secondary DPM server
Switching from the primary to secondary DPM server
Restoring data from a secondary DPM server
Restoring a DPM server
13
Tape Management
Tape Management
Introduction
Understanding the basics of tape backups
Installing tape libraries and stand-alone tape drives
Understanding the concept of VTL
Understanding how DPM manages tapes
Configuring tape optimization for DPM
Understanding tape reports in DPM
Configuring the short erase feature
Understanding tape management tasks
14
Monitoring and Automation
Monitoring and Automation
Introduction
Understanding how the System Center family should be your base for service delivery
Understanding System Center Operations Manager 2012 R2
Understanding System Center Orchestrator 2012 R2
Understanding the DPM PowerShell Cmdlet
Installing System Center Operations Manager
Installing System Center Orchestrator
Installing the DPM Central Console
Understanding how to configure System Center Orchestrator for DPM automation
Index
Index

Chapter 5. SQL Protection

In this chapter, we will cover how System Center 2012 R2 Data Protection Manager can protect the SQL Server workloads within your datacenter.

We will cover the following topics:

  • Understanding SQL Server's protection considerations

  • Configuring your SQL Server 2012 for DPM protection

  • Understanding the SQL Server management tasks from a DPM perspective

  • Protecting SQL Server 2012 AlwaysOn

  • Protecting an availability group using SQL Server's AlwaysOn configuration

  • Protecting your SQL Server databases

  • Enabling parallel backups

  • Configuring the auto-protection feature

  • Configuring online protection

  • Restoring a SQL Server database to its original location

  • Restoring a SQL Server database to an alternative location

  • Restoring a SQL Server database and renaming the database

  • Restoring a SQL Server database to a network location

  • Restoring a SQL Server database from Azure

  • Restoring a SQL Server database from tape

  • Restoring a SQL databases using the Latest feature

Previous Section
End of Section 1
Next Section