PowerProtect Data Manager 19.11 Microsoft SQL Server User Guide

When you try to delete such copies by using the ddbmexptool or msagentadmin tool, you receive the following error message:

Write and delete operations are not supported on the storage unit '<storage_unit_pathname>' because the storage unit is managed by the PowerProtect Data Manager system.

To delete the expired backup copies, you can use the following procedures from the PowerProtect Data Manager UI or Microsoft SQL Server host:

• From the PowerProtect Data Manager UI, select the expired backup copies and delete the backup copies by clicking the Delete button.

• From the Microsoft SQL Server host, perform the following steps:

  1. Open the <installation_path>\Settings\.app.settings file for editing. The file content is in XML format, for example:

     <?xml version="1.0" encoding="utf-8"?>
     <?xml version="1.0" encoding="utf-8"?>
     <settings>
     <credentials>
     <credential>
     <ddHostName>10.31.140.153</ddHostName>
     <devicePath>sql_rc-5b2bbffe443d-6451a</devicePath>
     <ddUser>sql_rc-5b2bbffe443d-6451a</ddUser>
     <type>PROTECTION</type>
     <protocol>DDBOOST</protocol>
     <encryptionOverWire>false</encryptionOverWire>
     <retentionLock>false</retentionLock>
     <retentionPeriod>86400</retentionPeriod>
     <configName>sql_rc</configName>
     <sources>
     <name>INST1_SQL2012::dell1</name>
     <name>INST1_SQL2012::dell2</name>
     <name>MSSQLSERVER::dell_1</name>
     <name>MSSQLSERVER::dell_2</name>
     </sources>
     </credential>
     </credentials>
     </settings>
     

  2. In the <installation_path>\Settings\.app.settings file, locate the section between the <credential> and </credential> tags that contains the <ddHostName>, <devicePath>, <ddUser>, and <type> tags for the DD or MTree where the backup copies are generated and onboarded to PowerProtect Data Manager.

  3. Delete that section in the <installation_path>\Settings\.app.settings file.

     CAUTION Delete only the tags <ddHostName>, </ddHostName>, <devicePath>, </devicePath>, <ddUser>, </ddUser>, <type>, and </type> and the information between those tags. Do not delete any other tags or information in the file, which contain the DD details that the PowerProtect Data Manager generates.