Article ID: 953871 - View products that this article applies to.
You cannot set up a protection group within Microsoft System Center Data Protection Manager (DPM) 2007 to back up the system state of a SQL server. This problem occurs if the following conditions are all true:
Event Type: Error
Event Type: Error
Backup Status Operation: Backup Active backup destination: File Media name: "<media name>" Volume shadow copy creation: Attempt 1. "MSDEWriter" has reported an error 0x800423f0. This is part of System State. The backup cannot continue. Error returned while creating the volume shadow copy:800423f0 Aborting Backup.
This problem occurs because of a flaw in the Ntbackup.exe application.
To work around this problem, use either of the following workarounds.
Workaround 1Move the SQL logs to the same volume as the SQL databases. Or, move the SQL database and logs to a volume that is not the boot volume.
Workaround 2DPM uses only a .cmd file to start the backup of the system state. The batch file name is C:\Program Files\Microsoft Data Protection Manager\DPM\bin\DPMSystemStateBackup.cmd.
You can change the third line in this the batch file so that it resembles the following:
Start /WAIT %SystemRoot%\system32\Ntbackup.exe backup systemstate "@c:\MySelection.bks" /F %1This line references a .bks file that tells NTBackup what to include in this backup. In this example, the .bks file is C:\MySelection.bks. The contents of this .bks file should resemble C:\Test.txt SystemState.
Note Here, C:\Test.txt is an example .txt file. You can name this file whatever you want.
We do not recommend that you create this .bks file by using notepad. It is a binary file. To create this file, follow these steps:
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.