PowerProtect Data Manager Centralized restore for SQL System databases

Summary: PowerProtect Data Manager Centralized restore for SQL System databases fails with error code ARS0001

This article applies to This article does not apply to This article is not tied to any specific product. Not all product versions are identified in this article.

Symptoms

Centralized restore using PowerProtect Data Manager UI to restore SQL System databases fails with the following error:

8 ddbmsqlrc PowerProtect Data Manager critical The tail of the log for the database "model" has not been backed up. Use BACKUP LOG WITH NORECOVERY to backup the log if it contains work you do not want to lose. Use the WITH REPLACE or WITH STOPAT clause of the RESTORE statement to just overwrite the contents of the log.

While Restore from Microsoft SQL Management Studio Plug-in for the system databases works fine. 

 

Cause

This is as per design because the restore from Microsoft SQL Management Studio Plug-in includes the "With Replace" 

ddbmsqlrc PowerProtect Data Manager info RESTORE database [model] FROM virtual_device='EMC#6b9e7ed7-77fd-42d6-b6c4-7aee3f5e8fdf', virtual_device='EMC#6b9e7ed7-77fd-42d6-b6c4-7aee3f5e8fdf_2', virtual_device='EMC#6b9e7ed7-77fd-42d6-b6c4-7aee3f5e8fdf_3', virtual_device='EMC#6b9e7ed7-77fd-42d6-b6c4-7aee3f5e8fdf_4' WITH replace, maxtransfersize = 4194304, norecovery

However Centralized restore does not include "With Replace"  

RESTORE database [model] FROM virtual_device='EMC#98acba21-936a-4690-87b8-e1aaafdb3d4c', virtual_device='EMC#98acba21-936a-4690-87b8-e1aaafdb3d4c_2', virtual_device='EMC#98acba21-936a-4690-87b8-e1aaafdb3d4c_3', virtual_device='EMC#98acba21-936a-4690-87b8-e1aaafdb3d4c_4'  WITH maxtransfersize = 4194304'

Resolution

The fix to include "With Replace" for Centralized restore of system Database will be available in PowerProtect Data Manager Agent 19.21 Release

Affected Products

PowerProtect Data Manager
Article Properties
Article Number: 000345684
Article Type: Solution
Last Modified: 31 Jul 2025
Version:  2
Find answers to your questions from other Dell users
Support Services
Check if your device is covered by Support Services.