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)