Jump to content


jbsmith

SMS_SITE_BACKUP SQL Writer not found

Recommended Posts

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)

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...


×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.