PowerProtect Data Manager Centralized restore for SQL System databases

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

Tento článok sa vzťahuje na Tento článok sa nevzťahuje na Tento článok nie je viazaný na žiadny konkrétny produkt. V tomto článku nie sú uvedené všetky verzie produktov.

Symptómy

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. 

 

Príčina

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'

Riešenie

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

Dotknuté produkty

PowerProtect Data Manager
Vlastnosti článku
Číslo článku: 000345684
Typ článku: Solution
Dátum poslednej úpravy: 20 jan 2026
Verzia:  4
Nájdite odpovede na svoje otázky od ostatných používateľov spoločnosti Dell
Služby podpory
Skontrolujte, či sa na vaše zariadenie vzťahujú služby podpory.