none
DPM 2010 fail to backup server system states when SQL VSS Writer is running RRS feed

  • Question

  • As above DPM 2010/windows server backup  fail to backup server system states when SQL VSS Writer is running.

    When i disabled it the backup are able to complete, however some backup will fail when they are trying to backup SQL db

    sql vss writer version is 10.51.2500.0

    Server OS: windows server 2008 R2

    right now the current result of list writer:

    For now when ever i back up the system state , i will need to disable sql vss writer service.

    After the backup completed, i will enable back.

    Microsoft Windows [Version 6.1.7601]
    Copyright (c) 2009 Microsoft Corporation.  All rights reserved.

    C:\Windows\system32>vssadmin list writers
    vssadmin 1.1 - Volume Shadow Copy Service administrative command-line
    (C) Copyright 2001-2005 Microsoft Corp.

    Writer name: 'Task Scheduler Writer'
       Writer Id: {d61d61c8-d73a-4eee-8cdd-f6f9786b7124}
       Writer Instance Id: {1bddd48e-5052-49db-9b07-b96f96727e6b}
       State: [1] Stable
       Last error: No error

    Writer name: 'VSS Metadata Store Writer'
       Writer Id: {75dfb225-e2e4-4d39-9ac9-ffaff65ddf06}
       Writer Instance Id: {088e7a7d-09a8-4cc6-a609-ad90e75ddc93}
       State: [1] Stable
       Last error: No error

    Writer name: 'Performance Counters Writer'
       Writer Id: {0bada1de-01a9-4625-8278-69e735f39dd2}
       Writer Instance Id: {f0086dda-9efc-47c5-8eb6-a944c3d09381}
       State: [1] Stable
       Last error: No error

    Writer name: 'SqlServerWriter'
       Writer Id: {a65faa63-5ea8-4ebc-9dbd-a0c4db26912a}
       Writer Instance Id: {68606f72-1da7-460c-889e-9b26b126f388}
       State: [1] Stable
       Last error: No error

    Writer name: 'System Writer'
       Writer Id: {e8132975-6f93-4464-a53e-1050253ae220}
       Writer Instance Id: {c2593c06-d731-4874-875d-a436c9fb89d4}
       State: [1] Stable
       Last error: No error

    Writer name: 'ASR Writer'
       Writer Id: {be000cbe-11fe-4426-9c58-531aa6355fc4}
       Writer Instance Id: {11a18d16-18c2-4bbe-8cfe-20b4d9a1e08d}
       State: [1] Stable
       Last error: No error

    Writer name: 'DFS Replication service writer'
       Writer Id: {2707761b-2324-473d-88eb-eb007a359533}
       Writer Instance Id: {9b9f07a1-c21c-4cb5-9cd3-bdb2eafbd5f9}
       State: [1] Stable
       Last error: No error

    Writer name: 'Shadow Copy Optimization Writer'
       Writer Id: {4dc3bdd4-ab48-4d07-adb0-3bee2926fd7f}
       Writer Instance Id: {71d25810-a9c3-41e9-8607-7fb689a8eed9}
       State: [1] Stable
       Last error: No error

    Writer name: 'Registry Writer'
       Writer Id: {afbab4a2-367d-4d15-a586-71dbb18f8485}
       Writer Instance Id: {bbb31373-f1f5-4001-a4fa-44ee760ac224}
       State: [1] Stable
       Last error: No error

    Writer name: 'COM+ REGDB Writer'
       Writer Id: {542da469-d3e1-473c-9f4f-7847f01fc64f}
       Writer Instance Id: {136e0497-24e4-434c-b552-25598aa1c0f2}
       State: [1] Stable
       Last error: No error

    Writer name: 'WMI Writer'
       Writer Id: {a6ad56c2-b509-4e6c-bb19-49d8f43532f0}
       Writer Instance Id: {9977fe2a-be4e-4123-8db3-a71d8c4b0633}
       State: [1] Stable
       Last error: No error


    Best regards, Damien Ng

    Thursday, January 10, 2013 5:22 AM

All replies

  • Hi

    Below are the steps that can be performed to start the System State Backup without stopping the SQL Service.

    a) Run VSSADMIN LIST WRITERS to get the Writer ID:

    Writer name: 'SqlServerWriter'
        Writer Id: {a65faa63-5ea8-4ebc-9dbd-a0c4db26912a}
        Writer Instance Id: {68606f72-1da7-460c-889e-9b26b126f388}


    b) Exclude the SQL writer ID {a65faa63-5ea8-4ebc-9dbd-a0c4db26912a} using the following steps:

    Under the Registry key "HKLM\Software\Microsoft\Windows NT\CurrentVersion\SPP", create a new MULTI_SZ-value with the name “DisabledWriters”.

                (For 64-bit OS use: "HKLM\Software\Wow6432Node\Microsoft\Windows NT\CurrentVersion\SPP")

                a. Enter the writer GUID with braces as the value.
                b) Shut down Windows Block Level Backup Engine service if it’s running. You can use command "net stop wbengine"

    c) Start a system state backup by running the command:
                wbadmin start systemstatebackup -backupTarget:C:

    If that works, the DPM systemstate backups should also work.


    Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread. Regards, Mike J. [MSFT] This posting is provided "AS IS" with no warranties, and confers no rights.

    Tuesday, January 22, 2013 9:54 PM
    Moderator
  • i have tried to change  SQL VSS writer service to run as domain admin + local admin instead of local system

    It manage to back up the system state how ever the sql backup fails.

    If i use local system to run the SQL VSS writer service, sql backup passed but  system state fails.


    Best regards, Damien Ng

    Thursday, February 21, 2013 3:55 AM