Skip to main content
  • Place orders quickly and easily
  • View orders and track your shipping status
  • Enjoy members-only rewards and discounts
  • Create and access a list of your products

PowerProtect Data Manager 19.16 Microsoft SQL Server User Guide

Preface

As part of an effort to improve product lines, periodic revisions of software and hardware are released. Therefore, all versions of the software or hardware currently in use might not support some functions that are described in this guide. The product release notes provide the most up-to-date information about product features.

If a product does not function correctly or does not function as described in this guide, contact Customer Support.

NOTE:This guide was accurate at publication time. To ensure that you are using the latest version of this guide, go to the Customer Support website.

Product naming

Data Domain (DD) is now PowerProtect DD. References to Data Domain or Data Domain systems in this guide, in the user interface, and elsewhere in the product include PowerProtect DD systems and older Data Domain systems.

Isilon is now PowerScale. References to Isilon, Isilon products, or Isilon appliances in this guide, in the user interface, and elsewhere in the product include PowerScale products and appliances.

In many cases the user interface has not yet been updated to reflect these changes.

Language use

This guide might contain language that is not consistent with Dell Technologies current guidelines. Dell Technologies plans to update the guide over subsequent future releases to revise the language accordingly.

This guide might contain language from third-party content that is not under Dell Technologies control and is not consistent with the current guidelines for Dell Technologies own content. When such third-party content is updated by the relevant third parties, this guide is revised accordingly.

Acronyms

The acronyms that are used in this guide might not be familiar to everyone. Although most acronyms are defined on their first use, a definition is not always provided with later uses of the acronym. For a list of all acronyms and their definitions, see the glossary at the end of the guide.

Website links

The website links used in this guide were valid at publication time. If you find a broken link, provide feedback on the guide, and a Dell Technologies employee will update the link in the next release as necessary.

Purpose

This guide describes how to configure and use the DellPowerProtect Data Manager software to back up and restore the data in a Microsoft SQL Server environment.

Audience

This guide is intended for the host system administrator who configures and uses the PowerProtect Data Manager with the Microsoft application agent to back up and restore Microsoft SQL Server.

Revision history

The following table presents the revision history of this guide.

Table 1. Revision historyRevision history
Revision Date Description
01 March 2024 Initial release of this guide for PowerProtect Data Manager version 19.16.

Compatibility information

Software compatibility information for the PowerProtect Data Manager software is provided by the E-Lab Navigator.

Related documentation

The following publications are available at Customer Support and provide additional information:

Table 2. Related documentationRelated documentation
Title Content
PowerProtect Data Manager Administrator GuideThis guide describes how to configure, use and administer the DellPowerProtect Data Manager software. This guide also includes disaster recovery procedures. Procedures specific to asset protection are provided in the individual user guides.
PowerProtect Data Manager Deployment GuideThis guide describes how to deploy and license the DellPowerProtect Data Manager software.
PowerProtect Data Manager Release NotesThis guide contains information about new features, known limitations, environment, and system requirements for the DellPowerProtect Data Manager software.
PowerProtect Data Manager Security Configuration GuideThis guide describes security information related to the deployment, configuration, administration and use of the DellPowerProtect Data Manager software.
PowerProtect Data Manager Amazon Web Services Deployment GuideThis guide describes how to deploy the DellPowerProtect Data Manager software to Amazon Web Services (AWS).
PowerProtect Data Manager Azure Deployment GuideThis guide describes how to deploy the DellPowerProtect Data Manager software to Microsoft Azure.
PowerProtect Data Manager Google Cloud Platform Deployment GuideThis guide describes how to deploy the DellPowerProtect Data Manager software to Google Cloud Platform (GCP).
PowerProtect Data Manager Cloud Disaster Recovery Administration and User GuideThis guide describes how to deploy the Dell Cloud Disaster Recovery (Cloud DR) solution, protect virtual machines in the AWS or Azure cloud, and run recovery operations.
PowerProtect Data Manager Cyber Recovery User GuideThis guide describes how to install, update, patch, and uninstall the Dell PowerProtect Cyber Recovery software.
PowerProtect Data Manager File System User GuideThis guide describes how to configure and use the DellPowerProtect Data Manager software with the File System agent for file-system data protection.
PowerProtect Data Manager Kubernetes User GuideThis guide describes how to configure and use the DellPowerProtect Data Manager software to back up and restore namespaces and PVCs in a Kubernetes cluster or Tanzu Kubernetes cluster.
PowerProtect Data Manager Microsoft Exchange Server User GuideThis guide describes how to configure and use the DellPowerProtect Data Manager software to back up and restore the data in a Microsoft Exchange Server environment.
PowerProtect Data Manager Microsoft SQL Server User GuideThis guide describes how to configure and use the DellPowerProtect Data Manager software to back up and restore the data in a Microsoft SQL Server environment.
PowerProtect Data Manager Oracle RMAN User GuideThis guide describes how to configure and use the DellPowerProtect Data Manager software to back up and restore the data in an Oracle Server environment.
PowerProtect Data Manager SAP HANA User GuideThis guide describes how to configure and use the DellPowerProtect Data Manager software to back up and restore the data in an SAP HANA Server environment.
PowerProtect Data Manager Network-Attached Storage User GuideThis guide describes how to configure and use the DellPowerProtect Data Manager software to protect and recover the data on network-attached storage (NAS) shares and appliances.
PowerProtect Data Manager Virtual Machine User GuideThis guide describes how to configure and use the DellPowerProtect Data Manager software to back up and restore virtual machines and virtual machine disks (VMDKs) in a vCenter Server environment with VMware vSphere Storage APIs – Data Protection (VADP) or the Transparent Snapshots Data Mover (TSDM).
PowerProtect Data Manager Storage Array User GuideThis guide describes how to configure and use the DellPowerProtect Data Manager software to protect and restore data on PowerStore storage arrays.
VMware Cloud Foundation Disaster Recovery With PowerProtect Data ManagerThis guide provides a detailed description of how to perform an end-to-end disaster recovery of a VMware Cloud Foundation (VCF) environment.
PowerProtect Data Manager Public REST API documentationThis documentation contains the DellDell Technologies APIs and includes tutorials to guide you in their use.
vRealize Automation Data Protection Extension for Data Protection Systems Installation and Administration GuideThis guide describes how to install, configure, and use the vRealize Data Protection Extension.

Typographical conventions

The following type style conventions are used in this guide:

Table 3. Style conventionsStyle conventions
Formatting Description
BoldUsed for interface elements that a user specifically selects or clicks, for example, names of buttons, fields, tab names, and menu paths. Also used for the name of a dialog box, page, pane, screen area with title, table label, and window.
ItalicUsed for full titles of publications that are referenced in the text.
MonospaceUsed for:
  • System code
  • System output, such as an error message or script
  • Pathnames, file names, file name extensions, prompts, and syntax.
  • Commands and options
Monospace italicUsed for variables.
Monospace boldUsed for user input.
[ ] Square brackets enclose optional values.
| Vertical line indicates alternate selections. The vertical line means or for the alternate selections.
{ } Braces enclose content that the user must specify, such as x, y, or z.
... Ellipses indicate non-essential information that is omitted from the example.

You can use the following resources to find more information about this product, obtain support, and provide feedback.

Where to find product documentation

To find the latest documentation, navigate to the PowerProtect Data Manager Info Hub or type www.dell.com/ppdmdocs in your browser, or scan the following QR code on your mobile device.

QR code

Where to get support

The Customer Support website provides access to product licensing, documentation, advisories, downloads, and how-to and troubleshooting information. The information can enable you to resolve a product issue before you contact Customer Support.

To access a product-specific page:

  1. Go to the Customer Support website.
  2. In the search field of the Identify your product or search support pane, type a product name, and then select the product from the list that appears.

Support Library

The Support Library contains a knowledge base of applicable solutions that you can search for either by solution number (for example, KB000xxxxxx) or by keyword.

To search the Support Library:

  1. Go to the Customer Support website.
  2. From the Support Library pane, click Find Articles.
  3. In the Support Library search field, type either the solution number or keywords. Optionally, you can limit the search to specific products by typing a product name in the search box, and then selecting the product from the list that appears.

Contact Customer Support

To view available support options:

  1. Go to the Customer Support website.
  2. From the Contact Support pane, click Contact Support.
  3. On the Contact Information page, click the link for the relevant support type.

Service requests

To obtain in-depth help from a support agent, submit a service request. To submit a service request:

NOTE:You must have a valid support agreement. For details about either an account or obtaining a valid support agreement, contact a sales representative.
  1. Go to the Customer Support website.
  2. From the Service Requests pane, click View Service Requests.
  3. Click the Create New Service Request button to create a new service request.

To review an open service request:

  1. Go to the Dell Customer Support website.
  2. On the Support tab, click Service Requests & Dispatch Status, and sign into your account.
  3. On the Service Requests page, click View All Service Requests.

Dell Community

For peer contacts, conversations, and content on product support and solutions, go to the Dell Community. Interactively engage with customers, partners, and certified professionals online.

How to provide feedback

Feedback helps to improve the accuracy, organization, and overall quality of publications. You can send feedback to DPADDocFeedback@dell.com.


Rate this content

Accurate
Useful
Easy to understand
Was this article helpful?
0/3000 characters
  Please provide ratings (1-5 stars).
  Please provide ratings (1-5 stars).
  Please provide ratings (1-5 stars).
  Please select whether the article was helpful or not.
  Comments cannot contain these special characters: <>()\