none
Backing up SQL Server AlwaysOn Availability Group (AG) by using Data Protection Manager 2010 (DPM) failed on the secondary Replica RRS feed

  • Question

  • Can anyone helpt me out?

    When attempting to protect a SQL Server AlwaysOn Availability Group (AG) using 2010 Data Protection Manager 2010 (DPM), the job fails on the secondary Replica with the following error:
    Type: Replica creation
    Status: Failed
    Description: The VSS application writer or the VSS provider is in a bad state. Either it was already in a bad state or it entered a bad state during the current operation. (ID 30111 Details: VssError:The writer experienced a non-transient error. If the backup process is retried, the error is likely to reoccur.(0x800423F4))

    In SQL, AlwaysOn is configured as follows:

    Availability Mode: Synchronous Commit
    Failover Mode: Automatic
    Connections in Primary Role: Allow all connections
    Readable Secondary: Yes

    Backup Preferences:
    Perfer Secondary
    Priority: 50 (for each node)
    Exclude Replica: False (for each node)


    NT AUTHORITY\SYSTEM is the member of sysadmin.


    In the Windows Appication Log on the SQL server I found those two events:

    1. Event ID: 8229 A VSS writer has rejected an event with error 0x800423f4, The writer experienced a non-transient error.  If the backup process is retried, the error is likely to reoccur.
    . Changes that the writer made to the writer components while handling the event will not be available to the requester. Check the event log for related events from the application hosting the VSS writer.

    Operation:
       PrepareForSnapshot Event

    Context:
       Execution Context: Writer
       Writer Class Id: {a65faa63-5ea8-4ebc-9dbd-a0c4db26912a}
       Writer Name: SqlServerWriter
       Writer Instance Name: SQL Server Code-Named 'Denali' CTP2:SQLWriter
       Writer Instance ID: {b4c05d47-35b3-45a6-b7bc-5e3b5516b841}
       Command Line: "C:\Program Files\Microsoft SQL Server\90\Shared\sqlwriter.exe"
       Process ID: 1508

    2. SQLVDI: Loc=SignalAbort. Desc=Client initiates abort. ErrorCode=(0). Process=1508.

    Thread=1772. Client. Instance=. VD=Global\{C39CD2EF-83B6-4C10-A68D-7D152690C5B8}

    1_SQLVDIMemoryName_0.

    In the VSSADMIN query i got this:
    Writer name: 'SqlServerWriter'
       Writer Id: {a65faa63-5ea8-4ebc-9dbd-a0c4db26912a}
       Writer Instance Id: {b4c05d47-35b3-45a6-b7bc-5e3b5516b841}
       State: [8] Failed
       Last error: Non-retryable error

    Thanks in Advance.

    Monday, December 31, 2012 2:19 PM

Answers

  • Hi,

    You must use DPM2012 SP1 to protect SQL server with AlwaysOn features.

    Stephane


    Please remember to click “Mark as Answer” on the post that helps you. This posting is provided "AS IS" with no warranties. knowledge is valid only if it is shared by All.

    My DPM blog Yet Another DPM Blog

    • Proposed as answer by Stephane LADUNE Tuesday, January 15, 2013 9:44 AM
    • Marked as answer by FlexKIDS Friday, February 1, 2013 11:11 AM
    Tuesday, January 15, 2013 9:44 AM

All replies

  • Hi,

    You must use DPM2012 SP1 to protect SQL server with AlwaysOn features.

    Stephane


    Please remember to click “Mark as Answer” on the post that helps you. This posting is provided "AS IS" with no warranties. knowledge is valid only if it is shared by All.

    My DPM blog Yet Another DPM Blog

    • Proposed as answer by Stephane LADUNE Tuesday, January 15, 2013 9:44 AM
    • Marked as answer by FlexKIDS Friday, February 1, 2013 11:11 AM
    Tuesday, January 15, 2013 9:44 AM
  • Thank you Stephane.

    I will try it out and get back to you later.

    Monday, January 21, 2013 10:57 AM
  • Hello Stephane,

    Thanks you very much.

    DPM2012SP1 does work with the AlwaysOn feature in SQL2012.

    Friday, February 1, 2013 11:14 AM