Skip to end of metadata
Go to start of metadata

Windows Agent — SqlServerWriter In Failed State

Symptom


Selected writer 'SqlServerWriter' is in failed state causing random databases to shutdown along the way.

Cause


Writer is unable to authenticate.

Resolution


(Workaround) Two Parts.

Part I (workaround)

Since the SqlServerWriter in this case is failing and causing problems during backup:

1. Shutdown the service SqlServerWriter for VSS 
http://support.microsoft.com/kb/919023

2. Change the registry key to use MSDEWriter instead of SQLServerWriter.

The MSDEVersionChecking value is located in the HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\VSS\Settings

=0 or less will use MSDEWriter
>0 will use SQLSErverWriter

(This is currently set to 1 which will uses SQLWriter during shadow copy.)

Part II

2. Check Authentication for SqlServerWriter.

When the VSS service and the SQLWriter service are installed, the service startup account is configured as Local System [NT AUTHORITY\SYSTEM]. When the writer tries to establish a connection to instances of SQL Server, the writer uses the credentials of the Local System [NT AUTHORITY\SYSTEM] startup account. You must make sure that the instances of SQL Server have granted access to this Windows account either explicitly or through group membership of BUILTIN\Administrators.

Related Articles


Page: Windows Agent — SqlServerWriter In Failed State (Archived Knowledge Base 2.0) Labels: sql, sqlserverwriter, vss, backup_error
Page: Restoring MS SQL (Archived Knowledge Base 2.0) Labels: sql, restore, mssql
Page: VSS & SQL Writer Service (Archived Knowledge Base 2.0) Labels: sql, mssql, vss
Page: Windows Agent — Using Idera's SQLSafe With R1Soft (Archived Knowledge Base 2.0) Labels: idera, sql, backup
Page: Backup of MS SQL and Windows 2008 Servers (Archived Knowledge Base 2.0) Labels: sql, mssql
Page: Windows Agent — SqlServerWriter In Failed State (Archived Knowledge Base 2.0) Labels: sql, sqlserverwriter, vss, backup_error
Page: Windows Agent — SqlServerWriter In Failed State (Archived Knowledge Base 2.0) Labels: sql, sqlserverwriter, vss, backup_error
Page: VSS & SQL Writer Service (Archived Knowledge Base 2.0) Labels: sql, mssql, vss
Page: Windows Agent — AGENT Volume Shadow Copy Timed Out (Archived Knowledge Base 2.0) Labels: vss
Page: Error VSS_E_WRITER_INFRASTRUCTURE during the last ansychronous operation (Archived Knowledge Base 2.0) Labels: vss
Page: Windows Agent — Backups Fail With AGENT Closing Connection An Error Occured While Executing VSS Operation (Archived Knowledge Base 2.0) Labels: windows, vss, backup_error
Page: Windows Agent — IO Device Error (Archived Knowledge Base 2.0) Labels: vss
Page: VSS Errors Out with Error Code 0x8007000e (Archived Knowledge Base 2.0) Labels: vss
Page: Why Windows 2000 Is Not Supported (Archived Knowledge Base 2.0) Labels: windows, vss
Page: How Much Space VSS Needs (Archived Knowledge Base 2.0) Labels: vss
Page: How VSS Is Used By CDP (Archived Knowledge Base 2.0) Labels: vss
Page: Windows Agent — Backups Fail With AGENT Timed Out Waiting On Volume Shadow Copy To Complete An Event (Archived Knowledge Base 2.0) Labels: vss, backup_error
Page: Windows Agent — Backups Fail With Error During The Last Asynchronous Operation (Archived Knowledge Base 2.0) Labels: vss, backup_error
Page: Windows Agent — SqlServerWriter In Failed State (Archived Knowledge Base 2.0) Labels: sql, sqlserverwriter, vss, backup_error
Page: Backup Failed, Previous Backup Is Incomplete (Archived Knowledge Base 2.0) Labels: backup_error
Page: Back Up Stopped (Archived Knowledge Base 2.0) Labels: backup_error
Page: Not Enough Data In Sum File To Read BlockSum (Archived Knowledge Base 2.0) Labels: disk_safe, volume, backup_error
Page: Windows Agent — Backups Fail With AGENT Closing Connection An Error Occured While Executing VSS Operation (Archived Knowledge Base 2.0) Labels: windows, vss, backup_error
Page: Linux Agent — Hard Resets Servers (Archived Knowledge Base 2.0) Labels: backup_error
Page: Linux Agent - "Error writing block sum to file" and "Error writing to sum file" (Archived Knowledge Base 2.0) Labels: quota, buagent, sumfile, backup_error
Page: Output Says That There Is Corrupt Data And The Agent Shuts Down And Stops The Back Up (Archived Knowledge Base 2.0) Labels: hardware, backup_error
Page: Windows Agent — Backups Fail With AGENT Timed Out Waiting On Volume Shadow Copy To Complete An Event (Archived Knowledge Base 2.0) Labels: vss, backup_error
Page: Windows Agent — Backups Fail With Error During The Last Asynchronous Operation (Archived Knowledge Base 2.0) Labels: vss, backup_error
Page: MySQL Backup Error In Logs (Archived Knowledge Base 2.0) Labels: mysql, backup_error
Labels:
sql sql Delete
sqlserverwriter sqlserverwriter Delete
vss vss Delete
backup_error backup_error Delete
Enter labels to add to this page:
Please wait 
Looking for a label? Just start typing.