SMS_SITE_BACKUP SQL Writer not found

[jbsmith]

I went to try to enable this function on our SCCM Primary site. Our SQL is set up on a separate server. When I try to run the SMS_SITE_BACKUP I receive the following error (see bolded sections). I have googled and tried various fixes for hours with no luck. The most common suggestions are to check all services on SCCM Primary site and SQL server- all related services on both the primary site and sql server seem to be running/starting/stopping fine. Other suggestions tried - verify SMS writer and SQL writer as existing and functioning and also making sure NT AUTHORITY\SYSTEM on SQL server has sysadmin rights on SMS_XXX database. Has anyone ran into this problem or would have any more suggestions

 

Thanks!

 

After GatherWriterMetadata SMS Writer status = FAILED_AT_PREPARE_BACKUP. SMS_SITE_BACKUP 3/12/2015 10:09:17 PM 6312 (0x18A8)

Error: VSS_E_WRITERERROR_TIMEOUT. Error Code = 0x80,042,3f2. SMS_SITE_BACKUP 3/12/2015 10:09:17 PM 6312 (0x18A8)

Info: Sending message to start the SQL Backup... SMS_SITE_BACKUP 3/12/2015 10:09:17 PM 6312 (0x18A8)

Starting Prepare for backup. SMS_SITE_BACKUP 3/12/2015 10:09:17 PM 6312 (0x18A8)

The System Provider VSS ID is 0,000,000,000,399,FA8 SMS_SITE_BACKUP 3/12/2015 10:09:17 PM 6312 (0x18A8)

Added volume containing C:\ to the snapshot set. SMS_SITE_BACKUP 3/12/2015 10:09:18 PM 6312 (0x18A8)

Info: Starting Asynchronous PrepareForBackup... SMS_SITE_BACKUP 3/12/2015 10:09:18 PM 6312 (0x18A8)

Info: Asynchronous PrepareForBackup finished... SMS_SITE_BACKUP 3/12/2015 10:09:18 PM 6312 (0x18A8)

After PrepareForBackup SMS Writer status = STABLE. SMS_SITE_BACKUP 3/12/2015 10:09:18 PM 6312 (0x18A8)

Info: Waiting for SQL to PrepareForBackup. SMS_SITE_BACKUP 3/12/2015 10:09:18 PM 6312 (0x18A8)

Sleeping for 5 seconds... SMS_SITE_BACKUP 3/12/2015 10:09:18 PM 6312 (0x18A8)

Sleeping for 5 seconds... SMS_SITE_BACKUP 3/12/2015 10:09:23 PM 6312 (0x18A8)

ERROR: SQL Backup task failed. Error message - Error: SQL Writer not found. SMS_SITE_BACKUP 3/12/2015 10:09:28 PM 6312 (0x18A8)

STATMSG: ID=5052 SEV=E LEV=M SOURCE="SMS Server" COMP="SMS_SITE_BACKUP" SYS=sccm01 SITE=xxx PID=11968 TID=6312 GMTDATE=Fri Mar 13 03:09:28.878 2015 ISTR0="\\dbxx" ISTR1="CM_xxx;" ISTR2="Error: SQL Writer not found." ISTR3="" ISTR4="" ISTR5="" ISTR6="" ISTR7="" ISTR8="" ISTR9="" NUMATTRS=0 SMS_SITE_BACKUP 3/12/2015 10:09:28 PM 6312 (0x18A8)

Error: Sql Server could not prepare for the Backup. SMS_SITE_BACKUP 3/12/2015 10:09:28 PM 6312 (0x18A8)

Aborting the backup process. SMS_SITE_BACKUP 3/12/2015 10:09:28 PM 6312 (0x18A8)

Aborting the SQL backup process. SMS_SITE_BACKUP 3/12/2015 10:09:29 PM 6312 (0x18A8)

Current state of SQL backup: [failed]. Aborting it. SMS_SITE_BACKUP 3/12/2015 10:09:29 PM 6312 (0x18A8)

SMS_SITE_BACKUP failed. Please see previous errors. SMS_SITE_BACKUP 3/12/2015 10:09:29 PM 6312 (0x18A8)

STATMSG: ID=5060 SEV=E LEV=M SOURCE="SMS Server" COMP="SMS_SITE_BACKUP" SYS=sccm01SITE=xxx PID=11968 TID=6312 GMTDATE=Fri Mar 13 03:09:29.130 2015 ISTR0="Error: Sql Server could not prepare for the Backup." ISTR1="" ISTR2="" ISTR3="" ISTR4="" ISTR5="" ISTR6="" ISTR7="" ISTR8="" ISTR9="" NUMATTRS=0 SMS_SITE_BACKUP 3/12/2015 10:09:29 PM 6312 (0x18A8)

SMS_SITE_BACKUP service is stopping. SMS_SITE_BACKUP 3/12/2015 10:09:29 PM 6312 (0x18A8)

STATMSG: ID=502 SEV=I LEV=M SOURCE="SMS Server" COMP="SMS_SITE_BACKUP" SYS=sccm01 SITE=xxx PID=11968 TID=6312 GMTDATE=Fri Mar 13 03:09:29.151 2015 ISTR0="SMS_SITE_BACKUP" ISTR1="" ISTR2="" ISTR3="" ISTR4="" ISTR5="" ISTR6="" ISTR7="" ISTR8="" ISTR9="" NUMATTRS=0 SMS_SITE_BACKUP 3/12/2015 10:09:29 PM 6312 (0x18A8)

Raised backup task failure alert. SMS_SITE_BACKUP 3/12/2015 10:09:29 PM 6312 (0x18A8)

[CJamesEd]

Has anyone had any luck with this issue? I'm seeing almost the exact errors and can't figure out what's going on!

[pembertj]

As stupid as it seems I think when I ran into this it was because there is another database in the same instance that has a space in the name.  

 

https://blogs.msdn.microsoft.com/batala/2011/08/01/sqlserverwriter-missing-when-vssadmin-list-writers-command-is-run/