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

Automating the installation of DPM


This recipe will cover how to automate the installation of DPM Server.

Getting ready

In the Installing DPM recipe in this chapter, we showed you how to install DPM using a local SQL Server and using a remote SQL Server. However, this was a manual installation. 

 

Automating the installation of DPM consists of two steps:

  1. Installing the SQL Server instance
  2. Installing the DPM server

You can disregard the first step if you already have SQL Server deployed locally or on a remote server in your environment.

In this recipe, we will cover the installation of SQL Server and DPM in an automated fashion. 

How to do it...

Make sure that your operating system is fully patched and rebooted before you start the installation. Now follow these steps:

  1. Install the SQL Server instance:
    1. Mount the SQL Server 2016 media and then open the Command Prompt (cmd).
    2. Browse to the drive letter where SQL Server is mounted.
    3. Type in the following command to automate the installation of SQL Server and add all of the required features:

Note

Please make sure to update the domain name and SQL Service accounts in the following command so that they match your environment.

Setup.exe /Q /ACTION=install /IACCEPTSQLSERVERLICENSETERMS /FEATURES=SQLEngine,RS /INSTANCENAME=DPMINSTANCE /INSTANCEDIR="D:\Program Files\Microsoft SQL Server" /INSTALLSHAREDWOWDIR="D:\Program Files (x86)\Microsoft SQL Server" /INSTALLSHAREDDIR="D:\Program Files\Microsoft SQL Server" /SQLSVCACCOUNT=”VIRT\sqldpm” /SQLSYSADMINACCOUNTS=”VIRT\sqldpm” /SQLSVCPASSWORD="dpm2016+1" /RSSVCACCOUNT=”VIRT\sqldpm” /RSSVCPASSWORD="dpm2016+1" /AGTSVCACCOUNT=”VIRT\sqldpm” /AGTSVCPASSWORD="dpm2016+1" /SECURITYMODE=SQL /SAPWD=”dpm2016+1” /SQLTEMPDBDIR=”D:\Program Files\Microsoft SQL Server\TempDB\\” /SQLUSERDBDIR=”D:\Program Files\Microsoft SQL Server\SQLData\\” /SQLUSERDBLOGDIR=”D:\Program Files\Microsoft SQL Server\SQLLog\\”

Please refer to the following screenshot for its output:

    1. Make sure that you have downloaded SQL Server Management Studio (SSMS) version 16.5.3 and that you have copied it to the server: http://go.microsoft.com/fwlink/?LinkID=840946.
    2. Open the cmd.exe window and type in the following command:
SSMS-Setup-ENU.exe /install /quiet /norestart

Note

Please note that the SSMS installation may take some time to finish.

  1. Install the DPM server:
    1. Open a command-line prompt in elevated mode and type in the following command:
dism.exe /Online /Enable-feature /All /FeatureName:Microsoft-Hyper-V /FeatureName:Microsoft-Hyper-V-Management-PowerShell /quiet /norestart

Note

DPM supports Item-Level Recovery (ILR), which allows you to perform a granular recovery of files, folders, volumes, and virtual hard disks (VHDXs) from a host-level backup of Hyper-V virtual machines. The Hyper-V Role and PowerShell Management Tools features are required by the DPM server. Please read Chapter 3, Protecting Hyper-V VMs, for more information.

    1. Once the Hyper-V role is installed, you need to restart the DPM server before you move on to the next step.
    1. Once the DPM server has been restarted, open Notepad, copy the following scripts into it, and then save the file as DPMSetup.ini:

Note

Please note that you can use the same script that follows, regardless of whether the SQL Server instance has been installed on the DPM server or on a remote SQL Server.

[OPTIONS]
 UserName=<Domain-name\Username>
 CompanyName=<Ur-Company>
 ProductKey=XXXX-XXXX-XXXX-XXXX-XXXX
 SqlAccountPassword=<The password for the SQL sa account>
 ProgramFiles = <Location path where you want to install DPM>
 DatabaseFiles = <Location path where you want to install DPMDB>
 IntegratedInstallSource = <Location path where the DPM media is extracted>
 SQLMachineName=<Name of the SQL Server Computer> OR <SQL Cluster Name>
 SQLInstanceName=<Name of the SQL Server instance>
 SQLMachineUserName=<Domain-name\Username> SQLMachinePassword=<Password for the user name Setup must use>
 SQLMachineDomainName=<Domain name to which the SQL Server computer is attached to>
 ReportingMachineName=<Name of the SQL Server Computer> OR <SQL Cluster Name>
 ReportingInstanceName=<Name of the SQL Server instance>
 ReportingMachineUserName=<Domain-name\Username>
 ReportingMachinePassword=<Password for the user name Setup must use>
 ReportingMachineDomainName=<Domain name to which the SQL Server computer is attached to>
    1. The following screenshot shows you what the DPMSetup.ini file will look like:
    1. After saving the DPMSetup.ini file, in an elevated command prompt on the DPM server, type in the following command and press Enter:
start /wait D:\SCDPM2016\setup.exe /i /f D:\DPMSetup.ini /l D:\dpmlog.txt

Note

The D:\SCDPM2016\ path indicates the media in the DPM location where you'll run setup.exeD:\DPMSetup.ini is the location path where you saved the DPMSetup.ini file.

    1. In just a few minutes, DPM will be installed automatically, as shown in the following screenshot:

Note

Finally, you need to install and update the DPM server to the latest Update Rollup (UR) if you are using the Long-Term Servicing Channel (LTSC). At the time of writing this book, DPM 2016 Update Rollup 6 has been released, and you can download it from the following link: https://www.catalog.update.microsoft.com/Search.aspx?q=4456327. If you are using the Semi-Annual Channel (SAC) for DPM (that is, DPM 1801, 1807, 1901, and so on), then the Semi-Annual Channel, with its more frequent release cycle, does not receive update releases.

How it works...

The final result of an automated installation will be better than a manual implementation. Thus, this will ensure that you have a consistent deployment across your environment.

 

 

See also

Check out the following blog post to learn more about how to automate the installation of DPM using System Center Virtual Machine Manager: https://charbelnemnom.com/2017/01/how-to-deploy-dpm-2016-using-vmm-2016-on-ws2016-scdpm-scvmm-sysctr-hyperv-ws2016/.