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
  • Manage your Dell EMC sites, products, and product-level contacts using Company Administration.

PowerProtect Data Manager 19.15 Microsoft SQL Server User Guide

Troubleshooting centralized Microsoft SQL Server virtual machine restore operations

You can use the information in the following topics to troubleshoot issues with the centralized Microsoft SQL Server virtual machine restore operations.

Troubleshooting the PowerProtect agent service registration

With a virtual machine that is part of a protection policy, the failure of the PowerProtect agent service registration causes the virtual machine asset configuration to also fail. Despite these failures:

  • The protection policy backups continue to run.
  • The virtual machine configuration job continues to run if the virtual machine asset configuration did not fail for other reasons.

You can perform the following steps to troubleshoot these failures:

  1. Review the job details for the virtual machine configuration in PowerProtect Data Manager.
  2. Enable the Microsoft application agent debugging on the client. Run the following command on the command line, where <n> is the debug level from 1 to 9. The default debug level is 0:

    msagentcon --administration --debug=<n>

    When you set the debug level to a value from 1 to 9, the Microsoft application agent generates the debug logs on the virtual machine when the PowerProtect protection group runs. To deactivate the debug logs, set the debug level to 0.

  3. After the next failed job, inspect the following logs:

    • Microsoft application agent diagnostic logs in C:\Program Files\DPSAPPS\MSAPPAGENT\bin\msagentcon.XXXXX.log
    • Agent service log in agentsvc.log in the agent service home directory on the Microsoft SQL Server host
    • ADM log from PowerProtect in C:\Program Files\DPSAPPS\AgentService\logs\OPAgentSVC.xxx.log

Troubleshooting the PowerProtect Data Manager restores

You can perform the following tasks to troubleshoot issues with the PowerProtect Data Manager restores:

  • Inspect the ADM logs in /var/log/brs/adm/adm.log in PowerProtect Data Manager.
  • Inspect the Microsoft application agent logs in C:\Program Files\DPSAPPS\MSAPPAGENT\logs.
  • Enable advanced debugging output for the PowerProtect agent service by setting the DEBUG parameter in the file config.yml in the agent service installation directory.
  • Enable advanced debugging output for the Microsoft application agent by setting the debug option in the PowerProtect Data Manager restore wizard. The preceding topics about how to perform the centralized restores describe how you can set the Troubleshooting option, which causes the application agent to generate the diagnostic logs.

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