Problem using SQLWriter to backup a database from secondary replica in AlwaysOn availability group. RRS feed

  • Question

  • I have a problem using SQLWriter to backup from secondary replica. It works just fine on primary, but fails when I attempt to perform backup on secondary.

    I have two node setup with Synchronous Commit, Automatic Failover and Readable secondary settings. When trying to backup from secondary i get this error:

    SqlServerWriter state is VSS_WS_FAILED_AT_PREPARE_SNAPSHOT

    0x800423f4, The writer experienced a non-transient error.  If the backup process is retried, the error is likely to reoccur.

    And there is no further explanation why this occurred.

    If anyone had a similar problem, please reply.

    Thursday, January 12, 2012 12:05 PM

All replies

  • It appears that full backups are required to be copy-only on a secondary replica. Does your test take this into consideration?
    • Proposed as answer by PrinceLucifer Monday, January 16, 2012 6:44 AM
    Thursday, January 12, 2012 9:06 PM
  • It not only appears like it, it definitely is that way.
    Friday, January 13, 2012 11:32 AM
  • Thanks, that worked just fine!
    Friday, January 13, 2012 12:12 PM