I have been trying to get the Backup Site Server task to work in the Site Maintenance and consistanly get a failure.  SQL writer not found.  I have made sure the NT AUTHORITY had SA and that the sql writer was on.  I have also tried using the network path which would create the backup on the Site server with a failure.  Although the errors are a little different.  I have pasted my log file segment below.  Any help would be greatly appreciated.

Registered connection to SQL server (db servername) and database TCprod03\CM_TC1.                SMS_SITE_BACKUP                4/13/2015 7:00:11 PM     7468 (0x1D2C)

Registered connection to master database on SQL server (db servername).         SMS_SITE_BACKUP          4/13/2015 7:00:11 PM         7468 (0x1D2C)

Initializing the status message reporting system...          SMS_SITE_BACKUP          4/13/2015 7:00:11 PM     7468 (0x1D2C)

    The path to the "Status Manager" inbox is "C:\Program Files\Microsoft Configuration Manager\inboxes\statmgr.box\statmsgs".          SMS_SITE_BACKUP          4/13/2015 7:00:11 PM     7468 (0x1D2C)

    SMS_STATUS_MANAGER is not running as part of this process, the SMS_EXECUTIVE to SMS_STATUS_MANAGER in-memory status message queue will not be used.             SMS_SITE_BACKUP          4/13/2015 7:00:11 PM     7468 (0x1D2C)

Registered this process as a source of "SMS Server" events.       SMS_SITE_BACKUP          4/13/2015 7:00:14 PM     7468 (0x1D2C)

Registered this process as a source of "SMS Client" events.        SMS_SITE_BACKUP          4/13/2015 7:00:14 PM     7468 (0x1D2C)

Registered this process as a source of "SMS Provider" events.   SMS_SITE_BACKUP          4/13/2015 7:00:14 PM     7468 (0x1D2C)

Status message reporting system initialized successfully.            SMS_SITE_BACKUP          4/13/2015 7:00:14 PM     7468 (0x1D2C)

Locale set to OS value (English_United States.1252).      SMS_SITE_BACKUP          4/13/2015 7:00:14 PM     7468 (0x1D2C)

SMS_SITE_BACKUP service 2012 started.               SMS_SITE_BACKUP          4/13/2015 7:00:14 PM     7468 (0x1D2C)

STATMSG: ID=500 SEV=I LEV=M SOURCE="SMS Server" COMP="SMS_SITE_BACKUP" SYS=(site server servername) SITE=TC1 PID=8824 TID=7468 GMTDATE=Mon Apr 13 23:00:14.832 2015 ISTR0="SMS_SITE_BACKUP" ISTR1="" ISTR2="" ISTR3="" ISTR4="" ISTR5="" ISTR6="" ISTR7="" ISTR8="" ISTR9="" NUMATTRS=0      SMS_SITE_BACKUP          4/13/2015 7:00:14 PM     7468 (0x1D2C)

Starting backup - Mon Apr 13 19:00:14 2015         SMS_SITE_BACKUP          4/13/2015 7:00:14 PM     7468 (0x1D2C)

SMS installation root directory = C:\Program Files\Microsoft Configuration Manager.    SMS_SITE_BACKUP          4/13/2015 7:00:15 PM          7468 (0x1D2C)

Warning: SQL installation root directory is empty.The registry key "SOFTWARE\Microsoft\MSSQLServer\Setup\SQLPath" (populated by ConfigMgr setup) was found empty.        SMS_SITE_BACKUP          4/13/2015 7:00:15 PM     7468 (0x1D2C)

Site server backup location = e:\SCCM_ Backup.               SMS_SITE_BACKUP          4/13/2015 7:00:15 PM     7468 (0x1D2C)

SQL backup location = e:\SCCMSQL_Backup1.     SMS_SITE_BACKUP          4/13/2015 7:00:15 PM     7468 (0x1D2C)

Verified that backup folder e:\SCCM_ Backup exists.     SMS_SITE_BACKUP          4/13/2015 7:00:15 PM     7468 (0x1D2C)

Verified backup service has permission to access the backup folder e:\SCCM_ Backup  SMS_SITE_BACKUP          4/13/2015 7:00:15 PM          7468 (0x1D2C)

STATMSG: ID=5055 SEV=I LEV=M SOURCE="SMS Server" COMP="SMS_SITE_BACKUP" SYS=(site server servername) SITE=TC1 PID=8824 TID=7468 GMTDATE=Mon Apr 13 23:00:15.117 2015 ISTR0="" ISTR1="" ISTR2="" ISTR3="" ISTR4="" ISTR5="" ISTR6="" ISTR7="" ISTR8="" ISTR9="" NUMATTRS=0             SMS_SITE_BACKUP          4/13/2015 7:00:15 PM     7468 (0x1D2C)

LogEvent(): Successfully logged Event to NT Event Log. (4 - 48 - 1,073,746,879)   SMS_SITE_BACKUP          4/13/2015 7:00:15 PM         7468 (0x1D2C)

Starting VSS initialization...        SMS_SITE_BACKUP          4/13/2015 7:00:15 PM     7468 (0x1D2C)

Starting Asynchronous GatherWriterMetadata. SMS_SITE_BACKUP          4/13/2015 7:00:15 PM     7468 (0x1D2C)

Number of writers that responded: 15. SMS_SITE_BACKUP          4/13/2015 7:00:20 PM     7468 (0x1D2C)

Reading SMS Writer metadata...               SMS_SITE_BACKUP          4/13/2015 7:00:21 PM     7468 (0x1D2C)

Number of FileIncludes: 0.          SMS_SITE_BACKUP          4/13/2015 7:00:21 PM     7468 (0x1D2C)

Number of FileExcludes: 0.         SMS_SITE_BACKUP          4/13/2015 7:00:21 PM     7468 (0x1D2C)

Number of Components: 7.        SMS_SITE_BACKUP          4/13/2015 7:00:21 PM     7468 (0x1D2C)

Component 0 - TC1Backup\SiteServer\SMSServer\inboxes.        SMS_SITE_BACKUP          4/13/2015 7:00:21 PM     7468 (0x1D2C)

FileGroupFile = C:\PROGRAM FILES\MICROSOFT CONFIGURATION MANAGER\INBOXES\* [Recursive: yes]                SMS_SITE_BACKUP          4/13/2015 7:00:21 PM     7468 (0x1D2C)

Volume C:\ (that contains the file(s)) is marked as a candidate for snapshot.     SMS_SITE_BACKUP          4/13/2015 7:00:21 PM         7468 (0x1D2C)

Component 1 - TC1Backup\SiteServer\SMSServer\Logs.               SMS_SITE_BACKUP          4/13/2015 7:00:21 PM     7468 (0x1D2C)

FileGroupFile = C:\PROGRAM FILES\MICROSOFT CONFIGURATION MANAGER\LOGS\* [Recursive: yes]  SMS_SITE_BACKUP                4/13/2015 7:00:21 PM     7468 (0x1D2C)

Volume C:\ (that contains the file(s)) is marked as a candidate for snapshot.     SMS_SITE_BACKUP          4/13/2015 7:00:21 PM         7468 (0x1D2C)

Component 2 - TC1Backup\SiteServer\SMSServer\data.               SMS_SITE_BACKUP          4/13/2015 7:00:21 PM     7468 (0x1D2C)

FileGroupFile = C:\PROGRAM FILES\MICROSOFT CONFIGURATION MANAGER\DATA\* [Recursive: yes] SMS_SITE_BACKUP                4/13/2015 7:00:21 PM     7468 (0x1D2C)

Volume C:\ (that contains the file(s)) is marked as a candidate for snapshot.     SMS_SITE_BACKUP          4/13/2015 7:00:21 PM         7468 (0x1D2C)

Component 3 - TC1Backup\SiteServer\SMSServer\srvacct.          SMS_SITE_BACKUP          4/13/2015 7:00:21 PM     7468 (0x1D2C)

FileGroupFile = C:\PROGRAM FILES\MICROSOFT CONFIGURATION MANAGER\SRVACCT\* [Recursive: yes]                SMS_SITE_BACKUP          4/13/2015 7:00:21 PM     7468 (0x1D2C)

Volume C:\ (that contains the file(s)) is marked as a candidate for snapshot.     SMS_SITE_BACKUP          4/13/2015 7:00:21 PM         7468 (0x1D2C)

Component 4 - TC1Backup\SiteServer\SMSServer.          SMS_SITE_BACKUP          4/13/2015 7:00:21 PM     7468 (0x1D2C)

FileGroupFile = C:\Program Files\Microsoft Configuration Manager\install.map [Recursive: no]               SMS_SITE_BACKUP                4/13/2015 7:00:21 PM     7468 (0x1D2C)

Volume C:\ (that contains the file(s)) is marked as a candidate for snapshot.     SMS_SITE_BACKUP          4/13/2015 7:00:21 PM         7468 (0x1D2C)

Component 5 - TC1Backup\SiteServer\SMSbkSiteRegSMS.dat.  SMS_SITE_BACKUP          4/13/2015 7:00:21 PM     7468 (0x1D2C)

FileGroupFile = C:\Program Files\Microsoft Configuration Manager\BackupTemp\SMSbkSiteRegSMS.dat [Recursive: no]                SMS_SITE_BACKUP          4/13/2015 7:00:21 PM     7468 (0x1D2C)

Volume C:\ (that contains the file(s)) is marked as a candidate for snapshot.     SMS_SITE_BACKUP          4/13/2015 7:00:21 PM         7468 (0x1D2C)

Component 6 - TC1Backup\SiteDBServer\SMSbkSQLSiteDB.dat.               SMS_SITE_BACKUP          4/13/2015 7:00:21 PM     7468 (0x1D2C)

Dependency On SQL Writer , LogicalPath:\\xxxdb35\xxxdb35\TCprod03, ComponentName:CM_TC1       SMS_SITE_BACKUP                4/13/2015 7:00:21 PM     7468 (0x1D2C)

After GatherWriterMetadata SMS Writer status = FAILED_AT_FREEZE.    SMS_SITE_BACKUP          4/13/2015 7:00:21 PM     7468 (0x1D2C)

Error: VSS_E_WRITERERROR_TIMEOUT. Error Code = 0x80,042,3f2.            SMS_SITE_BACKUP          4/13/2015 7:00:21 PM     7468 (0x1D2C)

Info: Sending message to start the SQL Backup...              SMS_SITE_BACKUP          4/13/2015 7:00:21 PM     7468 (0x1D2C)

Starting Prepare for backup.       SMS_SITE_BACKUP          4/13/2015 7:00:23 PM     7468 (0x1D2C)

The System Provider VSS ID is 0,000,000,000,A2C,A78     SMS_SITE_BACKUP          4/13/2015 7:00:23 PM     7468 (0x1D2C)

Added volume containing C:\ to the snapshot set.          SMS_SITE_BACKUP          4/13/2015 7:00:25 PM     7468 (0x1D2C)

Info: Starting Asynchronous PrepareForBackup...             SMS_SITE_BACKUP          4/13/2015 7:00:25 PM     7468 (0x1D2C)

Info: Asynchronous PrepareForBackup finished...            SMS_SITE_BACKUP          4/13/2015 7:00:25 PM     7468 (0x1D2C)

After PrepareForBackup SMS Writer status = STABLE.     SMS_SITE_BACKUP          4/13/2015 7:00:25 PM     7468 (0x1D2C)

Info: Waiting for SQL to PrepareForBackup.        SMS_SITE_BACKUP          4/13/2015 7:00:25 PM     7468 (0x1D2C)

Sleeping for 5 seconds...              SMS_SITE_BACKUP          4/13/2015 7:00:26 PM     7468 (0x1D2C)

Sleeping for 5 seconds...              SMS_SITE_BACKUP          4/13/2015 7:00:32 PM     7468 (0x1D2C)

Sleeping for 5 seconds...              SMS_SITE_BACKUP          4/13/2015 7:00:37 PM     7468 (0x1D2C)

ERROR: SQL Backup task failed. Error message - Error: SQL Writer not found.      SMS_SITE_BACKUP          4/13/2015 7:00:43 PM         7468 (0x1D2C)

STATMSG: ID=5052 SEV=E LEV=M SOURCE="SMS Server" COMP="SMS_SITE_BACKUP" SYS=(site server servername) SITE=TC1 PID=8824 TID=7468 GMTDATE=Mon Apr 13 23:00:43.658 2015 ISTR0="\\xxxdb35" ISTR1="CM_TC1;" ISTR2="Error: SQL Writer not found." ISTR3="" ISTR4="" ISTR5="" ISTR6="" ISTR7="" ISTR8="" ISTR9="" NUMATTRS=0           SMS_SITE_BACKUP                4/13/2015 7:00:43 PM     7468 (0x1D2C)

StateTable::CState::Handle - (5052:3 2015-04-13 23:00:43.658+00:00) >> (0:0 2014-07-15 06:00:48.852+00:00)                SMS_SITE_BACKUP          4/13/2015 7:00:43 PM     7468 (0x1D2C)

CStateMsgReporter::DeliverMessages - Queued message: TT=1401 TIDT=0 TID='EF736CF9-7214-4796-9C85-2549A9056D8D' SID=5052 MUF=0 PCNT=2, P1='TC1' P2='2015-04-13 23:00:43.658+00:00' P3='' P4='' P5=''     SMS_SITE_BACKUP          4/13/2015 7:00:43 PM          7468 (0x1D2C)

CStateMsgReporter::DeliverMessages - Created state message file: C:\Program Files\Microsoft Configuration Manager\inboxes\auth\statesys.box\incoming\1w9gbbl3.SMX                SMS_SITE_BACKUP          4/13/2015 7:00:43 PM     7468 (0x1D2C)

Successfully send state change notification EF736CF9-7214-4796-9C85-2549A9056D8D   SMS_SITE_BACKUP          4/13/2015 7:00:43 PM          7468 (0x1D2C)

Error: Sql Server could not prepare for the Backup.         SMS_SITE_BACKUP          4/13/2015 7:00:43 PM     7468 (0x1D2C)

Aborting the backup process.    SMS_SITE_BACKUP          4/13/2015 7:00:43 PM     7468 (0x1D2C)

Aborting the SQL backup process.            SMS_SITE_BACKUP          4/13/2015 7:00:43 PM     7468 (0x1D2C)

Current state of SQL backup: [failed]. Aborting it.            SMS_SITE_BACKUP          4/13/2015 7:00:44 PM     7468 (0x1D2C)

SMS_SITE_BACKUP failed. Please see previous errors.   SMS_SITE_BACKUP          4/13/2015 7:00:44 PM     7468 (0x1D2C)

STATMSG: ID=5060 SEV=E LEV=M SOURCE="SMS Server" COMP="SMS_SITE_BACKUP" SYS=(site server servername) SITE=TC1 PID=8824 TID=7468 GMTDATE=Mon Apr 13 23:00:44.671 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                4/13/2015 7:00:44 PM     7468 (0x1D2C)

SMS_SITE_BACKUP service is stopping. SMS_SITE_BACKUP          4/13/2015 7:00:44 PM     7468 (0x1D2C)

STATMSG: ID=502 SEV=I LEV=M SOURCE="SMS Server" COMP="SMS_SITE_BACKUP" SYS=(site server servername) SITE=TC1 PID=8824 TID=7468 GMTDATE=Mon Apr 13 23:00:44.677 2015 ISTR0="SMS_SITE_BACKUP" ISTR1="" ISTR2="" ISTR3="" ISTR4="" ISTR5="" ISTR6="" ISTR7="" ISTR8="" ISTR9="" NUMATTRS=0      SMS_SITE_BACKUP          4/13/2015 7:00:44 PM     7468 (0x1D2C)

Raised backup task failure alert.               SMS_SITE_BACKUP          4/13/2015 7:00:44 PM     7468 (0x1D2C)

SMS_SITE_BACKUP service stopped.       SMS_SITE_BACKUP          4/13/2015 7:00:44 PM     7468 (0x1D2C)

STATMSG: ID=501 SEV=I LEV=M SOURCE="SMS Server" COMP="SMS_SITE_BACKUP" SYS=(site server servername) SITE=TC1 PID=8824 TID=7468 GMTDATE=Mon Apr 13 23:00:44.717 2015 ISTR0="SMS_SITE_BACKUP" ISTR1="" ISTR2="" ISTR3="" ISTR4="" ISTR5="" ISTR6="" ISTR7="" ISTR8="" ISTR9="" NUMATTRS=0      SMS_SITE_BACKUP          4/13/2015 7:00:44 PM     7468 (0x1D2C)

What does 'vssadmin list writers' display?

At the time the sql writer was listed along with other writers.

You might find it better to back up the database directly in SQL, You can compress the database and save a lot of space.

https://stevethompsonmvp.wordpress.com/2013/06/07/sql-server-backup-recommendations-for-configuration-manager/

Regarding your issue.

http://www.cb-net.co.uk/microsoft-articles/34-configmgr/2036-configmgr-2012-sms-site-backup-error-5060

• Edited by Richard.Knight 16 hours 2 minutes ago

Hi Richard I have already tried that and still failed, I did however get slightly further then before.  We will be looking at using a direct database backup but this functionality is there and should work.

Registered connection to SQL server "dbserver" and database TCprod03\CM_TC1.  $$<SMS_SITE_BACKUP><04-13-2015 19:00:11.055+240><thread=7468 (0x1D2C)>

Registered connection to master database on SQL server "dbserver".  $$<SMS_SITE_BACKUP><04-13-2015 19:00:11.110+240><thread=7468 (0x1D2C)>

Initializing the status message reporting system...  $$<SMS_SITE_BACKUP><04-13-2015 19:00:11.112+240><thread=7468 (0x1D2C)>

    The path to the "Status Manager" inbox is "C:\Program Files\Microsoft Configuration Manager\inboxes\statmgr.box\statmsgs".  $$<SMS_SITE_BACKUP><04-13-2015 19:00:11.151+240><thread=7468 (0x1D2C)>

    SMS_STATUS_MANAGER is not running as part of this process, the SMS_EXECUTIVE to SMS_STATUS_MANAGER in-memory status message queue will not be used.  $$<SMS_SITE_BACKUP><04-13-2015 19:00:11.152+240><thread=7468 (0x1D2C)>

Registered this process as a source of "SMS Server" events.  $$<SMS_SITE_BACKUP><04-13-2015 19:00:14.793+240><thread=7468 (0x1D2C)>

Registered this process as a source of "SMS Client" events.  $$<SMS_SITE_BACKUP><04-13-2015 19:00:14.796+240><thread=7468 (0x1D2C)>

Registered this process as a source of "SMS Provider" events.  $$<SMS_SITE_BACKUP><04-13-2015 19:00:14.799+240><thread=7468 (0x1D2C)>

Status message reporting system initialized successfully.  $$<SMS_SITE_BACKUP><04-13-2015 19:00:14.811+240><thread=7468 (0x1D2C)>

Locale set to OS value (English_United States.1252).  $$<SMS_SITE_BACKUP><04-13-2015 19:00:14.828+240><thread=7468 (0x1D2C)>

SMS_SITE_BACKUP service 2012 started.  $$<SMS_SITE_BACKUP><04-13-2015 19:00:14.830+240><thread=7468 (0x1D2C)>

STATMSG: ID=500 SEV=I LEV=M SOURCE="SMS Server" COMP="SMS_SITE_BACKUP" SYS="Site server" SITE=TC1 PID=8824 TID=7468 GMTDATE=Mon Apr 13 23:00:14.832 2015 ISTR0="SMS_SITE_BACKUP" ISTR1="" ISTR2="" ISTR3="" ISTR4="" ISTR5="" ISTR6="" ISTR7="" ISTR8="" ISTR9="" NUMATTRS=0  $$<SMS_SITE_BACKUP><04-13-2015 19:00:14.832+240><thread=7468 (0x1D2C)>

Starting backup - Mon Apr 13 19:00:14 2015  $$<SMS_SITE_BACKUP><04-13-2015 19:00:14.837+240><thread=7468 (0x1D2C)>

SMS installation root directory = C:\Program Files\Microsoft Configuration Manager.  $$<SMS_SITE_BACKUP><04-13-2015 19:00:15.104+240><thread=7468 (0x1D2C)>

Warning: SQL installation root directory is empty.The registry key "SOFTWARE\Microsoft\MSSQLServer\Setup\SQLPath" (populated by ConfigMgr setup) was found empty.  $$<SMS_SITE_BACKUP><04-13-2015 19:00:15.106+240><thread=7468 (0x1D2C)>

Site server backup location = e:\SCCM_ Backup.  $$<SMS_SITE_BACKUP><04-13-2015 19:00:15.108+240><thread=7468 (0x1D2C)>

SQL backup location = e:\SCCMSQL_Backup1.  $$<SMS_SITE_BACKUP><04-13-2015 19:00:15.109+240><thread=7468 (0x1D2C)>

Verified that backup folder e:\SCCM_ Backup exists.   $$<SMS_SITE_BACKUP><04-13-2015 19:00:15.112+240><thread=7468 (0x1D2C)>

Verified backup service has permission to access the backup folder e:\SCCM_ Backup  $$<SMS_SITE_BACKUP><04-13-2015 19:00:15.115+240><thread=7468 (0x1D2C)>

STATMSG: ID=5055 SEV=I LEV=M SOURCE="SMS Server" COMP="SMS_SITE_BACKUP" SYS="Site server" SITE=TC1 PID=8824 TID=7468 GMTDATE=Mon Apr 13 23:00:15.117 2015 ISTR0="" ISTR1="" ISTR2="" ISTR3="" ISTR4="" ISTR5="" ISTR6="" ISTR7="" ISTR8="" ISTR9="" NUMATTRS=0  $$<SMS_SITE_BACKUP><04-13-2015 19:00:15.117+240><thread=7468 (0x1D2C)>

LogEvent(): Successfully logged Event to NT Event Log. (4 - 48 - 1,073,746,879)  $$<SMS_SITE_BACKUP><04-13-2015 19:00:15.125+240><thread=7468 (0x1D2C)>

Starting VSS initialization...  $$<SMS_SITE_BACKUP><04-13-2015 19:00:15.127+240><thread=7468 (0x1D2C)>

Starting Asynchronous GatherWriterMetadata.  $$<SMS_SITE_BACKUP><04-13-2015 19:00:15.291+240><thread=7468 (0x1D2C)>

Number of writers that responded: 15.  $$<SMS_SITE_BACKUP><04-13-2015 19:00:20.925+240><thread=7468 (0x1D2C)>

Reading SMS Writer metadata...  $$<SMS_SITE_BACKUP><04-13-2015 19:00:21.714+240><thread=7468 (0x1D2C)>

Number of FileIncludes: 0.  $$<SMS_SITE_BACKUP><04-13-2015 19:00:21.716+240><thread=7468 (0x1D2C)>

Number of FileExcludes: 0.  $$<SMS_SITE_BACKUP><04-13-2015 19:00:21.717+240><thread=7468 (0x1D2C)>

Number of Components: 7.  $$<SMS_SITE_BACKUP><04-13-2015 19:00:21.719+240><thread=7468 (0x1D2C)>

Component 0 - TC1Backup\SiteServer\SMSServer\inboxes.  $$<SMS_SITE_BACKUP><04-13-2015 19:00:21.720+240><thread=7468 (0x1D2C)>

FileGroupFile = C:\PROGRAM FILES\MICROSOFT CONFIGURATION MANAGER\INBOXES\* [Recursive: yes]  $$<SMS_SITE_BACKUP><04-13-2015 19:00:21.733+240><thread=7468 (0x1D2C)>

Volume C:\ (that contains the file(s)) is marked as a candidate for snapshot.  $$<SMS_SITE_BACKUP><04-13-2015 19:00:21.738+240><thread=7468 (0x1D2C)>

Component 1 - TC1Backup\SiteServer\SMSServer\Logs.  $$<SMS_SITE_BACKUP><04-13-2015 19:00:21.739+240><thread=7468 (0x1D2C)>

FileGroupFile = C:\PROGRAM FILES\MICROSOFT CONFIGURATION MANAGER\LOGS\* [Recursive: yes]  $$<SMS_SITE_BACKUP><04-13-2015 19:00:21.741+240><thread=7468 (0x1D2C)>

Volume C:\ (that contains the file(s)) is marked as a candidate for snapshot.  $$<SMS_SITE_BACKUP><04-13-2015 19:00:21.745+240><thread=7468 (0x1D2C)>

Component 2 - TC1Backup\SiteServer\SMSServer\data.  $$<SMS_SITE_BACKUP><04-13-2015 19:00:21.746+240><thread=7468 (0x1D2C)>

FileGroupFile = C:\PROGRAM FILES\MICROSOFT CONFIGURATION MANAGER\DATA\* [Recursive: yes]  $$<SMS_SITE_BACKUP><04-13-2015 19:00:21.748+240><thread=7468 (0x1D2C)>

Volume C:\ (that contains the file(s)) is marked as a candidate for snapshot.  $$<SMS_SITE_BACKUP><04-13-2015 19:00:21.752+240><thread=7468 (0x1D2C)>

Component 3 - TC1Backup\SiteServer\SMSServer\srvacct.  $$<SMS_SITE_BACKUP><04-13-2015 19:00:21.754+240><thread=7468 (0x1D2C)>

FileGroupFile = C:\PROGRAM FILES\MICROSOFT CONFIGURATION MANAGER\SRVACCT\* [Recursive: yes]  $$<SMS_SITE_BACKUP><04-13-2015 19:00:21.756+240><thread=7468 (0x1D2C)>

Volume C:\ (that contains the file(s)) is marked as a candidate for snapshot.  $$<SMS_SITE_BACKUP><04-13-2015 19:00:21.760+240><thread=7468 (0x1D2C)>

Component 4 - TC1Backup\SiteServer\SMSServer.  $$<SMS_SITE_BACKUP><04-13-2015 19:00:21.762+240><thread=7468 (0x1D2C)>

FileGroupFile = C:\Program Files\Microsoft Configuration Manager\install.map [Recursive: no]  $$<SMS_SITE_BACKUP><04-13-2015 19:00:21.765+240><thread=7468 (0x1D2C)>

Volume C:\ (that contains the file(s)) is marked as a candidate for snapshot.  $$<SMS_SITE_BACKUP><04-13-2015 19:00:21.768+240><thread=7468 (0x1D2C)>

Component 5 - TC1Backup\SiteServer\SMSbkSiteRegSMS.dat.  $$<SMS_SITE_BACKUP><04-13-2015 19:00:21.770+240><thread=7468 (0x1D2C)>

FileGroupFile = C:\Program Files\Microsoft Configuration Manager\BackupTemp\SMSbkSiteRegSMS.dat [Recursive: no]  $$<SMS_SITE_BACKUP><04-13-2015 19:00:21.772+240><thread=7468 (0x1D2C)>

Volume C:\ (that contains the file(s)) is marked as a candidate for snapshot.  $$<SMS_SITE_BACKUP><04-13-2015 19:00:21.776+240><thread=7468 (0x1D2C)>

Component 6 - TC1Backup\SiteDBServer\SMSbkSQLSiteDB.dat.  $$<SMS_SITE_BACKUP><04-13-2015 19:00:21.777+240><thread=7468 (0x1D2C)>

Dependency On SQL Writer , LogicalPath:\\"dbserver"\"dbserver"\TCprod03, ComponentName:CM_TC1  $$<SMS_SITE_BACKUP><04-13-2015 19:00:21.780+240><thread=7468 (0x1D2C)>

After GatherWriterMetadata SMS Writer status = FAILED_AT_FREEZE.  $$<SMS_SITE_BACKUP><04-13-2015 19:00:21.965+240><thread=7468 (0x1D2C)>

~Error: VSS_E_WRITERERROR_TIMEOUT. Error Code = 0x80,042,3f2.  $$<SMS_SITE_BACKUP><04-13-2015 19:00:21.967+240><thread=7468 (0x1D2C)>

~Info: Sending message to start the SQL Backup...  $$<SMS_SITE_BACKUP><04-13-2015 19:00:21.969+240><thread=7468 (0x1D2C)>

Starting Prepare for backup.   $$<SMS_SITE_BACKUP><04-13-2015 19:00:23.971+240><thread=7468 (0x1D2C)>

The System Provider VSS ID is 0,000,000,000,A2C,A78  $$<SMS_SITE_BACKUP><04-13-2015 19:00:23.976+240><thread=7468 (0x1D2C)>

Added volume containing C:\ to the snapshot set.  $$<SMS_SITE_BACKUP><04-13-2015 19:00:25.224+240><thread=7468 (0x1D2C)>

~Info: Starting Asynchronous PrepareForBackup...  $$<SMS_SITE_BACKUP><04-13-2015 19:00:25.225+240><thread=7468 (0x1D2C)>

~Info: Asynchronous PrepareForBackup finished...  $$<SMS_SITE_BACKUP><04-13-2015 19:00:25.462+240><thread=7468 (0x1D2C)>

After PrepareForBackup SMS Writer status = STABLE.  $$<SMS_SITE_BACKUP><04-13-2015 19:00:25.574+240><thread=7468 (0x1D2C)>

~Info: Waiting for SQL to PrepareForBackup.  $$<SMS_SITE_BACKUP><04-13-2015 19:00:25.576+240><thread=7468 (0x1D2C)>

Sleeping for 5 seconds...  $$<SMS_SITE_BACKUP><04-13-2015 19:00:26.700+240><thread=7468 (0x1D2C)>

Sleeping for 5 seconds...  $$<SMS_SITE_BACKUP><04-13-2015 19:00:32.297+240><thread=7468 (0x1D2C)>

Sleeping for 5 seconds...  $$<SMS_SITE_BACKUP><04-13-2015 19:00:37.893+240><thread=7468 (0x1D2C)>

ERROR: SQL Backup task failed. Error message - Error: SQL Writer not found.  $$<SMS_SITE_BACKUP><04-13-2015 19:00:43.656+240><thread=7468 (0x1D2C)>

STATMSG: ID=5052 SEV=E LEV=M SOURCE="SMS Server" COMP="SMS_SITE_BACKUP" SYS="Site server" SITE=TC1 PID=8824 TID=7468 GMTDATE=Mon Apr 13 23:00:43.658 2015 ISTR0="\\"dbserver"" ISTR1="CM_TC1;" ISTR2="Error: SQL Writer not found." ISTR3="" ISTR4="" ISTR5="" ISTR6="" ISTR7="" ISTR8="" ISTR9="" NUMATTRS=0  $$<SMS_SITE_BACKUP><04-13-2015 19:00:43.658+240><thread=7468 (0x1D2C)>

StateTable::CState::Handle - (5052:3 2015-04-13 23:00:43.658+00:00) >> (0:0 2014-07-15 06:00:48.852+00:00)  $$<SMS_SITE_BACKUP><04-13-2015 19:00:43.661+240><thread=7468 (0x1D2C)>

CStateMsgReporter::DeliverMessages - Queued message: TT=1401 TIDT=0 TID='EF736CF9-7214-4796-9C85-2549A9056D8D' SID=5052 MUF=0 PCNT=2, P1='TC1' P2='2015-04-13 23:00:43.658+00:00' P3='' P4='' P5=''  $$<SMS_SITE_BACKUP><04-13-2015 19:00:43.694+240><thread=7468 (0x1D2C)>

CStateMsgReporter::DeliverMessages - Created state message file: C:\Program Files\Microsoft Configuration Manager\inboxes\auth\statesys.box\incoming\1w9gbbl3.SMX   $$<SMS_SITE_BACKUP><04-13-2015 19:00:43.709+240><thread=7468 (0x1D2C)>

Successfully send state change notification EF736CF9-7214-4796-9C85-2549A9056D8D  $$<SMS_SITE_BACKUP><04-13-2015 19:00:43.710+240><thread=7468 (0x1D2C)>

Error: Sql Server could not prepare for the Backup.  $$<SMS_SITE_BACKUP><04-13-2015 19:00:43.716+240><thread=7468 (0x1D2C)>

Aborting the backup process.  $$<SMS_SITE_BACKUP><04-13-2015 19:00:43.719+240><thread=7468 (0x1D2C)>

Aborting the SQL backup process.  $$<SMS_SITE_BACKUP><04-13-2015 19:00:43.885+240><thread=7468 (0x1D2C)>

Current state of SQL backup: [failed]. Aborting it.  $$<SMS_SITE_BACKUP><04-13-2015 19:00:44.624+240><thread=7468 (0x1D2C)>

SMS_SITE_BACKUP failed. Please see previous errors.  $$<SMS_SITE_BACKUP><04-13-2015 19:00:44.669+240><thread=7468 (0x1D2C)>

STATMSG: ID=5060 SEV=E LEV=M SOURCE="SMS Server" COMP="SMS_SITE_BACKUP" SYS="Site server" SITE=TC1 PID=8824 TID=7468 GMTDATE=Mon Apr 13 23:00:44.671 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><04-13-2015 19:00:44.671+240><thread=7468 (0x1D2C)>

SMS_SITE_BACKUP service is stopping.  $$<SMS_SITE_BACKUP><04-13-2015 19:00:44.675+240><thread=7468 (0x1D2C)>

STATMSG: ID=502 SEV=I LEV=M SOURCE="SMS Server" COMP="SMS_SITE_BACKUP" SYS="Site server" SITE=TC1 PID=8824 TID=7468 GMTDATE=Mon Apr 13 23:00:44.677 2015 ISTR0="SMS_SITE_BACKUP" ISTR1="" ISTR2="" ISTR3="" ISTR4="" ISTR5="" ISTR6="" ISTR7="" ISTR8="" ISTR9="" NUMATTRS=0  $$<SMS_SITE_BACKUP><04-13-2015 19:00:44.677+240><thread=7468 (0x1D2C)>

Raised backup task failure alert.  $$<SMS_SITE_BACKUP><04-13-2015 19:00:44.707+240><thread=7468 (0x1D2C)>

SMS_SITE_BACKUP service stopped.  $$<SMS_SITE_BACKUP><04-13-2015 19:00:44.715+240><thread=7468 (0x1D2C)>

STATMSG: ID=501 SEV=I LEV=M SOURCE="SMS Server" COMP="SMS_SITE_BACKUP" SYS="Site server" SITE=TC1 PID=8824 TID=7468 GMTDATE=Mon Apr 13 23:00:44.717 2015 ISTR0="SMS_SITE_BACKUP" ISTR1="" ISTR2="" ISTR3="" ISTR4="" ISTR5="" ISTR6="" ISTR7="" ISTR8="" ISTR9="" NUMATTRS=0  $$<SMS_SITE_BACKUP><04-13-2015 19:00:44.717+240><thread=7468 (0x1D2C)>

You might find it better to back up the database directly in SQL, You can compress the database and save a lot of space.

https://stevethompsonmvp.wordpress.com/2013/06/07/sql-server-backup-recommendations-for-configuration-manager/

Regarding your issue.

http://www.cb-net.co.uk/microsoft-articles/34-configmgr/2036-configmgr-2012-sms-site-backup-error-5060

• Edited by Richard.Knight Thursday, April 16, 2015 3:45 PM

Did you solve this problem, if so what was the solution?

Since no one has answer this post, I recommend opening  a support case with Microsoft Customer Support Services (CSS) as they can work with you to solve this problem.