Backup,Unknown,Error: 18210<c/> Severity: 16<c/> State: 1.
-
Tuesday, April 10, 2012 8:18 AM
I am running a Microsoft SQL Server 2008 (SP2) - 10.0.4000.0 (X64) on windows server 2008 SP2 in a clustered environment. When I am trying to take a backup of the database instance I see errors and it fails. I am using networker to backup my SQL data. This is working fine with my other environments and only this environment show up these errors. The SQL log show up these errors.
04/09/2012 03:39:41,spid92,Unknown,BackupVirtualDeviceFile::RequestDurableMedia: Flush failure on backup device 'Legato#ab6dbf69-bf3e-4df8-8486-328599a3e07f'. Operating system error 995(The I/O operation has been aborted because of either a thread exit or an application request.).
04/09/2012 03:39:41,spid92,Unknown,Error: 18210<c/> Severity: 16<c/> State: 1.
04/09/2012 03:39:41,Backup,Unknown,BackupIoRequest::ReportIoError: write failure on backup device 'Legato#ab6dbf69-bf3e-4df8-8486-328599a3e07f'. Operating system error 995(The I/O operation has been aborted because of either a thread exit or an application request.).
04/09/2012 03:39:41,Backup,Unknown,Error: 18210<c/> Severity: 16<c/> State: 1.I had been searching but cannot trace the problem. Any help is appreciated. Thanks...
santhana gopalan
All Replies
-
Tuesday, April 10, 2012 8:23 AM
hi,
Can you check the SQL Server VSS Writer service status please? Is there any related log entry in the Windows event log?
Janos
There are 10 type of people. Those who understand binary and those who do not.
My Blog -
Tuesday, April 10, 2012 9:47 AM
The writer is in the state "started" but it would not show up in console despite a restart of the service. Here is the output of "vssadmin list writers" command. Is this normal with windows 2008? Also I can see the SQL VSS writer is updated to SP2(KB 2285068).
C:\>vssadmin list writers
vssadmin 1.1 - Volume Shadow Copy Service administrative command-line t
(C) Copyright 2001-2005 Microsoft Corp.
Writer name: 'System Writer'
Writer Id: {e8132975-6f93-4464-a53e-1050253ae220}
Writer Instance Id: {9cdf6896-0710-4fb1-89f1-c6f55f69a1ca}
State: [1] Stable
Last error: No error
Writer name: 'ASR Writer'
Writer Id: {be000cbe-11fe-4426-9c58-531aa6355fc4}
Writer Instance Id: {8e0290da-1d2e-47f9-a2c1-807e381a3c3e}
State: [1] Stable
Last error: No error
Writer name: 'Shadow Copy Optimization Writer'
Writer Id: {4dc3bdd4-ab48-4d07-adb0-3bee2926fd7f}
Writer Instance Id: {b196601b-01d9-46d6-a73f-26bb0d33c3ab}
State: [1] Stable
Last error: No error
Writer name: 'IIS Config Writer'
Writer Id: {2a40fd15-dfca-4aa8-a654-1f8c654603f6}
Writer Instance Id: {60e04592-77ad-479e-a7b8-e393be4791c9}
State: [1] Stable
Last error: No error
Writer name: 'Registry Writer'
Writer Id: {afbab4a2-367d-4d15-a586-71dbb18f8485}
Writer Instance Id: {56b868a7-310f-44a5-bbc9-a16cdeb30610}
State: [1] Stable
Last error: No error
Writer name: 'BITS Writer'
Writer Id: {4969d978-be47-48b0-b100-f328f07ac1e0}
Writer Instance Id: {ab35ca73-166a-4d0a-8e7f-89700c9f6b4f}
State: [1] Stable
Last error: No error
Writer name: 'WMI Writer'
Writer Id: {a6ad56c2-b509-4e6c-bb19-49d8f43532f0}
Writer Instance Id: {f39190da-cf11-4d1b-8c5c-6c83cb748e2e}
State: [1] Stable
Last error: No error
Writer name: 'Cluster Database'
Writer Id: {41e12264-35d8-479b-8e5c-9b23d1dad37e}
Writer Instance Id: {6150203b-cd12-48b9-8296-97e863ebd065}
State: [1] Stable
Last error: No error
Writer name: 'COM+ REGDB Writer'
Writer Id: {542da469-d3e1-473c-9f4f-7847f01fc64f}
Writer Instance Id: {6722244a-160f-4fcf-b943-6cfa22bb8405}
State: [1] Stable
Last error: No error
santhana gopalan
-
Tuesday, April 10, 2012 10:53 AM
Also, I see repeatedly SQLVDI errors in the Application log as well..
04/09/2012 05:50:59,SQLVDI,Error,The description for Event ID '1' in Source 'SQLVDI' cannot be found. The local computer may not have the necessary registry information or message DLL files to display the message<c/> or you may not have permission to access them. The following information is part of the event:'TriggerAbort'<c/> 'invoked'<c/> '0'<c/> ''<c/> '8220'<c/> '4020'<c/> 'Server'<c/> 'DB02'<c/> 'Global\Legato#3aea5130-405c-48a4-b9ca-157f37362363_SQLVDIMemoryName_0',(0),1,,DBATSTCN30
04/09/2012 05:50:59,MSSQL$DB02,Error,The description for Event ID '-1073723614' in Source 'MSSQL$DB02' cannot be found. The local computer may not have the necessary registry information or message DLL files to display the message<c/> or you may not have permission to access them. The following information is part of the event:'BackupIoRequest::ReportIoError'<c/> 'write'<c/> 'Legato#3aea5130-405c-48a4-b9ca-157f37362363'<c/> '995(The I/O operation has been aborted because of either a thread exit or an application request.)',(6),3221243682,NT AUTHORITY\SYSTEM,DBATSTCN30
04/09/2012 05:50:59,MSSQL$DB02,Error,The description for Event ID '-1073738783' in Source 'MSSQL$DB02' cannot be found. The local computer may not have the necessary registry information or message DLL files to display the message<c/> or you may not have permission to access them. The following information is part of the event:'BACKUP DATABASE CourionTR',(6),3221228513,NT AUTHORITY\SYSTEM,DBATSTCN30
04/09/2012 05:50:59,SQLVDI,Error,The description for Event ID '1' in Source 'SQLVDI' cannot be found. The local computer may not have the necessary registry information or message DLL files to display the message<c/> or you may not have permission to access them. The following information is part of the event:'SignalAbort'<c/> 'Client initiates abort'<c/> '0'<c/> ''<c/> '11808'<c/> '13780'<c/> 'Client'<c/> 'DB02'<c/> 'Global\Legato#3aea5130-405c-48a4-b9ca-157f37362363_SQLVDIMemoryName_0',(0),1,,DBATSTCN30santhana gopalan
-
Tuesday, April 10, 2012 10:59 AM
Hi,
Did you change the service account? Do you have DB02 instance on your machine? Are you using any 3rd party backup software?
Janos
There are 10 type of people. Those who understand binary and those who do not.
My Blog -
Tuesday, April 10, 2012 11:58 AM
Hi,
To answer you questions...
Did you change the service account?
If I understand correctly, we never changed the service accounts that used to start the DB instances in the server. They remain same. They have full rights on the instances. we use mixed mode authentication.
Do you have DB02 instance on your machine?
Yes, this is one of the instances in the server. There are multiple instances running like this. Backups failing for them as well.
Are you using any 3rd party backup software?
Yes, I am using networker Backup software to backup these database instances.
santhana gopalan
-
Tuesday, April 10, 2012 12:34 PM
Hi,
Ok, did you try to contact emc?
There are 10 type of people. Those who understand binary and those who do not.
My Blog -
Tuesday, April 10, 2012 1:55 PMYep, contacted them and they are also not able to trace this out. Actually, the Backup software is running the latest stable code, where it would backup fine in other similar env. As stated above, whether the SQL VSS writer not showing in the console has any effect on the backups?
santhana gopalan
-
Wednesday, April 11, 2012 1:32 PM
Hi,
Do you see VSS writer on the other environment?
janos
There are 10 type of people. Those who understand binary and those who do not.
My Blog -
Wednesday, April 11, 2012 3:46 PMYes, I see it.
C:\>vssadmin list writers
vssadmin 1.1 - Volume Shadow Copy Service administrative command-line tool
(C) Copyright 2001-2005 Microsoft Corp.Writer name: 'System Writer'
Writer Id: {e8132975-6f93-4464-a53e-1050253ae220}
Writer Instance Id: {98690f0a-371b-4c4f-9f69-db7627ca5ffe}
State: [1] Stable
Last error: No errorWriter name: 'SqlServerWriter'
Writer Id: {a65faa63-5ea8-4ebc-9dbd-a0c4db26912a}
Writer Instance Id: {65698ee3-a9cb-4521-bcaa-3b3d39a6659e}
State: [1] Stable
Last error: No errorWriter name: 'ASR Writer'
Writer Id: {be000cbe-11fe-4426-9c58-531aa6355fc4}
Writer Instance Id: {2d86b78e-8327-4b28-b6ca-9f4ba9715c05}
State: [1] Stable
Last error: No errorsanthana gopalan
-
Wednesday, April 11, 2012 3:52 PM
Well, in this case the missing VSS writer is your problem. You may try to reinstall or repair. I have seen some issues with it if you have space in the computer name. Please take a look on this article too: http://support.microsoft.com/kb/919023
Janos
There are 10 type of people. Those who understand binary and those who do not.
My Blog- Proposed As Answer by amber zhangModerator Thursday, April 12, 2012 1:49 AM
-
Friday, April 13, 2012 11:39 AM
Yes, I will try reinstalling the writer.
Also, one more finding.. I saw the following registry keys in the VSS SQL writer registry path. Does this mean any thing?
[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\VSS\Diag\SqlServerWriter]
"IDENTIFY (Enter)"=hex:48,00,00,00,00,00,00,00,2c,dc,80,35,85,18,cd,01,a8,2f,\
00,00,7c,18,00,00,e8,03,00,00,01,00,00,00,01,00,00,00,f4,23,04,80,00,00,00,\
00,00,00,00,00,00,00,00,00,00,00,00,00,00,00,00,00,00,00,00,00,00,00,00,00,\
00,00,00,00
"((HRESULT)0x800423F4L) (SetCurrentFailure)"=hex:48,00,00,00,00,00,00,00,a6,20,\
a2,35,85,18,cd,01,a8,2f,00,00,7c,18,00,00,f4,23,04,80,01,00,00,00,01,00,00,\
00,f4,23,04,80,00,00,00,00,00,00,00,00,00,00,00,00,00,00,00,00,00,00,00,00,\
00,00,00,00,00,00,00,00,00,00,00,00
"IDENTIFY (Leave)"=hex:48,00,00,00,00,00,00,00,a6,20,a2,35,85,18,cd,01,a8,2f,\
00,00,7c,18,00,00,e8,03,00,00,00,00,00,00,01,00,00,00,f4,23,04,80,00,00,00,\
00,00,00,00,00,00,00,00,00,00,00,00,00,00,00,00,00,00,00,00,00,00,00,00,00,\
00,00,00,00santhana gopalan
