5. SQL Protection | Microsoft System Center Data Protection Manager 2012 R2 Cookbook

Sign In Start Free Trial

Book Overview & Buying
Table Of Contents

Microsoft System Center Data Protection Manager 2012 R2 Cookbook

By : Robert Heldblom, Robert Hedblom

4.6 (5)

Microsoft System Center Data Protection Manager 2012 R2 Cookbook

4.6 (5)

By: Robert Heldblom, Robert Hedblom

Overview of this book

If you are a DPM administrator, this book will help you verify your knowledge and provide you with everything you need to know about the 2012 R2 release. No prior knowledge about System Center DPM is required, however some experience of running backups will come in handy.

Preface

Preface

What this book covers

What you need for this book

Who this book is for

Sections

Conventions

Reader feedback

Customer support

Free Chapter

1. Pre-installation Tasks

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

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

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

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

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

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

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

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

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

10. Workgroup Protection and CBA

Introduction

Understanding workgroup protection

Understanding CBA protection

Setting up workgroup protection

Setting up certificate-based authentication

11. Azure Integration

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

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

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

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

Restoring a SQL Server database and renaming the database

This recipe will cover how to recover a SQL database but change the SQL alias for the database. A scenario for this is when you recover a development database to a production environment.

Getting ready

In the scenario that you would like to restore a SQL database with another SQL alias, you must keep in mind that if you restore the SQL database to the same SQL instance that it originates from, you must change the location of the database file and/or the log files for the database, or you cannot perform the restore operation.

If you don't specify an alternate file location, the restore job will fail and DPM will describe it as a VSS error.

How to do it…

Go to Recovery and choose the right database, date, and time in the DPM console. Right-click on the database and choose Recover… to start Recovery Wizard. In the Review Recovery Selection step, verify that you have chosen the right database and click on Next > to continue.
Choose the Recover...

Visually different images

CONTINUE READING

83

Tech Concepts

36

Programming languages

73

Tech Tools

Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.

Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.

50+ new titles added per month and exclusive early access to books as they are being written.

Microsoft System Center Data Protection Manager 2012 R2 Cookbook

Search

Your notes and bookmarks