02-24-2009 09:19 AM
Getting following errors in the event logs on a system running Windows 2003 SP2 x64 with a SQL 2005 Express database using named pipes only for connectivity. These errors are generated during the incremental backup job. SQL Server Service and Browser service are running as Network Service while the VSS Writer is running as Local System. I have enabled "Perform full VSS Backup" option in the advanced job options.
Any ideas?
Thanks,
Kevin
Application Event Logs
SQLVDI: Loc=TriggerAbort. Desc=invoked. ErrorCode=(0). Process=1352. Thread=3300. Server. Instance=SQLEXPRESS. VD=Global\{36FB8BA7-EDDA-4F84-8295-40CF65AEA440}2_SQLVDIMemoryName_0.
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
******
SQLVDI: Loc=SVDS::CloseDevice. Desc=Abort detected. ErrorCode=(0). Process=1352. Thread=3300. Server. Instance=SQLEXPRESS. VD=Global\{36FB8BA7-EDDA-4F84-8295-40CF65AEA440}2_SQLVDIMemoryName_0.
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
*****
BACKUP failed to complete the command BACKUP DATABASE model. Check the backup application log for detailed messages.
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
*****
SQLVDI: Loc=TriggerAbort. Desc=invoked. ErrorCode=(0). Process=1352. Thread=1656. Server. Instance=SQLEXPRESS. VD=Global\{36FB8BA7-EDDA-4F84-8295-40CF65AEA440}3_SQLVDIMemoryName_0.
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
*****
BackupVirtualDeviceFile::PrepareToFreeze: failure on backup device '{36FB8BA7-EDDA-4F84-8295-40CF65AEA440}3'. Operating system error 995(The I/O operation has been aborted because of either a thread exit or an application request.).
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Output from "vssadmin list writers"
Writer name: 'SqlServerWriter'
Writer Id: {a65faa63-5ea8-4ebc-9dbd-a0c4db26912a}
Writer Instance Id: {a1fa4138-f758-4ad4-b64d-234370f1f9d8}
State: [8] Failed
Last error: Retryable error
02-27-2009 10:49 AM