Views:

Summary



SQL 2012 server backup to CDOT fails due to VSS error

Symptoms



Source Nodes:
   Windows 2012R2
   SQL 2012 11.0.5058.0

Destination Node:
  NetApp Release 9.3P1

Backup of SQL 2012 server to CDOT failed with errors in job log,
----------
nn.nn.nn.nn 2/28/2018 11:55:44 am SNBSNP3069E 5224: MsSnapShot::check_wrts_report_okay::check_wrt_status rc[-1]
nn.nn.nn.nn 2/28/2018 11:55:44 am SNBSNP3069E 5224: Failed to check the status of all writers after snapshot rc [-1]
nn.nn.nn.nn 2/28/2018 11:55:44 am SNBSNP3069E 5224: BACKUP::backup_components failed rc(-10)
nn.nn.nn.nn 2/28/2018 11:55:44 am SNBSNP3069E 5224: Failed to backup the applications / disk ( RC(-16)
----------

The client node he event application log shows errors from the SQL VSS Writer,
----------
Error 28.02.2018 11:55:42 SQLVDI 1 None SQLVDI: Loc=TriggerAbort. Desc=invoked. ErrorCode=(0). Process=1308. Thread=4032. Server. Instance=MSSQLSERVER. VD=Global\{F3EED049-7769-4A63-9CF4-FF04A1197AE1}4_SQLVDIMemoryName_0.
Error 28.02.2018 11:55:42 MSSQLSERVER 18210 Backup BackupIoRequest::ReportIoError: write failure on backup device '{F3EED049-7769-4A63-9CF4-FF04A1197AE1}4'. Operating system error 995(The I/O operation has been aborted because of either a thread exit or an application request.).
Error 28.02.2018 11:55:42 MSSQLSERVER 3041 Backup BACKUP failed to complete the command BACKUP DATABASE master. Check the backup application log for detailed messages.

Warning 28.02.2018 11:55:42 VSS 8229 None "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: Microsoft SQL Server 2012:SQLWriter
Writer Instance ID: {caa3c5da-aa46-40fc-b1d0-852d97a21ba4}
Command Line: ""C:\Program Files\Microsoft SQL Server\90\Shared\sqlwriter.exe""
Process ID: 1520"
Error 28.02.2018 11:55:42 SQLVDI 1 None SQLVDI: Loc=TriggerAbort. Desc=invoked. ErrorCode=(0). Process=1308. Thread=5008. Server. Instance=MSSQLSERVER. VD=Global\{F3EED049-7769-4A63-9CF4-FF04A1197AE1}3_SQLVDIMemoryName_0.
Error 28.02.2018 11:55:42 MSSQLSERVER 18210 Backup BackupIoRequest::ReportIoError: write failure on backup device '{F3EED049-7769-4A63-9CF4-FF04A1197AE1}3'. Operating system error 995(The I/O operation has been aborted because of either a thread exit or an application request.).
Error 28.02.2018 11:55:42 MSSQLSERVER 3041 Backup BACKUP failed to complete the command BACKUP DATABASE msdb. Check the backup application log for detailed messages.

Error 28.02.2018 11:55:42 SQLVDI 1 None SQLVDI: Loc=TriggerAbort. Desc=invoked. ErrorCode=(0). Process=1308. Thread=3908. Server. Instance=MSSQLSERVER. VD=Global\{F3EED049-7769-4A63-9CF4-FF04A1197AE1}2_SQLVDIMemoryName_0.
Error 28.02.2018 11:55:42 SQLVDI 1 None SQLVDI: Loc=SignalAbort. Desc=Client initiates abort. ErrorCode=(0). Process=1520. Thread=3404. Client. Instance=. VD=Global\{F3EED049-7769-4A63-9CF4-FF04A1197AE1}4_SQLVDIMemoryName_0.
Error 28.02.2018 11:55:42 MSSQLSERVER 18210 Backup BackupIoRequest::ReportIoError: write failure on backup device '{F3EED049-7769-4A63-9CF4-FF04A1197AE1}2'. Operating system error 995(The I/O operation has be... (truncated, see original email for full text)



Resolution



Apply SQL update:  SQLServer2012SP3-KB3072779-x64-ENU to resolve the issue.
Comments (0)
Add a comment