SQL error when running a backup

Riaan Fourie 0 Reputation points
2024-10-22T19:06:54.9633333+00:00

Sqllib error: OLEDB Error encountered calling ICommandText::Execute. hr = 0x80040e14. SQLSTATE: 42000, Native Error: 3013

Error state: 1, Severity: 16

Source: Microsoft SQL Server Native Client 11.0

Error message: BACKUP DATABASE is terminating abnormally.

SQLSTATE: 42000, Native Error: 3271

Error state: 1, Severity: 16

Source: Microsoft SQL Server Native Client 11.0

Error message: A nonrecoverable I/O error occurred on file "{433A32CD-042A-4426-9C89-C41D9C2664AD}19:" 995(The I/O operation has been aborted because of either a thread exit or an application request.).

Have done a disk shadow check and following error appears:

ERROR: Selected writer "SqlServerWriter" is in a failed state      - Status: 8 (VSS_WS_FAILED_AT_PREPARE_SNAPSHOT)      - Writer failure code: 0x (VSS_E_WRITERERROR_NONRETRYABLE)      - Writer ID: {a65faa63-5ea8-4ebc-9dbd-a0c4db26912a}      - Instance ID: {58660fa7-7d39-4754-9787-3e4d897b5601} The last operation failed.         - Returned HRESULT: 80042301         - Error text: VSS_E_BAD_STATE

Windows for business Windows Server User experience Other
SQL Server Other
{count} votes

1 answer

Sort by: Most helpful
  1. LiHongMSFT-4306 31,566 Reputation points
    2024-10-25T07:31:26.8666667+00:00

    Hi @Riaan Fourie

    Seems like a Windows Server backup error because of the SQL Server VSS writer.

    Please check this doc for detailed information about cause and resolution.

    Best regards,

    Cosmog


    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    1 person found this answer helpful.
    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.