AIT
asked on
SCCM 2007 Backup stopped working?
Recently, our backup within SCCM 2007 R2 stopped working. So, I applied SP2 which did what it was supposed to do by appending the server name correctly. However, the backup still doesnt work and when trying to do a query in Service Manager we get " Error Communicating with the component". Anyone seen this AFTER applying SP2?
could you please post the sms backup logfiles
ASKER
Component 0 - AITBackup\SiteServer\SMSSe rver\inbox es. SMS_SITE_BACKUP 3/30/2010 2:51:21 PM 588 (0x024C)
FileGroupFile = D:\APPS\MICROSOFT CONFIGURATION MANAGER\INBOXES\* [Recursive: yes] SMS_SITE_BACKUP 3/30/2010 2:51:21 PM 588 (0x024C)
Volume D:\ (that contains the file(s)) is marked as a candidate for snapshot. SMS_SITE_BACKUP 3/30/2010 2:51:21 PM 588 (0x024C)
Component 1 - XXXBackup\SiteServer\SMSSe rver\Logs. SMS_SITE_BACKUP 3/30/2010 2:51:21 PM 588 (0x024C)
FileGroupFile = D:\APPS\MICROSOFT CONFIGURATION MANAGER\LOGS\* [Recursive: yes] SMS_SITE_BACKUP 3/30/2010 2:51:21 PM 588 (0x024C)
Volume D:\ (that contains the file(s)) is marked as a candidate for snapshot. SMS_SITE_BACKUP 3/30/2010 2:51:21 PM 588 (0x024C)
Component 2 - XXXBackup\SiteServer\SMSSe rver\data. SMS_SITE_BACKUP 3/30/2010 2:51:21 PM 588 (0x024C)
FileGroupFile = D:\APPS\MICROSOFT CONFIGURATION MANAGER\DATA\* [Recursive: yes] SMS_SITE_BACKUP 3/30/2010 2:51:21 PM 588 (0x024C)
Volume D:\ (that contains the file(s)) is marked as a candidate for snapshot. SMS_SITE_BACKUP 3/30/2010 2:51:21 PM 588 (0x024C)
Component 3 - XXXBackup\SiteServer\SMSSe rver\srvac ct. SMS_SITE_BACKUP 3/30/2010 2:51:21 PM 588 (0x024C)
FileGroupFile = D:\APPS\MICROSOFT CONFIGURATION MANAGER\SRVACCT\* [Recursive: yes] SMS_SITE_BACKUP 3/30/2010 2:51:21 PM 588 (0x024C)
Volume D:\ (that contains the file(s)) is marked as a candidate for snapshot. SMS_SITE_BACKUP 3/30/2010 2:51:21 PM 588 (0x024C)
Component 4 - XXXBackup\SiteServer\SMSbk SiteRegNAL .dat. SMS_SITE_BACKUP 3/30/2010 2:51:21 PM 588 (0x024C)
FileGroupFile = D:\APPS\MICROSOFT CONFIGURATION MANAGER\BackupTemp\SMSbkSi teRegNAL.d at [Recursive: no] SMS_SITE_BACKUP 3/30/2010 2:51:21 PM 588 (0x024C)
Volume D:\ (that contains the file(s)) is marked as a candidate for snapshot. SMS_SITE_BACKUP 3/30/2010 2:51:21 PM 588 (0x024C)
Component 5 - XXXBackup\SiteServer\SMSbk SiteRegSMS .dat. SMS_SITE_BACKUP 3/30/2010 2:51:21 PM 588 (0x024C)
FileGroupFile = D:\APPS\MICROSOFT CONFIGURATION MANAGER\BackupTemp\SMSbkSi teRegSMS.d at [Recursive: no] SMS_SITE_BACKUP 3/30/2010 2:51:21 PM 588 (0x024C)
Volume D:\ (that contains the file(s)) is marked as a candidate for snapshot. SMS_SITE_BACKUP 3/30/2010 2:51:21 PM 588 (0x024C)
Component 6 - XXXBackup\SiteDBServer\SMS bkSQLDBsit e.dat. SMS_SITE_BACKUP 3/30/2010 2:51:21 PM 588 (0x024C)
Dependency On SQL Writer , LogicalPath:\\XXXSCCMSQL, ComponentName:SMS_XXX SMS_SITE_BACKUP 3/30/2010 2:51:21 PM 588 (0x024C)
After GatherWriterMetadata SMS Writer status = STABLE. SMS_SITE_BACKUP 3/30/2010 2:51:21 PM 588 (0x024C)
Starting to clean and prepare the backup location. SMS_SITE_BACKUP 3/30/2010 2:51:21 PM 588 (0x024C)
Cleanup and/or preparation done. SMS_SITE_BACKUP 3/30/2010 2:51:21 PM 588 (0x024C)
Info: Sending message to start the SQL Backup... SMS_SITE_BACKUP 3/30/2010 2:51:21 PM 588 (0x024C)
Starting to create the snapshot set. SMS_SITE_BACKUP 3/30/2010 2:51:21 PM 588 (0x024C)
Added volume containing D:\ to the snapshot set. SMS_SITE_BACKUP 3/30/2010 2:51:21 PM 588 (0x024C)
Info: Starting Asynchronous PrepareForBackup... SMS_SITE_BACKUP 3/30/2010 2:51:21 PM 588 (0x024C)
Info: Asynchronous PrepareForBackup finished... SMS_SITE_BACKUP 3/30/2010 2:51:21 PM 588 (0x024C)
Info: Waiting for SQL to PrepareForBackup. SMS_SITE_BACKUP 3/30/2010 2:51:21 PM 588 (0x024C)
Sleeping for 5 seconds... SMS_SITE_BACKUP 3/30/2010 2:51:21 PM 588 (0x024C)
Sleeping for 5 seconds... SMS_SITE_BACKUP 3/30/2010 2:51:26 PM 588 (0x024C)
Sleeping for 5 seconds... SMS_SITE_BACKUP 3/30/2010 2:51:31 PM 588 (0x024C)
Sleeping for 5 seconds... SMS_SITE_BACKUP 3/30/2010 2:51:36 PM 588 (0x024C)
Sleeping for 5 seconds... SMS_SITE_BACKUP 3/30/2010 2:51:41 PM 588 (0x024C)
Sleeping for 5 seconds... SMS_SITE_BACKUP 3/30/2010 2:51:46 PM 588 (0x024C)
Sleeping for 5 seconds... SMS_SITE_BACKUP 3/30/2010 2:51:51 PM 588 (0x024C)
Sleeping for 5 seconds... SMS_SITE_BACKUP 3/30/2010 2:51:56 PM 588 (0x024C)
Sleeping for 5 seconds... SMS_SITE_BACKUP 3/30/2010 2:52:01 PM 588 (0x024C)
Sleeping for 5 seconds... SMS_SITE_BACKUP 3/30/2010 2:52:06 PM 588 (0x024C)
Sleeping for 5 seconds... SMS_SITE_BACKUP 3/30/2010 2:52:11 PM 588 (0x024C)
Sleeping for 5 seconds... SMS_SITE_BACKUP 3/30/2010 2:52:16 PM 588 (0x024C)
Sleeping for 5 seconds... SMS_SITE_BACKUP 3/30/2010 2:52:21 PM 588 (0x024C)
Sleeping for 5 seconds... SMS_SITE_BACKUP 3/30/2010 2:52:26 PM 588 (0x024C)
Sleeping for 5 seconds... SMS_SITE_BACKUP 3/30/2010 2:52:31 PM 588 (0x024C)
Sleeping for 5 seconds... SMS_SITE_BACKUP 3/30/2010 2:52:36 PM 588 (0x024C)
Sleeping for 5 seconds... SMS_SITE_BACKUP 3/30/2010 2:52:41 PM 588 (0x024C)
Sleeping for 5 seconds... SMS_SITE_BACKUP 3/30/2010 2:52:46 PM 588 (0x024C)
Sleeping for 5 seconds... SMS_SITE_BACKUP 3/30/2010 2:52:51 PM 588 (0x024C)
Sleeping for 5 seconds... SMS_SITE_BACKUP 3/30/2010 2:52:56 PM 588 (0x024C)
Sleeping for 5 seconds... SMS_SITE_BACKUP 3/30/2010 2:53:01 PM 588 (0x024C)
Sleeping for 5 seconds... SMS_SITE_BACKUP 3/30/2010 2:53:06 PM 588 (0x024C)
Sleeping for 5 seconds... SMS_SITE_BACKUP 3/30/2010 2:53:11 PM 588 (0x024C)
Sleeping for 5 seconds... SMS_SITE_BACKUP 3/30/2010 2:53:16 PM 588 (0x024C)
Sleeping for 5 seconds... SMS_SITE_BACKUP 3/30/2010 2:53:21 PM 588 (0x024C)
Sleeping for 5 seconds... SMS_SITE_BACKUP 3/30/2010 2:53:26 PM 588 (0x024C)
Sleeping for 5 seconds... SMS_SITE_BACKUP 3/30/2010 2:53:31 PM 588 (0x024C)
Sleeping for 5 seconds... SMS_SITE_BACKUP 3/30/2010 2:53:36 PM 588 (0x024C)
Sleeping for 5 seconds... SMS_SITE_BACKUP 3/30/2010 2:53:41 PM 588 (0x024C)
Sleeping for 5 seconds... SMS_SITE_BACKUP 3/30/2010 2:53:46 PM 588 (0x024C)
Sleeping for 5 seconds... SMS_SITE_BACKUP 3/30/2010 2:53:51 PM 588 (0x024C)
Sleeping for 5 seconds... SMS_SITE_BACKUP 3/30/2010 2:53:56 PM 588 (0x024C)
Sleeping for 5 seconds... SMS_SITE_BACKUP 3/30/2010 2:54:01 PM 588 (0x024C)
Sleeping for 5 seconds... SMS_SITE_BACKUP 3/30/2010 2:54:06 PM 588 (0x024C)
Sleeping for 5 seconds... SMS_SITE_BACKUP 3/30/2010 2:54:11 PM 588 (0x024C)
Sleeping for 5 seconds... SMS_SITE_BACKUP 3/30/2010 2:54:16 PM 588 (0x024C)
Sleeping for 5 seconds... SMS_SITE_BACKUP 3/30/2010 2:54:21 PM 588 (0x024C)
Sleeping for 5 seconds... SMS_SITE_BACKUP 3/30/2010 2:54:27 PM 588 (0x024C)
Sleeping for 5 seconds... SMS_SITE_BACKUP 3/30/2010 2:54:32 PM 588 (0x024C)
Sleeping for 5 seconds... SMS_SITE_BACKUP 3/30/2010 2:54:37 PM 588 (0x024C)
Sleeping for 5 seconds... SMS_SITE_BACKUP 3/30/2010 2:54:42 PM 588 (0x024C)
Sleeping for 5 seconds... SMS_SITE_BACKUP 3/30/2010 2:54:47 PM 588 (0x024C)
Sleeping for 5 seconds... SMS_SITE_BACKUP 3/30/2010 2:54:52 PM 588 (0x024C)
Sleeping for 5 seconds... SMS_SITE_BACKUP 3/30/2010 2:54:57 PM 588 (0x024C)
Sleeping for 5 seconds... SMS_SITE_BACKUP 3/30/2010 2:55:02 PM 588 (0x024C)
Sleeping for 5 seconds... SMS_SITE_BACKUP 3/30/2010 2:55:07 PM 588 (0x024C)
Sleeping for 5 seconds... SMS_SITE_BACKUP 3/30/2010 2:55:12 PM 588 (0x024C)
Sleeping for 5 seconds... SMS_SITE_BACKUP 3/30/2010 2:55:17 PM 588 (0x024C)
Sleeping for 5 seconds... SMS_SITE_BACKUP 3/30/2010 2:55:22 PM 588 (0x024C)
Sleeping for 5 seconds... SMS_SITE_BACKUP 3/30/2010 2:55:27 PM 588 (0x024C)
Sleeping for 5 seconds... SMS_SITE_BACKUP 3/30/2010 2:55:32 PM 588 (0x024C)
Sleeping for 5 seconds... SMS_SITE_BACKUP 3/30/2010 2:55:37 PM 588 (0x024C)
Sleeping for 5 seconds... SMS_SITE_BACKUP 3/30/2010 2:55:42 PM 588 (0x024C)
Sleeping for 5 seconds... SMS_SITE_BACKUP 3/30/2010 2:55:47 PM 588 (0x024C)
Sleeping for 5 seconds... SMS_SITE_BACKUP 3/30/2010 2:55:52 PM 588 (0x024C)
Sleeping for 5 seconds... SMS_SITE_BACKUP 3/30/2010 2:55:57 PM 588 (0x024C)
Sleeping for 5 seconds... SMS_SITE_BACKUP 3/30/2010 2:56:02 PM 588 (0x024C)
Sleeping for 5 seconds... SMS_SITE_BACKUP 3/30/2010 2:56:07 PM 588 (0x024C)
Sleeping for 5 seconds... SMS_SITE_BACKUP 3/30/2010 2:56:12 PM 588 (0x024C)
Sleeping for 5 seconds... SMS_SITE_BACKUP 3/30/2010 2:56:17 PM 588 (0x024C)
Error: Sql Server could not prepare for the Backup. SMS_SITE_BACKUP 3/30/2010 2:56:22 PM 588 (0x024C)
Aborting the backup process. SMS_SITE_BACKUP 3/30/2010 2:56:22 PM 588 (0x024C)
SMS_SITE_BACKUP 3/30/2010 2:56:22 PM 588 (0x024C)
Error: CreateSnapshotSet failed... SMS_SITE_BACKUP 3/30/2010 2:56:22 PM 588 (0x024C)
STATMSG: ID=5047 SEV=E LEV=M SOURCE="SMS Server" COMP="SMS_SITE_BACKUP" SYS=AITSCCM01 SITE=AIT PID=3784 TID=588 GMTDATE=Tue Mar 30 19:56:22.133 2010 ISTR0="" ISTR1="" ISTR2="" ISTR3="" ISTR4="" ISTR5="" ISTR6="" ISTR7="" ISTR8="" ISTR9="" NUMATTRS=0 SMS_SITE_BACKUP 3/30/2010 2:56:22 PM 588 (0x024C)
SMS site backup failed. Please see previous errors. SMS_SITE_BACKUP 3/30/2010 2:56:22 PM 588 (0x024C)
FileGroupFile = D:\APPS\MICROSOFT CONFIGURATION MANAGER\INBOXES\* [Recursive: yes] SMS_SITE_BACKUP 3/30/2010 2:51:21 PM 588 (0x024C)
Volume D:\ (that contains the file(s)) is marked as a candidate for snapshot. SMS_SITE_BACKUP 3/30/2010 2:51:21 PM 588 (0x024C)
Component 1 - XXXBackup\SiteServer\SMSSe
FileGroupFile = D:\APPS\MICROSOFT CONFIGURATION MANAGER\LOGS\* [Recursive: yes] SMS_SITE_BACKUP 3/30/2010 2:51:21 PM 588 (0x024C)
Volume D:\ (that contains the file(s)) is marked as a candidate for snapshot. SMS_SITE_BACKUP 3/30/2010 2:51:21 PM 588 (0x024C)
Component 2 - XXXBackup\SiteServer\SMSSe
FileGroupFile = D:\APPS\MICROSOFT CONFIGURATION MANAGER\DATA\* [Recursive: yes] SMS_SITE_BACKUP 3/30/2010 2:51:21 PM 588 (0x024C)
Volume D:\ (that contains the file(s)) is marked as a candidate for snapshot. SMS_SITE_BACKUP 3/30/2010 2:51:21 PM 588 (0x024C)
Component 3 - XXXBackup\SiteServer\SMSSe
FileGroupFile = D:\APPS\MICROSOFT CONFIGURATION MANAGER\SRVACCT\* [Recursive: yes] SMS_SITE_BACKUP 3/30/2010 2:51:21 PM 588 (0x024C)
Volume D:\ (that contains the file(s)) is marked as a candidate for snapshot. SMS_SITE_BACKUP 3/30/2010 2:51:21 PM 588 (0x024C)
Component 4 - XXXBackup\SiteServer\SMSbk
FileGroupFile = D:\APPS\MICROSOFT CONFIGURATION MANAGER\BackupTemp\SMSbkSi
Volume D:\ (that contains the file(s)) is marked as a candidate for snapshot. SMS_SITE_BACKUP 3/30/2010 2:51:21 PM 588 (0x024C)
Component 5 - XXXBackup\SiteServer\SMSbk
FileGroupFile = D:\APPS\MICROSOFT CONFIGURATION MANAGER\BackupTemp\SMSbkSi
Volume D:\ (that contains the file(s)) is marked as a candidate for snapshot. SMS_SITE_BACKUP 3/30/2010 2:51:21 PM 588 (0x024C)
Component 6 - XXXBackup\SiteDBServer\SMS
Dependency On SQL Writer , LogicalPath:\\XXXSCCMSQL, ComponentName:SMS_XXX SMS_SITE_BACKUP 3/30/2010 2:51:21 PM 588 (0x024C)
After GatherWriterMetadata SMS Writer status = STABLE. SMS_SITE_BACKUP 3/30/2010 2:51:21 PM 588 (0x024C)
Starting to clean and prepare the backup location. SMS_SITE_BACKUP 3/30/2010 2:51:21 PM 588 (0x024C)
Cleanup and/or preparation done. SMS_SITE_BACKUP 3/30/2010 2:51:21 PM 588 (0x024C)
Info: Sending message to start the SQL Backup... SMS_SITE_BACKUP 3/30/2010 2:51:21 PM 588 (0x024C)
Starting to create the snapshot set. SMS_SITE_BACKUP 3/30/2010 2:51:21 PM 588 (0x024C)
Added volume containing D:\ to the snapshot set. SMS_SITE_BACKUP 3/30/2010 2:51:21 PM 588 (0x024C)
Info: Starting Asynchronous PrepareForBackup... SMS_SITE_BACKUP 3/30/2010 2:51:21 PM 588 (0x024C)
Info: Asynchronous PrepareForBackup finished... SMS_SITE_BACKUP 3/30/2010 2:51:21 PM 588 (0x024C)
Info: Waiting for SQL to PrepareForBackup. SMS_SITE_BACKUP 3/30/2010 2:51:21 PM 588 (0x024C)
Sleeping for 5 seconds... SMS_SITE_BACKUP 3/30/2010 2:51:21 PM 588 (0x024C)
Sleeping for 5 seconds... SMS_SITE_BACKUP 3/30/2010 2:51:26 PM 588 (0x024C)
Sleeping for 5 seconds... SMS_SITE_BACKUP 3/30/2010 2:51:31 PM 588 (0x024C)
Sleeping for 5 seconds... SMS_SITE_BACKUP 3/30/2010 2:51:36 PM 588 (0x024C)
Sleeping for 5 seconds... SMS_SITE_BACKUP 3/30/2010 2:51:41 PM 588 (0x024C)
Sleeping for 5 seconds... SMS_SITE_BACKUP 3/30/2010 2:51:46 PM 588 (0x024C)
Sleeping for 5 seconds... SMS_SITE_BACKUP 3/30/2010 2:51:51 PM 588 (0x024C)
Sleeping for 5 seconds... SMS_SITE_BACKUP 3/30/2010 2:51:56 PM 588 (0x024C)
Sleeping for 5 seconds... SMS_SITE_BACKUP 3/30/2010 2:52:01 PM 588 (0x024C)
Sleeping for 5 seconds... SMS_SITE_BACKUP 3/30/2010 2:52:06 PM 588 (0x024C)
Sleeping for 5 seconds... SMS_SITE_BACKUP 3/30/2010 2:52:11 PM 588 (0x024C)
Sleeping for 5 seconds... SMS_SITE_BACKUP 3/30/2010 2:52:16 PM 588 (0x024C)
Sleeping for 5 seconds... SMS_SITE_BACKUP 3/30/2010 2:52:21 PM 588 (0x024C)
Sleeping for 5 seconds... SMS_SITE_BACKUP 3/30/2010 2:52:26 PM 588 (0x024C)
Sleeping for 5 seconds... SMS_SITE_BACKUP 3/30/2010 2:52:31 PM 588 (0x024C)
Sleeping for 5 seconds... SMS_SITE_BACKUP 3/30/2010 2:52:36 PM 588 (0x024C)
Sleeping for 5 seconds... SMS_SITE_BACKUP 3/30/2010 2:52:41 PM 588 (0x024C)
Sleeping for 5 seconds... SMS_SITE_BACKUP 3/30/2010 2:52:46 PM 588 (0x024C)
Sleeping for 5 seconds... SMS_SITE_BACKUP 3/30/2010 2:52:51 PM 588 (0x024C)
Sleeping for 5 seconds... SMS_SITE_BACKUP 3/30/2010 2:52:56 PM 588 (0x024C)
Sleeping for 5 seconds... SMS_SITE_BACKUP 3/30/2010 2:53:01 PM 588 (0x024C)
Sleeping for 5 seconds... SMS_SITE_BACKUP 3/30/2010 2:53:06 PM 588 (0x024C)
Sleeping for 5 seconds... SMS_SITE_BACKUP 3/30/2010 2:53:11 PM 588 (0x024C)
Sleeping for 5 seconds... SMS_SITE_BACKUP 3/30/2010 2:53:16 PM 588 (0x024C)
Sleeping for 5 seconds... SMS_SITE_BACKUP 3/30/2010 2:53:21 PM 588 (0x024C)
Sleeping for 5 seconds... SMS_SITE_BACKUP 3/30/2010 2:53:26 PM 588 (0x024C)
Sleeping for 5 seconds... SMS_SITE_BACKUP 3/30/2010 2:53:31 PM 588 (0x024C)
Sleeping for 5 seconds... SMS_SITE_BACKUP 3/30/2010 2:53:36 PM 588 (0x024C)
Sleeping for 5 seconds... SMS_SITE_BACKUP 3/30/2010 2:53:41 PM 588 (0x024C)
Sleeping for 5 seconds... SMS_SITE_BACKUP 3/30/2010 2:53:46 PM 588 (0x024C)
Sleeping for 5 seconds... SMS_SITE_BACKUP 3/30/2010 2:53:51 PM 588 (0x024C)
Sleeping for 5 seconds... SMS_SITE_BACKUP 3/30/2010 2:53:56 PM 588 (0x024C)
Sleeping for 5 seconds... SMS_SITE_BACKUP 3/30/2010 2:54:01 PM 588 (0x024C)
Sleeping for 5 seconds... SMS_SITE_BACKUP 3/30/2010 2:54:06 PM 588 (0x024C)
Sleeping for 5 seconds... SMS_SITE_BACKUP 3/30/2010 2:54:11 PM 588 (0x024C)
Sleeping for 5 seconds... SMS_SITE_BACKUP 3/30/2010 2:54:16 PM 588 (0x024C)
Sleeping for 5 seconds... SMS_SITE_BACKUP 3/30/2010 2:54:21 PM 588 (0x024C)
Sleeping for 5 seconds... SMS_SITE_BACKUP 3/30/2010 2:54:27 PM 588 (0x024C)
Sleeping for 5 seconds... SMS_SITE_BACKUP 3/30/2010 2:54:32 PM 588 (0x024C)
Sleeping for 5 seconds... SMS_SITE_BACKUP 3/30/2010 2:54:37 PM 588 (0x024C)
Sleeping for 5 seconds... SMS_SITE_BACKUP 3/30/2010 2:54:42 PM 588 (0x024C)
Sleeping for 5 seconds... SMS_SITE_BACKUP 3/30/2010 2:54:47 PM 588 (0x024C)
Sleeping for 5 seconds... SMS_SITE_BACKUP 3/30/2010 2:54:52 PM 588 (0x024C)
Sleeping for 5 seconds... SMS_SITE_BACKUP 3/30/2010 2:54:57 PM 588 (0x024C)
Sleeping for 5 seconds... SMS_SITE_BACKUP 3/30/2010 2:55:02 PM 588 (0x024C)
Sleeping for 5 seconds... SMS_SITE_BACKUP 3/30/2010 2:55:07 PM 588 (0x024C)
Sleeping for 5 seconds... SMS_SITE_BACKUP 3/30/2010 2:55:12 PM 588 (0x024C)
Sleeping for 5 seconds... SMS_SITE_BACKUP 3/30/2010 2:55:17 PM 588 (0x024C)
Sleeping for 5 seconds... SMS_SITE_BACKUP 3/30/2010 2:55:22 PM 588 (0x024C)
Sleeping for 5 seconds... SMS_SITE_BACKUP 3/30/2010 2:55:27 PM 588 (0x024C)
Sleeping for 5 seconds... SMS_SITE_BACKUP 3/30/2010 2:55:32 PM 588 (0x024C)
Sleeping for 5 seconds... SMS_SITE_BACKUP 3/30/2010 2:55:37 PM 588 (0x024C)
Sleeping for 5 seconds... SMS_SITE_BACKUP 3/30/2010 2:55:42 PM 588 (0x024C)
Sleeping for 5 seconds... SMS_SITE_BACKUP 3/30/2010 2:55:47 PM 588 (0x024C)
Sleeping for 5 seconds... SMS_SITE_BACKUP 3/30/2010 2:55:52 PM 588 (0x024C)
Sleeping for 5 seconds... SMS_SITE_BACKUP 3/30/2010 2:55:57 PM 588 (0x024C)
Sleeping for 5 seconds... SMS_SITE_BACKUP 3/30/2010 2:56:02 PM 588 (0x024C)
Sleeping for 5 seconds... SMS_SITE_BACKUP 3/30/2010 2:56:07 PM 588 (0x024C)
Sleeping for 5 seconds... SMS_SITE_BACKUP 3/30/2010 2:56:12 PM 588 (0x024C)
Sleeping for 5 seconds... SMS_SITE_BACKUP 3/30/2010 2:56:17 PM 588 (0x024C)
Error: Sql Server could not prepare for the Backup. SMS_SITE_BACKUP 3/30/2010 2:56:22 PM 588 (0x024C)
Aborting the backup process. SMS_SITE_BACKUP 3/30/2010 2:56:22 PM 588 (0x024C)
SMS_SITE_BACKUP 3/30/2010 2:56:22 PM 588 (0x024C)
Error: CreateSnapshotSet failed... SMS_SITE_BACKUP 3/30/2010 2:56:22 PM 588 (0x024C)
STATMSG: ID=5047 SEV=E LEV=M SOURCE="SMS Server" COMP="SMS_SITE_BACKUP" SYS=AITSCCM01 SITE=AIT PID=3784 TID=588 GMTDATE=Tue Mar 30 19:56:22.133 2010 ISTR0="" ISTR1="" ISTR2="" ISTR3="" ISTR4="" ISTR5="" ISTR6="" ISTR7="" ISTR8="" ISTR9="" NUMATTRS=0 SMS_SITE_BACKUP 3/30/2010 2:56:22 PM 588 (0x024C)
SMS site backup failed. Please see previous errors. SMS_SITE_BACKUP 3/30/2010 2:56:22 PM 588 (0x024C)
You have a remote SQL Server maybe Cluster?
Please post the logfiles smsbkup.log from the Site Server and smssqlbkup.log from the SQL Server
Please post the logfiles smsbkup.log from the Site Server and smssqlbkup.log from the SQL Server
ASKER
I've seen the posts about clusters, no we dont. Yes, its remote. Hang on
ok.you post the logfiles?
ASKER
The last entries in that log are from 2-24 which is when I think this broke. Its a pretty big log, what should I be looking for? It looks like it was successful until this date
ASKER
Here it is
i would like to check it for further errors. Could you post it?
I've collected some questions which you should check to make sure that these things are configure correctly:
- Can you check the if you can reach the SQL Server from Site Server via UNC Path?
- Can you access the SQL Servers registry from remote ?(Remote Registry Service)
- Is there maybe running another backup job at the same time with your SCCM backup? VSS can only handle one job at the same time.
- Is the Volume Shadow Copy Service running on the SQL Server?
- Is the Site Server's machine account memmber of the SQL sysadmin Group?
- Is the Site Server'S machine account member of the SQL Servers local administrators?
- Are you running the SQL Service under a service account context or with local system account?
If yes:
1. Check if Kerberos is enabled on the SQL Server with the following command
select auth_scheme from sys.dm_exec_connections where session_id=@@spid
2. Check if the SPN's are registerd successfully for the service account
--> setspn - L <ServiceAccountName>
Has to be twice. With and without SQL Port number (normally 1433)
I've collected some questions which you should check to make sure that these things are configure correctly:
- Can you check the if you can reach the SQL Server from Site Server via UNC Path?
- Can you access the SQL Servers registry from remote ?(Remote Registry Service)
- Is there maybe running another backup job at the same time with your SCCM backup? VSS can only handle one job at the same time.
- Is the Volume Shadow Copy Service running on the SQL Server?
- Is the Site Server's machine account memmber of the SQL sysadmin Group?
- Is the Site Server'S machine account member of the SQL Servers local administrators?
- Are you running the SQL Service under a service account context or with local system account?
If yes:
1. Check if Kerberos is enabled on the SQL Server with the following command
select auth_scheme from sys.dm_exec_connections where session_id=@@spid
2. Check if the SPN's are registerd successfully for the service account
--> setspn - L <ServiceAccountName>
Has to be twice. With and without SQL Port number (normally 1433)
ASKER
Thanks for your help, I got it figured out
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.