Link to home
Start Free TrialLog in
Avatar of AIT
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?  
Avatar of merowinger
merowinger
Flag of Germany image

could you please post the sms backup logfiles
Avatar of AIT
AIT

ASKER

Component 0 - AITBackup\SiteServer\SMSServer\inboxes.      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\SMSServer\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\SMSServer\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\SMSServer\srvacct.      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\SMSbkSiteRegNAL.dat.      SMS_SITE_BACKUP      3/30/2010 2:51:21 PM      588 (0x024C)
FileGroupFile = D:\APPS\MICROSOFT CONFIGURATION MANAGER\BackupTemp\SMSbkSiteRegNAL.dat [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\SMSbkSiteRegSMS.dat.      SMS_SITE_BACKUP      3/30/2010 2:51:21 PM      588 (0x024C)
FileGroupFile = D:\APPS\MICROSOFT CONFIGURATION MANAGER\BackupTemp\SMSbkSiteRegSMS.dat [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\SMSbkSQLDBsite.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)
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
Avatar of AIT

ASKER

I've seen the posts about clusters, no we dont.  Yes, its remote.  Hang on
ok.you post the logfiles?
Avatar of AIT

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
Avatar of AIT

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)
Avatar of AIT

ASKER

Thanks for your help, I got it figured out
ASKER CERTIFIED SOLUTION
Avatar of AIT
AIT

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial