Skip to main content
Sign Out

Welcome to Dell

My Account
  • 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
  • Manage your Dell EMC sites, products, and product-level contacts using Company Administration.
Sign In Create an Account Dell Financial Services Premier Sign In Partner Program Sign In
Contact Us

Your Dell.com Carts

PowerProtect Data Manager 19.16 Microsoft SQL Server User Guide

PDF

Enable the Microsoft application agent after Microsoft SQL Server upgrade

Perform the following steps to enable the Microsoft application agent operations after a major version upgrade of the Microsoft SQL Server on the Microsoft application agent host.

Prerequisites

Before you perform a Microsoft SQL Server major version upgrade:

  • Ensure that no centralized or self-service backup jobs are running.
  • Ensure that you update the Microsoft application agent according to Update the Microsoft application agent. This prerequisite ensures that duplicate assets are not created in PowerProtect Data Manager.

About this task

NOTE:Microsoft SQL Server upgrades on the Microsoft application agent host are supported only with Microsoft application agent version 19.13 or later.

On Windows, you can start, stop, or obtain the status of the PowerProtect agent service from the Services Manager, similar to other Windows services. The name of the service in the Services Manager is PowerProtect Agent Services.

Steps

  1. Disable the protection policies on the Microsoft SQL Server host.
  2. Stop the PowerProtect agent service.
  3. Upgrade the Microsoft SQL Server for stand-alone, cluster, and AAG environments.
    NOTE:For cluster and AAG environments, upgrade all nodes in the cluster or AAG before you start the PowerProtect agent service.
  4. After the Microsoft SQL Server services are started, start the PowerProtect agent service.
  5. Enable the protection policies that were disabled in step 1.
  6. Perform a manual discovery of the Microsoft SQL Server hosts using PowerProtect Data Manager.
  7. Ensure that assets have not been removed from the protection policies.
  8. Run a protection policy backup.

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: <>()\