Configuration Manager Backup and Recovery ForumDiscussions on Backup and Recovery for System Center Configuration Manager Sites© 2009 Microsoft Corporation. All rights reserved.Thu, 26 Nov 2009 04:41:26 Zcb8a5d9a-40de-4012-9669-819f5cbabf98http://social.technet.microsoft.com/Forums/en-US/configmgrbackup/thread/c114d97a-2f39-467c-b0d1-d2f38a373b5ehttp://social.technet.microsoft.com/Forums/en-US/configmgrbackup/thread/c114d97a-2f39-467c-b0d1-d2f38a373b5eveday001http://social.technet.microsoft.com/Profile/en-US/?user=veday001Urgent :Restoring after Central site and Primary site upgraded from SCCM SP1 to SP2 Hi Guys<br/><br/>We took full backup of Primary sites before upgrade thinking we can restore it to SP1 if we encountered any major issues. In test environment, we replicated this situation, After upgrading to SP2 when I tried to restore SP1 again from backup using Config Mgr Site Repair Wizard. It instantly gives error message &quot;Verify Backup Path&quot; Failed. I read the post <br/><a href="http://social.technet.microsoft.com/Forums/en/configmgrbackup/thread/f6f7be22-deaf-4e9c-95be-87fb6240a6c8">http://social.technet.microsoft.com/Forums/en/configmgrbackup/thread/f6f7be22-deaf-4e9c-95be-87fb6240a6c8</a><br/><br/>It says: &quot;Backup was taken on SP1 and we tried to restore it without SP1 and so failed&quot;<br/><br/>If Primary servers are upgraded from SCCM SP1 to SP2 and we got backup when site server was SP1. If we have issue at that stage then we actually need to uninstall SP2, reinstall SP1 and then use Backup to restore it. Is that sound right? Its sound ridiculous to me, If i uninstall Central Site, all the year work on the infrastructure would be lost. Also there is no guarrenty, restoring from Backup will bring us back to same state.<br/>Is there any way we can restore our state to SP1 being on SP2 at the same timewe can have our system intact?<br/><br/>Its really urgent.. Please advice<br/><br/>Thanks in Advance<br/> <p>Veday</p> <hr class=sig> Server EngineerWed, 25 Nov 2009 23:53:14 Z2009-11-26T04:41:26Zhttp://social.technet.microsoft.com/Forums/en-US/configmgrbackup/thread/294dee43-deaa-4f0c-91f0-c23602936714http://social.technet.microsoft.com/Forums/en-US/configmgrbackup/thread/294dee43-deaa-4f0c-91f0-c23602936714tammachttp://social.technet.microsoft.com/Profile/en-US/?user=tammacSCCM SP2 Upgrade MP installation issue<p>Hi,<br/>I've upgrade my site to SCCM sp2 but the upgrade fails to install the MP, the error message is: <br/>MP Control Manager detected MPsetup has failed to create the CCM_Incoming Virtual Directory.</p> <p>Possible cause: The IIS IWAM account has expired, been disabled, or has invalid or too restrictive logon hours. You may verify this information by running the net user command line for the IWAM account.  (i.e.: &quot;net user IWAMMachineName)<br/>Solution: Use the output to verify that the account is enabled, and logon is possible during the time of installation.  Note:  You can use &quot;net user&quot; to modify the account properties.</p> <p>Possible cause: The IIS IUSR account has expired, been disabled, or has invalid or too restrictive logon hours. You may verify this information by running the net user command line for the IUSR account.  (i.e.: &quot;net user IWAMMachineName)<br/>Solution: Use the output to verify that the account is enabled, and logon is possible during the time of installation.  Note:  You can use &quot;net user&quot; to modify the account properties.</p> <p>Possible cause: The designated Web Site is disabled in IIS. <br/>Solution: Verify that the designated Web Site is enabled, and functioning properly.<br/><br/>I've tried reinstalling IIS, my reporting site works fine.<br/><br/>Help!</p>Fri, 20 Nov 2009 10:50:04 Z2009-11-25T08:46:31Zhttp://social.technet.microsoft.com/Forums/en-US/configmgrbackup/thread/1443bfd6-7346-4f6b-852d-c0011327534bhttp://social.technet.microsoft.com/Forums/en-US/configmgrbackup/thread/1443bfd6-7346-4f6b-852d-c0011327534bMarculoshttp://social.technet.microsoft.com/Profile/en-US/?user=MarculosBackup will not runHi, <br/><br/>I am trying to create a backup. The weekly backup normally works ok. I got the backup to run once and now it will no longer run, though it looks like the backup service is stopping and starting. Any ideas would be most appreciated, permissions etc all look good.<br/><br/><br/>The log file is as follows.Initializing the status message reporting system... SMS_SITE_BACKUP 24/11/2009 09:34:08 3156 (0x0C54)<br/>    The path to the &quot;Status Manager&quot; inbox is &quot;F:\Program Files\Microsoft Configuration Manager\inboxes\statmgr.box\statmsgs&quot;. SMS_SITE_BACKUP 24/11/2009 09:34:08 3156 (0x0C54)<br/>    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 24/11/2009 09:34:08 3156 (0x0C54)<br/>Registered this process as a source of &quot;SMS Server&quot; events. SMS_SITE_BACKUP 24/11/2009 09:34:08 3156 (0x0C54)<br/>Registered this process as a source of &quot;SMS Client&quot; events. SMS_SITE_BACKUP 24/11/2009 09:34:08 3156 (0x0C54)<br/>Registered this process as a source of &quot;SMS Provider&quot; events. SMS_SITE_BACKUP 24/11/2009 09:34:08 3156 (0x0C54)<br/>Status message reporting system initialized successfully. SMS_SITE_BACKUP 24/11/2009 09:34:08 3156 (0x0C54)<br/>Locale set to OS value (English_United States.1252). SMS_SITE_BACKUP 24/11/2009 09:34:08 3156 (0x0C54)<br/>SMS site backup service 4.00 started. SMS_SITE_BACKUP 24/11/2009 09:34:08 3156 (0x0C54)<br/>STATMSG: ID=500 SEV=I LEV=M SOURCE=&quot;SMS Server&quot; COMP=&quot;SMS_SITE_BACKUP&quot; SYS=ASHSACCM01 SITE=ASH PID=9672 TID=3156 GMTDATE=Tue Nov 24 09:34:08.706 2009 ISTR0=&quot;SMS site backup&quot; ISTR1=&quot;&quot; ISTR2=&quot;&quot; ISTR3=&quot;&quot; ISTR4=&quot;&quot; ISTR5=&quot;&quot; ISTR6=&quot;&quot; ISTR7=&quot;&quot; ISTR8=&quot;&quot; ISTR9=&quot;&quot; NUMATTRS=0 SMS_SITE_BACKUP 24/11/2009 09:34:08 3156 (0x0C54)<br/>11/24/09 09:34:08 - starting backup. SMS_SITE_BACKUP 24/11/2009 09:34:08 3156 (0x0C54)<br/>BackupDir = F:\DATA\BACKUP. SMS_SITE_BACKUP 24/11/2009 09:34:08 3156 (0x0C54)<br/>Installation RootDir = F:\PROGRAM FILES\MICROSOFT CONFIGURATION MANAGER. SMS_SITE_BACKUP 24/11/2009 09:34:08 3156 (0x0C54)<br/>Site SQL Dir = . SMS_SITE_BACKUP 24/11/2009 09:34:08 3156 (0x0C54)<br/>Warning: Backup location and the sms data (installation directory) are on the same volume. Sms Backup creates snapshot of the volume using VSS services and then copies the data to the backup location. It is advisable to have the backup location on a different volume (different than the one that has SMS data and SMS database files), so that the writes to the volume is minimal when the volume snapshot is active. SMS_SITE_BACKUP 24/11/2009 09:34:08 3156 (0x0C54)<br/>Sql Writer service is running. SMS_SITE_BACKUP 24/11/2009 09:34:08 3156 (0x0C54)<br/>SMS sql data files: C:\SMSData\SMSData_ASH.MDF, C:\SMSData\SMSLog_ASH.LDF SMS_SITE_BACKUP 24/11/2009 09:34:08 3156 (0x0C54)<br/>Site Backup Location = F:\Data\Backup SMS_SITE_BACKUP 24/11/2009 09:34:08 3156 (0x0C54)<br/>SQL Backup Location = F:\Data\Backup SMS_SITE_BACKUP 24/11/2009 09:34:08 3156 (0x0C54)<br/>STATMSG: ID=5055 SEV=I LEV=M SOURCE=&quot;SMS Server&quot; COMP=&quot;SMS_SITE_BACKUP&quot; SYS=ASHSACCM01 SITE=ASH PID=9672 TID=3156 GMTDATE=Tue Nov 24 09:34:08.956 2009 ISTR0=&quot;&quot; ISTR1=&quot;&quot; ISTR2=&quot;&quot; ISTR3=&quot;&quot; ISTR4=&quot;&quot; ISTR5=&quot;&quot; ISTR6=&quot;&quot; ISTR7=&quot;&quot; ISTR8=&quot;&quot; ISTR9=&quot;&quot; NUMATTRS=0 SMS_SITE_BACKUP 24/11/2009 09:34:08 3156 (0x0C54)<br/>LogEvent(): Successfully logged Event to NT Event Log. (4 - 48 - 1,073,746,879) SMS_SITE_BACKUP 24/11/2009 09:34:09 3156 (0x0C54)<br/>Starting VSS initialization... SMS_SITE_BACKUP 24/11/2009 09:34:09 3156 (0x0C54)<br/>Starting Asynchronous GatherWriterMetadata. SMS_SITE_BACKUP 24/11/2009 09:34:09 3156 (0x0C54)<br/>Number of writers that responded: 10. SMS_SITE_BACKUP 24/11/2009 09:34:12 3156 (0x0C54)<br/>Reading SMS Writer metadata... SMS_SITE_BACKUP 24/11/2009 09:34:12 3156 (0x0C54)<br/>Number of FileIncludes: 0. SMS_SITE_BACKUP 24/11/2009 09:34:12 3156 (0x0C54)<br/>Number of FileExcludes: 0. SMS_SITE_BACKUP 24/11/2009 09:34:12 3156 (0x0C54)<br/>Number of Components: 7. SMS_SITE_BACKUP 24/11/2009 09:34:12 3156 (0x0C54)<br/>Component 0 - ASHBackup\SiteServer\SMSServer\inboxes. SMS_SITE_BACKUP 24/11/2009 09:34:12 3156 (0x0C54)<br/>FileGroupFile = F:\PROGRAM FILES\MICROSOFT CONFIGURATION MANAGER\INBOXES\* [Recursive: yes] SMS_SITE_BACKUP 24/11/2009 09:34:12 3156 (0x0C54)<br/>Volume F:\ (that contains the file(s)) is marked as a candidate for snapshot. SMS_SITE_BACKUP 24/11/2009 09:34:12 3156 (0x0C54)<br/>Component 1 - ASHBackup\SiteServer\SMSServer\Logs. SMS_SITE_BACKUP 24/11/2009 09:34:12 3156 (0x0C54)<br/>FileGroupFile = F:\PROGRAM FILES\MICROSOFT CONFIGURATION MANAGER\LOGS\* [Recursive: yes] SMS_SITE_BACKUP 24/11/2009 09:34:12 3156 (0x0C54)<br/>Volume F:\ (that contains the file(s)) is marked as a candidate for snapshot. SMS_SITE_BACKUP 24/11/2009 09:34:12 3156 (0x0C54)<br/>Component 2 - ASHBackup\SiteServer\SMSServer\data. SMS_SITE_BACKUP 24/11/2009 09:34:12 3156 (0x0C54)<br/>FileGroupFile = F:\PROGRAM FILES\MICROSOFT CONFIGURATION MANAGER\DATA\* [Recursive: yes] SMS_SITE_BACKUP 24/11/2009 09:34:12 3156 (0x0C54)<br/>Volume F:\ (that contains the file(s)) is marked as a candidate for snapshot. SMS_SITE_BACKUP 24/11/2009 09:34:12 3156 (0x0C54)<br/>Component 3 - ASHBackup\SiteServer\SMSServer\srvacct. SMS_SITE_BACKUP 24/11/2009 09:34:12 3156 (0x0C54)<br/>FileGroupFile = F:\PROGRAM FILES\MICROSOFT CONFIGURATION MANAGER\SRVACCT\* [Recursive: yes] SMS_SITE_BACKUP 24/11/2009 09:34:12 3156 (0x0C54)<br/>Volume F:\ (that contains the file(s)) is marked as a candidate for snapshot. SMS_SITE_BACKUP 24/11/2009 09:34:12 3156 (0x0C54)<br/>Component 4 - ASHBackup\SiteServer\SMSbkSiteRegNAL.dat. SMS_SITE_BACKUP 24/11/2009 09:34:12 3156 (0x0C54)<br/>FileGroupFile = F:\Program Files\Microsoft Configuration Manager\BackupTemp\SMSbkSiteRegNAL.dat [Recursive: no] SMS_SITE_BACKUP 24/11/2009 09:34:12 3156 (0x0C54)<br/>Volume F:\ (that contains the file(s)) is marked as a candidate for snapshot. SMS_SITE_BACKUP 24/11/2009 09:34:12 3156 (0x0C54)<br/>Component 5 - ASHBackup\SiteServer\SMSbkSiteRegSMS.dat. SMS_SITE_BACKUP 24/11/2009 09:34:12 3156 (0x0C54)<br/>FileGroupFile = F:\Program Files\Microsoft Configuration Manager\BackupTemp\SMSbkSiteRegSMS.dat [Recursive: no] SMS_SITE_BACKUP 24/11/2009 09:34:12 3156 (0x0C54)<br/>Volume F:\ (that contains the file(s)) is marked as a candidate for snapshot. SMS_SITE_BACKUP 24/11/2009 09:34:12 3156 (0x0C54)<br/>Component 6 - ASHBackup\SiteDBServer\SMSbkSQLDBsite.dat. SMS_SITE_BACKUP 24/11/2009 09:34:12 3156 (0x0C54)<br/>Dependency On SQL Writer , LogicalPath:ASHSACCM01\HRCMAPRD, ComponentName:SMS_ASH SMS_SITE_BACKUP 24/11/2009 09:34:12 3156 (0x0C54)<br/>SQL Server is on the same box as the Site Server. So, no need to communicate to the SQL backup agent. SMS_SITE_BACKUP 24/11/2009 09:34:12 3156 (0x0C54)<br/>FileGroupFile = F:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATASMS_ASH.mdf [Recursive: no] SMS_SITE_BACKUP 24/11/2009 09:34:12 3156 (0x0C54)<br/>Volume F:\ (that contains the file(s)) is marked as a candidate for snapshot. SMS_SITE_BACKUP 24/11/2009 09:34:12 3156 (0x0C54)<br/>FileGroupFile = F:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATASMS_ASH_log.LDF [Recursive: no] SMS_SITE_BACKUP 24/11/2009 09:34:12 3156 (0x0C54)<br/>Volume F:\ (that contains the file(s)) is marked as a candidate for snapshot. SMS_SITE_BACKUP 24/11/2009 09:34:12 3156 (0x0C54)<br/>After GatherWriterMetadata SQL Writer status = STABLE. SMS_SITE_BACKUP 24/11/2009 09:34:12 3156 (0x0C54)<br/>After GatherWriterMetadata SMS Writer status = STABLE. SMS_SITE_BACKUP 24/11/2009 09:34:12 3156 (0x0C54)<br/>Starting to clean and prepare the backup location. SMS_SITE_BACKUP 24/11/2009 09:34:12 3156 (0x0C54)<br/>Deleting F:\Data\Backup\ASHBackup, FAILED, Win32 Error = 32 SMS_SITE_BACKUP 24/11/2009 09:34:19 3156 (0x0C54)<br/>Failed to delete the contents of the backup folder. Error Code = 0x0 SMS_SITE_BACKUP 24/11/2009 09:34:20 3156 (0x0C54)<br/>Error: Deleting the existing files in the backup location failed... SMS_SITE_BACKUP 24/11/2009 09:34:20 3156 (0x0C54)<br/>STATMSG: ID=5026 SEV=E LEV=M SOURCE=&quot;SMS Server&quot; COMP=&quot;SMS_SITE_BACKUP&quot; SYS=ASHSACCM01 SITE=ASH PID=9672 TID=3156 GMTDATE=Tue Nov 24 09:34:20.019 2009 ISTR0=&quot;F:\Data\Backup&quot; ISTR1=&quot;&quot; ISTR2=&quot;&quot; ISTR3=&quot;&quot; ISTR4=&quot;&quot; ISTR5=&quot;&quot; ISTR6=&quot;&quot; ISTR7=&quot;&quot; ISTR8=&quot;&quot; ISTR9=&quot;&quot; NUMATTRS=0 SMS_SITE_BACKUP 24/11/2009 09:34:20 3156 (0x0C54)<br/>SMS site backup failed. Please see previous errors. SMS_SITE_BACKUP 24/11/2009 09:34:20 3156 (0x0C54)<br/><br/><br/>Tue, 24 Nov 2009 11:09:37 Z2009-11-25T10:54:23Zhttp://social.technet.microsoft.com/Forums/en-US/configmgrbackup/thread/c73e5ab0-c628-469b-a5bb-4bc6c13d1e0dhttp://social.technet.microsoft.com/Forums/en-US/configmgrbackup/thread/c73e5ab0-c628-469b-a5bb-4bc6c13d1e0dGinodhhttp://social.technet.microsoft.com/Profile/en-US/?user=GinodhMP error after running site repair<p align=left><font face=Arial size=2></font> </p> <p>Hello,</p> <p align=left> </p> <p align=left>We are using SCCM 2007 R2 installed on Windows Server STD 32-bit</p> <p align=left> </p> <p align=left>SQL server is remote ( SQL 2005 , Server 2008 STd 32-bit )</p> <p align=left> </p> <p align=left>After testing the DRP plan I perfomed a site repair of the SCCM site.</p> <p align=left> </p> <p align=left>However the MP is unable to install, I recieve the following error </p> <p align=left>MSI (s) (18!74) [10:55:51:419]: Product: SMS Management Point -- Error 25006. Setup was unable to create the Internet virtual directory CCM_Incoming<br>The error code is 800CC801</p> <p align=left>Error 25006. Setup was unable to create the Internet virtual directory CCM_Incoming<br>The error code is 800CC801</p> <p align=left> </p> <p align=left>Any help would be appreciated ...</p>Thu, 23 Oct 2008 09:04:38 Z2009-11-24T19:53:00Zhttp://social.technet.microsoft.com/Forums/en-US/configmgrbackup/thread/e9342b15-2608-4ce7-8056-52cfae4659behttp://social.technet.microsoft.com/Forums/en-US/configmgrbackup/thread/e9342b15-2608-4ce7-8056-52cfae4659beveday001http://social.technet.microsoft.com/Profile/en-US/?user=veday001Setup was unable to create the Internet virtual directory CCM_Incoming. The error code is 8007000DHi<br/><br/>At one of the secondary site, MPSETUP.log file is giving following error<br/>Setup was unable to create the Internet virtual directory CCM_Incoming. The error code is 8007000D<br/><br/>Tried to remove and reinstall MP &gt;&gt;&gt; Same Error<br/><br/>As per <br/><a href="http://social.technet.microsoft.com/Forums/en-US/configmgrsetup/thread/7ce16575-474c-4a0e-8eca-be4f4fc7344c">http://social.technet.microsoft.com/Forums/en-US/configmgrsetup/thread/7ce16575-474c-4a0e-8eca-be4f4fc7344c</a><br/><br/>Again Remove BITS and Reinstall BITS through ADD\Remove Windows Component. Same Error<br/><br/>Tried to install manually using mp.msi but returning same error<br/><br/>Please advice, any more ideas..<br/><br/>Your help would be much appreciated<br/><br/>Thanks &amp; Regards<br/><br/>Veday  <hr class=sig> Server EngineerSun, 22 Nov 2009 09:15:25 Z2009-11-24T12:23:15Zhttp://social.technet.microsoft.com/Forums/en-US/configmgrbackup/thread/e44624ca-79ed-487a-9aca-7e064ac245cchttp://social.technet.microsoft.com/Forums/en-US/configmgrbackup/thread/e44624ca-79ed-487a-9aca-7e064ac245ccSandy Woodhttp://social.technet.microsoft.com/Profile/en-US/?user=Sandy%20WoodErrors with nightly site backup<p align=left><font face=Arial size=2>Ever since I upgraded my SMS 2003 site I've been getting errors with my nightly site backup task. I'm backing up my site to the same drive (D<img alt=Smile src="http://forums.microsoft.com/MSDN/emoticons/emotion-1.gif"> that Config Mgr is installed on. The database is about 3 gb and the free space on D: is 60 gb.</font></p> <p align=left> </p> <p align=left>The database file and log file appear to be getting backed up despite some SQL / VSS errors that appear in my smsbkup.log. </p> <p align=left> </p> <p align=left>I'm getting this warning presumabley because my backup is on the same volume as my db / log files:</p> <p align=left> </p> <p align=left>Warning: Backup location and the sms sql data/log files are on the same volume. Sms Backup creates snapshot of the volume using VSS services and then copies the data to the backup location. It is advisable to have the backup location on a different volume (different than the one that has SMS data and SMS database files), so that the writes to the volume is minimal when the volume snapshot is active.</p> <p align=left> </p> <p>Further down I get this error:</p> <p> </p> <p align=left>After GatherWriterMetadata SQL Writer status = FAILED_AT_FREEZE.</p> <p align=left>Error: VSS_E_WRITERERROR_RETRYABLE. Error Code = 0x80,042,3f3.</p> <p align=left>After GatherWriterMetadata SMS Writer status = FAILED_AT_PREPARE_SNAPSHOT.</p> <p align=left>Error: VSS_E_WRITERERROR_RETRYABLE. Error Code = 0x80,042,3f3.</p> <p align=left> </p> <p align=left>Things continue on until</p> <p align=left> </p> <p align=left>After DoSnapshotSet SQL Writer status = FAILED_AT_FREEZE.</p> <p align=left>Error: VSS_E_WRITERERROR_NONRETRYABLE. Error Code = 0x80,042,3f4.</p> <p align=left>After DoSnapshotSet SMS Writer status = FAILED_AT_PREPARE_SNAPSHOT.</p> <p align=left> </p> <p align=left>Now the backup continues and shows it has suceeded in backing up all the Components. Then I see</p> <p align=left> </p> <p align=left>After BackupComplete SQL Writer status = FAILED_AT_FREEZE.</p> <p align=left>Error: VSS_E_WRITERERROR_NONRETRYABLE. Error Code = 0x80,042,3f4.</p> <p align=left>After BackupComplete SMS Writer status = FAILED_AT_PREPARE_SNAPSHOT.</p> <p align=left>03/17/08 04:54:31 - backup completed.</p> <p align=left>Backup task completed successfully with zero errors but there could be some warnings, AFTERBACKUP.BAT will be started if available in its predefined location</p> <p align=left> </p> <p align=left> </p> <p align=left>Looks like all went well despite the warnings! Should I be concerned?</p> <p align=left> </p>Mon, 17 Mar 2008 18:07:17 Z2009-11-20T21:52:48Zhttp://social.technet.microsoft.com/Forums/en-US/configmgrbackup/thread/b20a571f-6305-4fcc-9cbd-f51348705c78http://social.technet.microsoft.com/Forums/en-US/configmgrbackup/thread/b20a571f-6305-4fcc-9cbd-f51348705c78.Tim Harrisonhttp://social.technet.microsoft.com/Profile/en-US/?user=.Tim%20HarrisonJust SCCM Backup Task needed?Is there anything other than the built-in SCCM Site Backup task that should be done to ensure that a hierarchy with one primary central site server and 4 secondary site servers can be restored?  Is anything else recommended such as IIS backups or any file directories?  <br/> <br/> ThanksFri, 20 Nov 2009 16:34:29 Z2009-11-20T18:25:14Zhttp://social.technet.microsoft.com/Forums/en-US/configmgrbackup/thread/6c32bfad-8a16-48e5-9b9a-f6aef70453a6http://social.technet.microsoft.com/Forums/en-US/configmgrbackup/thread/6c32bfad-8a16-48e5-9b9a-f6aef70453a6xtiyu32nhttp://social.technet.microsoft.com/Profile/en-US/?user=xtiyu32nMoving SCCM Installation to New DriveI've come into a situation where a customer has SCCM installed on C:\ (not sure why??) and they are running out of space.  There is ample space on E:\ (100+ GB free) if I can only figure out how to move the installation.  I don't beleve the repair wizard will do this, will it??  My concern is the drive letters will be changing.  I assume this will cause issues (registry, etc.).  This is a rather small environment:<br/>-1 Primary Site Server (local SQL)<br/>-2 MP's<br/>-2 SUP's<br/>-20 DP's<br/>-about 1500 clients<br/><br/>Has anyone done this before or have any ideas on what the procedure is for this?<br/><br/>Thanks!<hr class="sig">xtiyu32nTue, 17 Nov 2009 18:38:02 Z2009-11-18T21:38:13Zhttp://social.technet.microsoft.com/Forums/en-US/configmgrbackup/thread/93cb5fdc-584f-4dbf-b71c-db1b8e19143fhttp://social.technet.microsoft.com/Forums/en-US/configmgrbackup/thread/93cb5fdc-584f-4dbf-b71c-db1b8e19143fklsshttp://social.technet.microsoft.com/Profile/en-US/?user=klssSMS Application Backup Issue<p class=MsoNormal><span style="font-size:x-small;color:#0000ff;font-family:Verdana"><span style="font-size:10pt;color:blue;font-family:Verdana">Hello,<br/><br/>we have couple of SMS Application servers in our environment. Recently we migrated from SQL 2000 to SQL 2005 and changed SQL Service from &quot;Local System&quot; to our &quot;Service account&quot;. When SMS application takes backup from their consol we are getting following error messages and backups are failing. <br/><br/>We cahnged SQL Service account from &quot;Service Account&quot; to &quot;Local System&quot; then backups are running from SMS application console.<br/><br/>Backup Failing Observations: <br/>1)Our Service Account is in Administrator Group<br/>2)Granted permissions in Local Security Policyes<br/>3) Builtin\ Administrator is Available<br/>4) NTAuthority \ System is available<br/>5) Granted Full rights to SQL Folders<br/><br/></span></span></p> <p class=MsoNormal><span style="font-size:x-small;color:#0000ff;font-family:Verdana"><span style="font-size:10pt;color:blue;font-family:Verdana"></span></span></p> <p class=MsoNormal><span style="font-size:x-small;color:#0000ff;font-family:Verdana"><span style="font-size:10pt;color:blue;font-family:Verdana">*** backup database SMS_CHE to DISK = 'E:\_SMFFB.tmp' with INIT    SMS_SITE_BACKUP   1/7/2009 6:32:02 PM      840 (0x0348)</span></span></p> <p class=MsoNormal><span style="font-size:x-small;color:#0000ff;font-family:Verdana"><span style="font-size:10pt;color:blue;font-family:Verdana">*** [42000][3201][Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open backup device 'E:\_SMFFB.tmp'. Operating system error 5(Access is denied.).   SMS_SITE_BACKUP   1/7/2009 6:32:02 PM 840 (0x0348)</span></span></p> <p class=MsoNormal><span style="font-size:x-small;color:#0000ff;font-family:Verdana"><span style="font-size:10pt;color:blue;font-family:Verdana">*** backup database SMS_CHE to DISK = 'E:\_SMFFB.tmp' with INIT    SMS_SITE_BACKUP   1/7/2009 6:32:02 PM      840 (0x0348)</span></span></p> <p class=MsoNormal><span style="font-size:x-small;color:#0000ff;font-family:Verdana"><span style="font-size:10pt;color:blue;font-family:Verdana">*** [42000][3013][Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP DATABASE is terminating abnormally.    SMS_SITE_BACKUP   1/7/2009 6:32:02 PM 840 (0x0348)</span></span></p> <p class=MsoNormal><span style="font-size:x-small;color:#0000ff;font-family:Verdana"><span style="font-size:10pt;color:blue;font-family:Verdana">Failed to backup site database SMS_CHE up to E:\mssql\data\sms_bak\CHEBackup\SiteDBServer\SMSbkSQLDBsite.dat: ~Error executing SQL backup command.          SMS_SITE_BACKUP   1/7/2009 6:32:02 PM 840 (0x0348)</span></span></p> <p class=MsoNormal><span style="font-size:x-small;color:#0000ff;font-family:Verdana"><span style="font-size:10pt;color:blue;font-family:Verdana"></span></span></p> <p class=MsoNormal><span style="font-size:x-small;color:#0000ff;font-family:Verdana"><span style="font-size:10pt;color:blue;font-family:Verdana"></span></span></p> <p class=MsoNormal><span style="font-size:x-small;color:#0000ff;font-family:Verdana"><span style="font-size:10pt;color:blue;font-family:Verdana"></span></span></p> <p class=MsoNormal><span style="font-size:x-small;color:#0000ff;font-family:Verdana"><span style="font-size:10pt;color:blue;font-family:Verdana"><br/>Trying database backup through temp file  SMS_SITE_BACKUP   1/7/2009 7:04:29 PM 11900 (0x2E7C)</span></span></p> <p class=MsoNormal><span style="font-size:x-small;color:#0000ff;font-family:Verdana"><span style="font-size:10pt;color:blue;font-family:Verdana">*** backup database SMS_HYD to DISK = 'F:\_SM128A.tmp' with INIT  SMS_SITE_BACKUP   1/7/2009 7:04:30 PM      11900 (0x2E7C)</span></span></p> <p class=MsoNormal><span style="font-size:x-small;color:#0000ff;font-family:Verdana"><span style="font-size:10pt;color:blue;font-family:Verdana">*** [42000][3201][Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open backup device 'F:\_SM128A.tmp'. Operating system error 5(Access is denied.).  SMS_SITE_BACKUP   1/7/2009 7:04:30 PM          11900 (0x2E7C)</span></span></p> <p class=MsoNormal><span style="font-size:x-small;color:#0000ff;font-family:Verdana"><span style="font-size:10pt;color:blue;font-family:Verdana">*** backup database SMS_HYD to DISK = 'F:\_SM128A.tmp' with INIT  SMS_SITE_BACKUP   1/7/2009 7:04:30 PM      11900 (0x2E7C)</span></span></p> <p class=MsoNormal><span style="font-size:x-small;color:#0000ff;font-family:Verdana"><span style="font-size:10pt;color:blue;font-family:Verdana">*** [42000][3013][Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP DATABASE is terminating abnormally.    SMS_SITE_BACKUP   1/7/2009 7:04:30 PM 11900 (0x2E7C)</span></span></p> <p class=MsoNormal><span style="font-size:x-small;color:#0000ff;font-family:Verdana"><span style="font-size:10pt;color:blue;font-family:Verdana">Failed to backup site database SMS_HYD up to E:\mssql\MSSQL\BACKUP\HYDBackup\SiteDBServer\SMSbkSQLDBsite.dat: ~Error executing SQL backup command.      SMS_SITE_BACKUP   1/7/2009 7:04:30 PM 11900 (0x2E7C) <br/><br/><br/>kindly let us know if any other changes need to done.<br/><br/>Thanks<br/></span></span></p><hr class="sig">Srikanth.klsWed, 11 Nov 2009 06:11:48 Z2009-11-17T10:55:24Zhttp://social.technet.microsoft.com/Forums/en-US/configmgrbackup/thread/ca2cac4f-798b-44d9-bef7-c474055b5adfhttp://social.technet.microsoft.com/Forums/en-US/configmgrbackup/thread/ca2cac4f-798b-44d9-bef7-c474055b5adfJT65http://social.technet.microsoft.com/Profile/en-US/?user=JT65Distribution Manager Isn't Distributing<p>I'm using the SCCM Site Repair Wizard to create a copy of my production environment in my lab, but I'm having a problem with&nbsp;Distribution Manager.&nbsp;<br /><br />I have 3 packages that have their source files on odd, one-off servers.&nbsp; I didn't bother to restore those in the lab, because they're not necessary for what I'm doing now.&nbsp;&nbsp; Currently Distribution Manager has fixated on one of these packages and keeps trying to distribute it, failing because the source files aren't there.&nbsp; I wouldn't care, but nothing else has been distributed to my distribution point.&nbsp;<br /><br />In the lab I have created a VM that is acting as my SMS Primary Site server/SQL Server (just like in production), and another to act as the source for 99% of my packages, and my distribution point.<br /><br />&nbsp;How can I get Distribution Manager to move on?&nbsp; I've deleted the package, but that didn't have any effect.<br /></p>Wed, 14 Oct 2009 21:09:06 Z2009-11-13T21:02:15Zhttp://social.technet.microsoft.com/Forums/en-US/configmgrbackup/thread/92f8fdf9-c215-417f-8b2f-7a32eb12ae06http://social.technet.microsoft.com/Forums/en-US/configmgrbackup/thread/92f8fdf9-c215-417f-8b2f-7a32eb12ae06Robert Spinellihttp://social.technet.microsoft.com/Profile/en-US/?user=Robert%20SpinelliDisaster Recover / High Availabity<p>Does anyone have any recommendation in regards to DR or HA for a primary?&nbsp; We have had 2 cases in the last few months in which drives went bad and primaries had to be restored from backup.&nbsp; It's a whole long story and if the region had the HW we suggested (Raid 10 vs Raid 5) it wouldn&rsquo;t have been as issue.&nbsp; Taking HW out of the equation what / is their a best way to recover from a primary failure that won' take hours?&nbsp; In the case of the last primary, it took us about&nbsp;8 hours to get back up and running: <br /><br />1) Install SQL - 30 mins <br />2) Install SCCM - 1 hour <br />3) Run site repair wizard.&nbsp; We noticed the amount of adverts will impact how long this step takes to fnish.&nbsp; We had around 8k adverts and the repair would do around 1500 adverts and hour (you can see this is smsprov.log while the restore is going) - 6 hrs <br /><br />The problem with the primary going down is that all of my secondaries below the primary (in this case 10) are also useless until the primary is restored.&nbsp; I think 8 hours is pretty good to get everything going again, but business doesn't agree. <br /><br />Business keeps pushing us to go to SAN, since all our primaries have direct attached storage, but we believe SAN will impact performance.&nbsp; Does anyone have any input on SAN ? <br /><br />Thank you. <br /><a href="http://www.myitforum.com/forums/Disaster_Recover_%2F_High_Availabity/m_208740/tm.htm"></a></p>Mon, 05 Oct 2009 18:46:41 Z2009-11-13T20:57:21Zhttp://social.technet.microsoft.com/Forums/en-US/configmgrbackup/thread/220af5b8-b06a-45d0-bff2-3b7da6c32ed0http://social.technet.microsoft.com/Forums/en-US/configmgrbackup/thread/220af5b8-b06a-45d0-bff2-3b7da6c32ed0brad_uoahttp://social.technet.microsoft.com/Profile/en-US/?user=brad_uoaMigrate Win2K3 x86 to Win2K8 x64We are wanting to upgrade our ConfigMgr Site Server from Win2K3 x86 to Win2K8 x64.<br/> <br/> Is there a supported path to doing this?  It seems that you need to install a new site and join the exiting site as a child... is this correct?Fri, 06 Nov 2009 03:39:51 Z2009-11-08T20:57:12Zhttp://social.technet.microsoft.com/Forums/en-US/configmgrbackup/thread/cada2c6f-34ac-4123-9844-d9c434e09740http://social.technet.microsoft.com/Forums/en-US/configmgrbackup/thread/cada2c6f-34ac-4123-9844-d9c434e09740Roger_1http://social.technet.microsoft.com/Profile/en-US/?user=Roger_1SCCM SITE RESET QUESTION<p>After reading site reset on technet online, <a href="http://technet.microsoft.com/en-us/library/bb633159.aspx">http://technet.microsoft.com/en-us/library/bb633159.aspx</a> I want to confirm something:<br/><br/>1. If perform site reset, will the package,or advertiment be missing?<br/><br/>2.  Will the site configuration be missing or back to original default setting?<br/><br/>3. What the impact after site reset? Will the security configuration be back to original?<br/><br/>Does anybody explain this process? <br/><br/>Thanks.</p>Sat, 07 Nov 2009 03:53:14 Z2009-11-16T03:53:38Zhttp://social.technet.microsoft.com/Forums/en-US/configmgrbackup/thread/fea25e93-9874-4b41-92bb-58e047cafeb6http://social.technet.microsoft.com/Forums/en-US/configmgrbackup/thread/fea25e93-9874-4b41-92bb-58e047cafeb6scjoyhttp://social.technet.microsoft.com/Profile/en-US/?user=scjoyCannot backup SCCM site getting error "Unable to find/start SQLWriter service". Nees Advice since I am not a SQL AdminLately, my SCCM 2007 site is not getting backed up anymore. The backup is supposed to run every Sunday but the last time it ran successfully was about two months ago. The backup log says, &quot; ERROR: SQL Backup task failed. Error message - Unable to find/start SQLWriter service. Cannot backup Sql database without this service.&quot; The SCCM database is on a remote SQL server that houses other databses. I do not have access to the SQL server as our SQL servers are managed by the SQL Admins (and they are very strict with access permissions and security). If the SQL Admin refuses to enable this service, is it possible to backup the SCCM site without backing up the database? The SQL Admins do back up on the databases on a regular basis so I they are gonna tell me not to do a database backup since they are already doing it.<br/><br/>We have SCCM1 SP1, 1 primary site, no child or secondary sites.Fri, 11 Sep 2009 17:54:16 Z2009-11-03T14:05:00Zhttp://social.technet.microsoft.com/Forums/en-US/configmgrbackup/thread/f19458b1-b42d-4cd8-95ac-1ecdef440e3fhttp://social.technet.microsoft.com/Forums/en-US/configmgrbackup/thread/f19458b1-b42d-4cd8-95ac-1ecdef440e3fMarshall123452003http://social.technet.microsoft.com/Profile/en-US/?user=Marshall123452003Unsafe removal of device error, when trying to backup in 2000 server...I'm using the windows 2000 server backup utility to save data to my WD external drive. When I schedule a backup, the backup never starts. I will get the error message that the drive has been removed and has not been shut down correctly. The drive hasn't been removed. It always sits in the closet with the server. If I do remove it, I do it correctly. When I look at the <span class=yshortcuts style="cursor:hand;border-bottom:#0066cc 1px dashed">event viewer</span>. I see the message: received a device interfacing removal notification for device...( the WD USB drive ). Then a few seconds later a arrival notification for the USB drive. This event occurs a few seconds after the backup is scheduled to start. Please help!Mon, 02 Nov 2009 18:45:36 Z2009-11-03T07:50:48Zhttp://social.technet.microsoft.com/Forums/en-US/configmgrbackup/thread/1b987c2d-9d24-4bd1-ac3e-1cf0be4ff54dhttp://social.technet.microsoft.com/Forums/en-US/configmgrbackup/thread/1b987c2d-9d24-4bd1-ac3e-1cf0be4ff54daaronfryehttp://social.technet.microsoft.com/Profile/en-US/?user=aaronfryeMove SCCM Site ServerI'd like to replace my existing site server with new hardware. Is there a procedure for this? We can keep the same computer name. In addition to being the site server, it's also a distribution point, management point, and reporting point. The database is on another host and I'm not planning on moving that. <br/><br/>I don't expect anybody to write up instructions for me but pointing me to a known good procedure would be great. Thanks!Tue, 27 Oct 2009 15:37:48 Z2009-11-13T21:03:12Zhttp://social.technet.microsoft.com/Forums/en-US/configmgrbackup/thread/6ab6cb8e-8744-4b3e-b635-514f8175ebc7http://social.technet.microsoft.com/Forums/en-US/configmgrbackup/thread/6ab6cb8e-8744-4b3e-b635-514f8175ebc7Dan.Dufushttp://social.technet.microsoft.com/Profile/en-US/?user=Dan.DufusSQL DB does not seem to be backing up..Hello all,<font face=Arial size=2></font> <div><span class=Apple-style-span style="white-space:normal"><br></span></div> <div><span class=Apple-style-span style="white-space:normal">I know theres numerous posts about various backup problems/configs but I couldn't find anything referencing my particular problem..</span></div> <div><span class=Apple-style-span style="white-space:normal"><br></span></div> <div><span class=Apple-style-span style="white-space:normal">I have my backup task scheduled to run daily.</span></div> <div><span class=Apple-style-span style="white-space:normal"><br></span></div> <div><span class=Apple-style-span style="white-space:normal">The sms part of it seems to back up fine, however when I check the directory on the SQL server there is only a single file called SQLBackupDocument.xml in there.</span></div> <div><span class=Apple-style-span style="white-space:normal"><br></span></div> <div><span class=Apple-style-span style="white-space:normal">I am trying to do a test restore of sms but am running into some problems and I think I need to get it to spit out the mdb when it does the backup. </span></div> <div><span class=Apple-style-span style="white-space:normal"><br></span></div> <div><span class=Apple-style-span style="white-space:normal">Also when I did the restore I ticked the 'do not restore db', restored, then restored a manual backup (*.bak) of the database into sql. This 'work' but when I load the console everything is empty, for example, under packages, all my folders are there, but no packages. No collections are present either..</span></div> <div><span class=Apple-style-span style="white-space:normal"><br></span></div> <div><span class=Apple-style-span style="white-space:normal">The backup says it runs successfully so I am at a loss as to where to poke around. </span></div> <div><span class=Apple-style-span style="white-space:normal"><br></span></div> <div><span class=Apple-style-span style="white-space:normal">Thankyou in advance,</span></div> <div><span class=Apple-style-span style="white-space:normal"><br></span></div> <div><span class=Apple-style-span style="white-space:normal">-Dan</span></div>Tue, 18 Nov 2008 01:21:19 Z2009-10-22T20:07:13Zhttp://social.technet.microsoft.com/Forums/en-US/configmgrbackup/thread/3edc3ee1-b14f-4c97-9c40-7090bbec8ed7http://social.technet.microsoft.com/Forums/en-US/configmgrbackup/thread/3edc3ee1-b14f-4c97-9c40-7090bbec8ed7Jepeto46http://social.technet.microsoft.com/Profile/en-US/?user=Jepeto46SCCM errorsThis is a re-install after the previous site was removed.<br /> the SCCM is running on a 64 bit machine, WSUs and SQL are on two separate machines. Teh install went without any errors, however we see a load of critical errors in the component status:<br /> SMS_CI_assignment _manager : SMS CI Assignment Manager failed to process CI Assignment changes. These changes will be retried on next processing cycle.<br /> SMS_collection_evaluator : SMS Collection Evaluator failed to process Collection Settings changes. These changes will be retried on next processing cycle.<br /> And list goes on.<br /> SMS_database_notification<br /> SMS_discovery_data_manager<br /> SMS_hierarchy_manager<br /> SMS_inventory-data_loader<br /> SMS_MP_control_manager<br /> SMS_object_replication_manager<br /> SMS_policy_provider<br /> SMS_software_metering_processor<br /> SMS_state-system<br /> SMS_WSUS_SYNC_manager<br /> SMS_SRs_reporting_point<br /> SMS_system_health_validator<br /> SMS_MP_decive_manager<br /> <br /> For many entries the severity level for&nbsp; the first few are information and the rest are errors. trying to apply hot fixes fails due to hardware platform error, so where would you start? this is a dedicated SCCM machine, so i was thinking, uninstall, wipe out, directory clean up and re-install from scratch. Or are those errors &quot;easy&quot; to fix.<br />Fri, 16 Oct 2009 20:54:26 Z2009-10-20T12:49:49Zhttp://social.technet.microsoft.com/Forums/en-US/configmgrbackup/thread/d9e4f304-d01e-4031-9bd0-daf0fda404aahttp://social.technet.microsoft.com/Forums/en-US/configmgrbackup/thread/d9e4f304-d01e-4031-9bd0-daf0fda404aadandydgmhttp://social.technet.microsoft.com/Profile/en-US/?user=dandydgmBackupI am trying to install backups made before I did system recovery. I receive message that backup is unavailabe. I am using an external hard drive for backup.Thu, 15 Oct 2009 16:52:36 Z2009-10-16T05:26:26Zhttp://social.technet.microsoft.com/Forums/en-US/configmgrbackup/thread/d25e45fd-2845-45a3-b27c-81ea9a9b0e96http://social.technet.microsoft.com/Forums/en-US/configmgrbackup/thread/d25e45fd-2845-45a3-b27c-81ea9a9b0e96JesMathttp://social.technet.microsoft.com/Profile/en-US/?user=JesMatUnble to backup Site System<p>Hi all,<br /><br />I configured the backup task to do a backup of SCCM but I got the following error:<br /><br /><em>SMS SQL Monitor could not start the SMS Backup service on server MTLSCCM1.</em></p> <p><em>Possible cause: You changed the service setting for the SMS Backup service, but forgot to notify SMS.<br />Solution: Use SMS Setup to modify the installation of the site.</em></p> <p><em>Possible cause: SMS SQL Monitor does not have sufficient access rights to administer the site server.<br />Solution: Verify that the server connection accounts are properly configured to allow the SMS SQL Monitor to administer the site server.<br /><br /></em>My Primary Site server and the SQL DB are on the same box.</p> <p>Does anybody have any thoughts?</p> <p>Thanks,</p> <p>JesMat</p>Fri, 02 Oct 2009 12:54:33 Z2009-10-15T13:41:08Zhttp://social.technet.microsoft.com/Forums/en-US/configmgrbackup/thread/3315a905-abd5-422f-b567-2f1e29b1a1d8http://social.technet.microsoft.com/Forums/en-US/configmgrbackup/thread/3315a905-abd5-422f-b567-2f1e29b1a1d8Saman Hamidihttp://social.technet.microsoft.com/Profile/en-US/?user=Saman%20HamidiReinstalling SCOM 2007 again on the same serverHello. We Need to configure a SCOM 2007 server, before that, want to remove anythings from AD Infrastructure? Is there force to uninstalling agents on servers whole on the network? is there some check marks for reinstalling SCOM 2007 on the network? last installation was not useful after a half-healthy SCOM server and after hours on troubleshoot, we decided to Build a New Server, but agents are on the servers still, not communicating with SCOM server. <br/> I'm wondering, I should erase things out there? or just build a new server and boom!<br/> It would be better name this thread, installing scom 2007 after reinstalling a corrupted SCOM Server.<br/> Thank you all.Wed, 05 Aug 2009 19:32:14 Z2009-10-15T05:14:22Zhttp://social.technet.microsoft.com/Forums/en-US/configmgrbackup/thread/301a3da2-e60f-45c7-918d-a7beb056e202http://social.technet.microsoft.com/Forums/en-US/configmgrbackup/thread/301a3da2-e60f-45c7-918d-a7beb056e202nateb4http://social.technet.microsoft.com/Profile/en-US/?user=nateb4Repair Site wizard fails to launch on Site Server Consoles SCCM 2007On two test site servers running SCCM 2007 with R2 update on both the <strong>&quot;Repair Site&quot;</strong> wizard fails to launch.<br/><br/>When I right-click and select repair site nothing happens.<br/><br/>The New Secondary site, Upgrade Secondary Site, Transfer Site Settings, and properties all work.<br/><br/>Just not the repair site.<br/><br/>This is happening on both the Central Site server and the child Primary site server.<br/><br/>This happens on both consoles.<br/><br/>Is there a log file for failed app launches?<br/><br/>Event Viewer does not show anything.<br/><br/>What gives?<br/><br/><strong>Screenshots here:</strong><br/><a href="http://picasaweb.google.com/BridgesCCS/SCCMScreenshots?feat=directlink">http://picasaweb.google.com/BridgesCCS/SCCMScreenshots?feat=directlink</a><br/>Fri, 17 Apr 2009 23:51:08 Z2009-11-12T02:01:20Zhttp://social.technet.microsoft.com/Forums/en-US/configmgrbackup/thread/835fbfcb-8ccd-4659-924e-6552ae0b574bhttp://social.technet.microsoft.com/Forums/en-US/configmgrbackup/thread/835fbfcb-8ccd-4659-924e-6552ae0b574bKenzonohttp://social.technet.microsoft.com/Profile/en-US/?user=KenzonoSCCM's SQL Database restore fails with "Could not connect or execute SQL query" error.Greetings,<br/> <br/> I have SQL Server 2008 working in conjunction with SCCM. Recently, I have had to redo my DC and since then I have not been able to access the SQL Management Studio. Everything else is just fine and has been resolved, SCCM along with DNS, DHCP, IIS, etc. It comes up with an error of access denied no matter what I did or what username I typed in whether it was with SQl Authentication or Windows Authentication, &quot;sa&quot; account or AD account. I know we had an account specificly created for SCCM with all permissions and full control. That same account was added to the SQL DB and made part of sysadmin group. Even though I was not able to access the Management Studio, SQL services were starting by using the custom made account and SCCM was working fine with no errors or warning for SQL.<br/> <br/> Since we need to access Management Studio and just the fact that access is denied, scares me. I therefore ended up reloading just the SQL Server and leaving SCCM alone how it was originally. The DB was named the same as it was before. After reloading it, I wanted to restore it through SCCM, since that is how it was backed up in the first place. I choose to run the ConfigMgr setup -&gt; Perform site maintenance or reset the Site -&gt; Modify SQL Server Configuration -&gt; Type in the SQL instance and the server where it resides SERVER\SQLDB and ConfigMgr Site Db, which is SMS_XXX. After this step, I get an error saying:<br/> <br/> &quot;Could not connect or execute SQL query. If the Site's database has been restored, verify if this machine account and the user account have local administrator privileges on the selected SQL Server&quot;<br/> <br/> I made sure that the account  that is trying to access the current database is in the database sysadmin group and part of the Domain admin group, who are also local admin on the server. Now, I am not sure if this error is coming from the old database that I am trying to recover and the since the SID is different in the DB from the SID in the AD, it does not allow access or is is trying to access the new database? Is there any other ways that I can restore my old SCCM database? As it is now, I cannot use SCCM since it is not connecting to its original DB? What can I do to get it working and get the DB in place for SCCM? Would I have to reload the SCCM completely?<br/> <br/> Thanks in advance,<br/> <br/> KenzoThu, 01 Oct 2009 16:07:23 Z2009-10-02T07:30:27Zhttp://social.technet.microsoft.com/Forums/en-US/configmgrbackup/thread/cb079512-774f-42b1-b4e4-aa154bb10084http://social.technet.microsoft.com/Forums/en-US/configmgrbackup/thread/cb079512-774f-42b1-b4e4-aa154bb10084Celgardhttp://social.technet.microsoft.com/Profile/en-US/?user=CelgardDPM 2007 setting up storage pools<p>I have just installed a new DPM 2007 server on a VM machine.  I  have made available 150gb of storage via virtual hd. My problem is when I try to add it within the storage pool. It shows capacity of 150gb and only 3mb free. But there is nothing instaledl on the disk. Can someone please explain why this is showing up like that through the storage pool and how I can resolve this issue. This the first DPM 2007 I have had my hands on so I am learning as I go here. Any and all hel pwould be greatly appreciated.<br/></p>Wed, 12 Aug 2009 19:56:58 Z2009-09-30T15:25:48Zhttp://social.technet.microsoft.com/Forums/en-US/configmgrbackup/thread/698e386c-cec5-487b-a722-6abcc2576213http://social.technet.microsoft.com/Forums/en-US/configmgrbackup/thread/698e386c-cec5-487b-a722-6abcc2576213TechLeehttp://social.technet.microsoft.com/Profile/en-US/?user=TechLeeChanging SQL Backup configuration after moving site database filesHi there,<br/><br/>I am using SCCM 2007 SP1.  I have moved my database files which were on the system partition of my remote database server to another partition on the same remote database server using the detach, move files then attach method.  My question is the the SMS_SITE_BACKUP task is still looking to the default location for the database files and obviously they are no longer there.<br/><br/>here is the log line showing that it is looking in the wrong place:<br/><br/>Site SQL Dir = <a>\\SCCMDB1\C$\PROGRAM</a> FILES\MICROSOFT SQL SERVER\MSSQL.1\MSSQL\.<br/><br/>Anyone know where abouts I can change this so it now points to the D: drive on that same server?<br/><br/>Thanks in advanceFri, 18 Sep 2009 20:33:20 Z2009-09-22T15:49:34Zhttp://social.technet.microsoft.com/Forums/en-US/configmgrbackup/thread/652d42c0-46ca-4121-9e06-819cbfcd07f0http://social.technet.microsoft.com/Forums/en-US/configmgrbackup/thread/652d42c0-46ca-4121-9e06-819cbfcd07f0Jc29http://social.technet.microsoft.com/Profile/en-US/?user=Jc29Best practice to perform backup&restore Secondary site? Hi,<br/><br/>SCCM R2 SP1 + SQL 2005 SP3 (same server)<br/>Secondary Site server roles: DP, WSUS+SUP, Proxy MP, FSP<br/><br/>I have many questions on the backup&amp;restore SS server:<br/><br/>1) Which folders need backup on Secondary Site (SS) server (SMSPKGD$, SMSPKGSIG, SMSSIG$ .....)?<br/><br/>2) How they must then correctly backup&amp;restore? (permissions, share)<br/><br/>3) Who worked with PreloadPkgOnSite, for a package you can use one time?<br/>(last paragraph: <a href="http://blogs.technet.com/configurationmgr/archive/2009/05/07/configmgr-2007-the-preload-package-tool-preloadpkgonsite-exe-explained.aspx">http://blogs.technet.com/configurationmgr/archive/2009/05/07/configmgr-2007-the-preload-package-tool-preloadpkgonsite-exe-explained.aspx</a>)<br/><br/>4) What is <strong>pck</strong>-files and Is it possible to initiate the creation of these pck-files some utility ?<br/>I do not have these pck-files, but there are pkg-files.<br/><br/>Thx.<hr class="sig">MCSEFri, 18 Sep 2009 12:28:08 Z2009-09-21T06:43:57Zhttp://social.technet.microsoft.com/Forums/en-US/configmgrbackup/thread/331493dd-190e-40ee-83b2-d2dd329803b8http://social.technet.microsoft.com/Forums/en-US/configmgrbackup/thread/331493dd-190e-40ee-83b2-d2dd329803b8ssssstewhttp://social.technet.microsoft.com/Profile/en-US/?user=ssssstewSMS_SITE_BACKUP component error every hour although set to run weeklyIve set the SCCM Site backup task to run on sunday between 3:30am and 4:30am but in the logs (which SCOM is reporting on for me) i have a hourly event showing the SMS_SITE_BACKUP failed :-<br/><br/>A new monitored SMS status message on machine BACVSSCCM01 from component SMS_SITE_BACKUP with message ID 5049 was found in the site BNE database.<br/><br/>Does anyone know why this is coming up hourly when its not set to run that way?Wed, 16 Sep 2009 05:35:27 Z2009-10-05T03:01:40Zhttp://social.technet.microsoft.com/Forums/en-US/configmgrbackup/thread/b513f84b-a377-4f8f-819a-19ec1bdd96aahttp://social.technet.microsoft.com/Forums/en-US/configmgrbackup/thread/b513f84b-a377-4f8f-819a-19ec1bdd96aassssstewhttp://social.technet.microsoft.com/Profile/en-US/?user=ssssstewSCCM Backup - packages covered?Hi All<br/><br/>Ive got the SCCM backup task scheduled but its not run yet, want to ask a quick question, does this also backup all of our packages?  or do i need to ensure this is covered in our regualr file backup?<br/><br/>Cheers<br/><br/>StewartTue, 08 Sep 2009 05:11:55 Z2009-09-16T05:22:54Zhttp://social.technet.microsoft.com/Forums/en-US/configmgrbackup/thread/41217d57-0297-45ad-9340-ef29658cbcbfhttp://social.technet.microsoft.com/Forums/en-US/configmgrbackup/thread/41217d57-0297-45ad-9340-ef29658cbcbfkm32http://social.technet.microsoft.com/Profile/en-US/?user=km32Site Repair Wizard on a SCCM SecondaryI am replacing our SCCM 2007 SP1 secondary sites with new hardware and Windows 2008 64 bit. <br/> I  have made a backup of the secondary. Shutdown the old server removed it from AD.  <br/> Added the new server to AD with the same server name.  <br/> Installed SCCM with the exact site names/information.  <br/> I then install the SCCM console on the secondary in order to use ConfigMgr Site Recovery Wizard.  <br/> <br/> This is where the problem is.  The Wizard stops with the following error: &quot;SCCM - Recoverywizard has stopped working&quot;<br/> <br/> It places this in the application event log<br/> <br/> Fault bucket 253032840, type 5<br/> Event Name: CLR20r3<br/> Response: None<br/> Cab Id: 0<br/> <br/> Problem signature:<br/> P1: repairwizard.exe<br/> P2: 4.0.6221.1000<br/> P3: 48339214<br/> P4: RepairWizard<br/> P5: 4.0.6000.0<br/> P6: 48339214<br/> P7: 47a<br/> P8: a1<br/> P9: System.NullReferenceException<br/> P10: <br/> <br/> Attached files:<br/> C:\Users\*****\AppData\Local\Temp\2\WERAA72.tmp.version.txt<br/> <br/> These files may be available here:<br/> C:\Users\*****\AppData\Local\Microsoft\Windows\WER\ReportArchive\Report13ecbb15<br/> <br/> These files have no more information other than it stopped working.<br/> <br/> The process worked perfectly on the Primaries.<br/> <br/> I have many secondaries to replace and a short time to do so. <br/> <br/> Any thoughts on how to get the repairwizard to run on the secondaries?<br/>Thu, 28 May 2009 19:30:46 Z2009-09-11T13:07:15Zhttp://social.technet.microsoft.com/Forums/en-US/configmgrbackup/thread/5bfcdd4a-f56f-4ff1-bd48-b3a3b2d189ddhttp://social.technet.microsoft.com/Forums/en-US/configmgrbackup/thread/5bfcdd4a-f56f-4ff1-bd48-b3a3b2d189ddscotty25tqhttp://social.technet.microsoft.com/Profile/en-US/?user=scotty25tqPnP problem code: 00000013<span style="font-size:xx-small"> <p>Problem Event Name: PnPDeviceProblemCode</p> <p>Architecture: x86</p> <p>Hardware Id: IDE\CdRomTSSTcorp_CDDVDW_TS-L633A________________TO01____</p> <p>Setup class GUID: {4d36e965-e325-11ce-bfc1-08002be10318}</p> <p>PnP problem code: 00000013</p> <p>Driver name: cdrom.sys</p> <p>Driver version: 6.0.6002.18005</p> <p>Driver date: 04-11-2009</p> <p>OS Version: 6.0.6002.2.2.0.768.3</p> <p>Locale ID: 2057</p> </span>Wed, 09 Sep 2009 23:27:26 Z2009-09-10T07:40:16Zhttp://social.technet.microsoft.com/Forums/en-US/configmgrbackup/thread/93ffc629-8c7e-45c8-bc5a-278040d1630ahttp://social.technet.microsoft.com/Forums/en-US/configmgrbackup/thread/93ffc629-8c7e-45c8-bc5a-278040d1630aJLPucheuhttp://social.technet.microsoft.com/Profile/en-US/?user=JLPucheuRestoring Records for Inadvertently Deleted Users<p>A colleagues accidentally deleted a few user records from within the SCCM console, and after searching for a while, I'm unable to find how to get those users back in the database, and back in the All Users collection. I'm using AD User Discovery. If I simply force discovery to be run now, will those users reappear in the database after discovery has completed, or is the solution much more complicated than that? Thanks in advance! </p>Wed, 09 Sep 2009 16:13:03 Z2009-09-09T20:49:17Zhttp://social.technet.microsoft.com/Forums/en-US/configmgrbackup/thread/672e2b01-8755-423c-a731-a25b507a2ca2http://social.technet.microsoft.com/Forums/en-US/configmgrbackup/thread/672e2b01-8755-423c-a731-a25b507a2ca2yannarahttp://social.technet.microsoft.com/Profile/en-US/?user=yannaraSMS 2003 gets "broken" every timeI'm running my lab test enviroment on VMware ESXi 4.0. I had this situation twice. When I install and configure SMS2003 server, everything works fine at first. I might restart the SMS server several times, and everything is fine. Then I shut down everything for the night (everything, I mean SMS, DC, VMware). At the morning SMS console won't expand any collections, queries or any other objects. I can't even get inside site status.<br/><br/>Is it like stone written rule, that SMS can't be used as virtual machine?<br/><br/>ps. sorry if I wrote this in a wrong forum directoryThu, 03 Sep 2009 07:17:12 Z2009-10-26T18:47:22Zhttp://social.technet.microsoft.com/Forums/en-US/configmgrbackup/thread/00083dab-a435-4b40-af95-c42fe09fc94ahttp://social.technet.microsoft.com/Forums/en-US/configmgrbackup/thread/00083dab-a435-4b40-af95-c42fe09fc94aPatgdubehttp://social.technet.microsoft.com/Profile/en-US/?user=PatgdubeBest recovery strategy when hosting SCCM 2007 and the site database on the same virtual machineHi,<br/><br/>we have a virtual machine running SCCM 2007 R2 as a primary site with SQL 2005 SP3.<br/><br/>The SCCM database is located on the same server and SQL is dedicated to SCCM.<br/><br/>The virtual machine also owns the Management Point, Reporting Point and Distribution Point roles. The remaining roles we configured;  Software Update Point, State Migration Point and PXE Service Point are located on other servers.<br/><br/>The primary (and central) site is on top of a hierarchy consisting of 3 secondary sites under it.<br/><br/>We run a SCCM Backup task on a daily basis and moreover, a snapshot of the virtual machine is done everyday.<br/><br/>Let say we have to restore SCCM and the latest snapshot of the virtual machine is more recent than the SCCM backup, which way it should be restored:<br/><br/>1. Using the Site Repair Wizard with the latest SCCM backup, even if it is older than the virtual server snapshot.<br/><br/>2. Using the Site Repair Wizard, but without the SCCM backup, instead, we select the <strong>Repair or reconfigure a site</strong> option and then, when asked for the backup date, we enter the date the virtual server snapshot was taken.<br/><br/>Tnx for your help<br/><br/>PatFri, 28 Aug 2009 19:11:47 Z2009-08-31T14:49:21Zhttp://social.technet.microsoft.com/Forums/en-US/configmgrbackup/thread/fd70682c-b1be-4ad1-8b51-e0f4630e8526http://social.technet.microsoft.com/Forums/en-US/configmgrbackup/thread/fd70682c-b1be-4ad1-8b51-e0f4630e8526Tim Millerhttp://social.technet.microsoft.com/Profile/en-US/?user=Tim%20MillerError communicating with (remote) SMS_SITE_SQL_BACKUP componentI have an SCCM SP1 site server with a remote SQL server running SQL 2005 SP2 that houses the site database.  The site server's computer account is a local admin on the SQL server.  The components installed successfully, but when I query the SMS_SITE_SQL_BACKUP component that resides on the SQL server, I get the error &quot;Error communicating with component&quot;.  I verified the service is running on the SQL server under LocalSystem.<br><br>When running the ConfigMgr backup maintenance task, the site backs up successfully, but it can't backup the database (due to the above).<br><br>Any ideas?<br><br>Mon, 18 Aug 2008 19:20:14 Z2009-08-28T13:29:02Zhttp://social.technet.microsoft.com/Forums/en-US/configmgrbackup/thread/7a557800-7309-40aa-a12b-b6fd5d25528fhttp://social.technet.microsoft.com/Forums/en-US/configmgrbackup/thread/7a557800-7309-40aa-a12b-b6fd5d25528fsantosplhttp://social.technet.microsoft.com/Profile/en-US/?user=santosplSMS_SITE_SQL_BACKUP component failed to reinstallHi,<br/> <br/> I have a problem with SMS_SITE_SQL_BACKUP component on my SCCM SQL server. The SQL server is running on Windows Server 2003 x64 SP2 and site is in Native mode running SCCM SP1 R2 on Windows Server 2003 SP2 (separate servers)<br/> I've enabled a Backup ConfigMgr Site Server maintance task 2 weeks ago and since then site backup was running fine.<br/> Few days ago I've noticed that SMS_SITE_SQL_BACKUP component start to log following errors:<br/> <br/> &quot;SMS Site Component Manager failed to reinstall this component on this site system.<br/> <br/> Solution: Review the previous status messages to determine the exact reason for the failure. SMS Site Component Manager will automatically retry the reinstallation in 60 minutes. To force SMS Site Component Manager to immediately retry the reinstallation, stop and restart SMS Site Component Manager using the SMS Service Manager.&quot;<br/> <br/> Information in 'sitecomp.log'<br/> <br/>     &quot;Reinstalling component SMS_SITE_SQL_BACKUP...    SMS_SITE_COMPONENT_MANAGER    26/06/2009 15:56:08    2204 (0x089C)<br/> STATMSG: ID=1018 SEV=I LEV=M SOURCE=&quot;SMS Server&quot; COMP=&quot;SMS_SITE_SQL_BACKUP_SiteName&quot; SYS=SiteName SITE=SiteCode PID=1808 TID=2204 GMTDATE=Fri Jun 26 14:56:08.956 2009 ISTR0=&quot;&quot; ISTR1=&quot;&quot; ISTR2=&quot;&quot; ISTR3=&quot;&quot; ISTR4=&quot;&quot; ISTR5=&quot;&quot; ISTR6=&quot;&quot; ISTR7=&quot;&quot; ISTR8=&quot;&quot; ISTR9=&quot;&quot; NUMATTRS=0    SMS_SITE_COMPONENT_MANAGER    26/06/2009 15:56:08    2204 (0x089C)<br/>       Starting bootstrap operations...    SMS_SITE_COMPONENT_MANAGER    26/06/2009 15:56:09    2204 (0x089C)<br/>         Component file list item in the install map for component SMS_SITE_SQL_BACKUP does not contain srvboot.exe.    SMS_SITE_COMPONENT_MANAGER    26/06/2009 15:56:09    2204 (0x089C)<br/>       Bootstrap operations aborted.    SMS_SITE_COMPONENT_MANAGER    26/06/2009 15:56:09    2204 (0x089C)<br/> LogEvent(): Successfully logged Event to NT Event Log (4, 77, 1073742842, (null)).    SMS_SITE_COMPONENT_MANAGER    26/06/2009 15:56:09    2204 (0x089C)<br/>       The server already contains some of the required files for this component.  A disk space check will not be made.    SMS_SITE_COMPONENT_MANAGER    26/06/2009 15:56:09    2204 (0x089C)<br/>       Installed file \\SiteName\E$\SMS_SiteName\bin\x64\smssqlbkup.exe.    SMS_SITE_COMPONENT_MANAGER    26/06/2009 15:56:09    2204 (0x089C)<br/>       All files installed.    SMS_SITE_COMPONENT_MANAGER    26/06/2009 15:56:09    2204 (0x089C)<br/>       Starting bootstrap operations...    SMS_SITE_COMPONENT_MANAGER    26/06/2009 15:56:09    2204 (0x089C)<br/>         Component file list item in the install map for component SMS_SITE_SQL_BACKUP does not contain srvboot.exe.    SMS_SITE_COMPONENT_MANAGER    26/06/2009 15:56:09    2204 (0x089C)<br/>       Bootstrap operations aborted.    SMS_SITE_COMPONENT_MANAGER    26/06/2009 15:56:09    2204 (0x089C)<br/>     Reinstallation failed and will be retried in the next polling cycle.    SMS_SITE_COMPONENT_MANAGER    26/06/2009 15:56:09    2204 (0x089C)<br/> LogEvent(): Successfully logged Event to NT Event Log (1, 77, -1073740804, (null)).    SMS_SITE_COMPONENT_MANAGER    26/06/2009 15:56:09    2204 (0x089C)&quot;<br/> <br/> Information in 'Application' log on SQL server:<br/> &quot;14:56:08, component SMS_SITE_COMPONENT_MANAGER on computer ServerName reported:  , HRESULT=0x00000000.&quot;<br/> &quot;14:56:08, component SMS_SITE_COMPONENT_MANAGER on computer ServerName reported:  , 60.&quot;<br/> <br/> I've rechecked all the permissions and they're OK. Site server computer account is a local admin on the sql box (SQL and main SCCM server are separate servers). All other SCCM components are working fine.<br/> When I tried to query this component I'm getting error: Error communicating with component I've applied patch specified here: http://support.microsoft.com/default.aspx/kb/957879 but it didn't resolve this issue.<br/> <br/> Is there something I'm missing ? Is there any other log to be checked ?<br/> <br/> Any help AppreciateTue, 30 Jun 2009 12:27:03 Z2009-08-28T13:10:52Zhttp://social.technet.microsoft.com/Forums/en-US/configmgrbackup/thread/5fd70bb7-0062-4696-a76d-01bb22d3f53fhttp://social.technet.microsoft.com/Forums/en-US/configmgrbackup/thread/5fd70bb7-0062-4696-a76d-01bb22d3f53fRobert Spinellihttp://social.technet.microsoft.com/Profile/en-US/?user=Robert%20SpinelliExclude directories to backup / DB backup size<p>I have 2 questions:<br/><br/>In SMS 2003 you were able to exclude certain directories that you didn't want to backup (ex: offersum.box) using the smsbkup.ctl file.  Can you do the same thing in SCCM ?  My assumption is no because of the way it does a snapshot using VSS.<br/><br/>SMS 2003 if your DB was 200GB's but the file only had 100GB's worth of data in it, the .dat file was 100GB's.  If you have the same scenario in SCCM even though there is only 100GB of data the backup is 200GB's.  SCCM doesn't create a .dat file anymore using SQL backup, it looks like it uses VSS and backs up the actual .mdf and .ldf, so my assumption to this is that I'm out of luck and my backup will be 200GB's.<br/><br/>I do like the fact that VSS allows the SMS Executive to kick right back off, but it also seems to have alot of shortcomings if my assumptions above are correct.</p>Wed, 12 Aug 2009 21:47:58 Z2009-08-28T01:40:09Zhttp://social.technet.microsoft.com/Forums/en-US/configmgrbackup/thread/b54bc706-3ec7-410c-b8b8-2dd7b0bbcfdbhttp://social.technet.microsoft.com/Forums/en-US/configmgrbackup/thread/b54bc706-3ec7-410c-b8b8-2dd7b0bbcfdbChandramutyalahttp://social.technet.microsoft.com/Profile/en-US/?user=ChandramutyalaDPM 2007 Protected data location change issue<span style="font-size:x-small;font-family:Trebuchet MS"><span style="font-size:x-small;font-family:Trebuchet MS"><font face="Trebuchet MS" size=2><font face="Trebuchet MS" size=2> <p dir=ltr>Need your support in DPM server issue. Please find the complete details.</p> </font></font></span><font face="Trebuchet MS" size=2> <p dir=ltr> </p> </font></span> <p dir=ltr><span style="font-family:Times New Roman"><span style="font-size:small"> </span></span></p> <span style="font-size:x-small;font-family:Trebuchet MS"><span style="font-size:x-small;font-family:Trebuchet MS"><font face="Trebuchet MS" size=2><font face="Trebuchet MS" size=2> <p dir=ltr>We have a DPM server and protected 2 TB of file server data. It was running fine so far.</p> </font></font></span><font face="Trebuchet MS" size=2> <p dir=ltr> </p> </font></span> <p dir=ltr><span style="font-family:Times New Roman"><span style="font-size:small"> </span></span></p> <span style="font-size:x-small;font-family:Trebuchet MS"><span style="font-size:x-small;font-family:Trebuchet MS"><font face="Trebuchet MS" size=2><font face="Trebuchet MS" size=2> <p dir=ltr>Recently we have changed the location of the data (Cluster Group Name Changed) hence we required to add the changes also in the DPM server for that protected data.</p> </font></font></span><font face="Trebuchet MS" size=2> <p dir=ltr> </p> </font></span> <p dir=ltr><span style="font-family:Times New Roman"><span style="font-size:small"> </span></span></p> <span style="font-size:x-small;font-family:Trebuchet MS"><span style="font-size:x-small;font-family:Trebuchet MS"><font face="Trebuchet MS" size=2><font face="Trebuchet MS" size=2> <p dir=ltr>Please let us know the procedure to add the changes without loosing the old recovery points.</p> </font></font></span><font face="Trebuchet MS" size=2> <p dir=ltr> </p> </font></span> <p dir=ltr><span style="font-family:Times New Roman"><span style="font-size:small"> </span></span></p>Mon, 24 Aug 2009 14:26:22 Z2009-08-27T19:09:21Zhttp://social.technet.microsoft.com/Forums/en-US/configmgrbackup/thread/e4e76e47-0408-4dc9-9879-aa6376c825ebhttp://social.technet.microsoft.com/Forums/en-US/configmgrbackup/thread/e4e76e47-0408-4dc9-9879-aa6376c825ebDougCChttp://social.technet.microsoft.com/Profile/en-US/?user=DougCCRecovery Point Threshold Hello,<br/><br/>One of my protection groups is backing up a backup domain controller system state.  All of a sudden starting this week, I am getting a Recovery Point Threshold exceeded message.  I have modified the disk space to over 20 additional gigs this past week.  The wierd thing is that BDC drive is not getting bigger.  The total size of the drive is only 39 gigs with over 12 gigs free.   Right now the recovery point volume on the DPM is set for 99.64 gigs.  My issue is that I need to be very careful on drive space since my SAN is for now limited on space.  Does anyone have suggestions on what could be taking up all the room on the recovery point volume, it does not make sense that all of sudden I am running out of space on the recovery point.<br/><br/>TIA.<br/>DCWed, 26 Aug 2009 20:00:42 Z2009-08-27T19:20:52Zhttp://social.technet.microsoft.com/Forums/en-US/configmgrbackup/thread/bb15f20f-de3b-4d9c-8c48-30a7f565e1fahttp://social.technet.microsoft.com/Forums/en-US/configmgrbackup/thread/bb15f20f-de3b-4d9c-8c48-30a7f565e1faJamesAveryhttp://social.technet.microsoft.com/Profile/en-US/?user=JamesAveryUnable to backup SCCM with SCCM SP1 R2 and SQL 2008 all on Server 2008 with SP2.<br/>I have two servers.<br/>Server 1<br/>    Server 2008 with SP2    <br/>    SCCM 2007 with SP1 and R2<br/>    SCCM Updates Applied, KB956578, KB961105, KB969113, KB969529, KB970093<br/><br/>Server 2<br/>    Server 2008 with SP2<br/>    SQL 2008 (all patches applied)<br/><br/><br/><strong><span style="text-decoration:underline">I receive this message from my SMSBKUP.LOG</span></strong><br/><br/>Initializing the status message reporting system... SMS_SITE_BACKUP 8/24/2009 6:10:14 PM 7828 (0x1E94)<br/>    The path to the &quot;Status Manager&quot; inbox is &quot;D:\Program Files (x86)\Microsoft Configuration Manager\inboxes\statmgr.box\statmsgs&quot;. SMS_SITE_BACKUP 8/24/2009 6:10:14 PM 7828 (0x1E94)<br/>    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 8/24/2009 6:10:14 PM 7828 (0x1E94)<br/>Registered this process as a source of &quot;SMS Server&quot; events. SMS_SITE_BACKUP 8/24/2009 6:10:14 PM 7828 (0x1E94)<br/>Registered this process as a source of &quot;SMS Client&quot; events. SMS_SITE_BACKUP 8/24/2009 6:10:14 PM 7828 (0x1E94)<br/>Registered this process as a source of &quot;SMS Provider&quot; events. SMS_SITE_BACKUP 8/24/2009 6:10:14 PM 7828 (0x1E94)<br/>Status message reporting system initialized successfully. SMS_SITE_BACKUP 8/24/2009 6:10:14 PM 7828 (0x1E94)<br/>Locale set to OS value (English_United States.1252). SMS_SITE_BACKUP 8/24/2009 6:10:14 PM 7828 (0x1E94)<br/>SMS site backup service 4.00 started. SMS_SITE_BACKUP 8/24/2009 6:10:14 PM 7828 (0x1E94)<br/>STATMSG: ID=500 SEV=I LEV=M SOURCE=&quot;SMS Server&quot; COMP=&quot;SMS_SITE_BACKUP&quot; SYS=SCCM01 SITE=PC2 PID=10064 TID=7828 GMTDATE=Mon Aug 24 23:10:14.737 2009 ISTR0=&quot;SMS site backup&quot; ISTR1=&quot;&quot; ISTR2=&quot;&quot; ISTR3=&quot;&quot; ISTR4=&quot;&quot; ISTR5=&quot;&quot; ISTR6=&quot;&quot; ISTR7=&quot;&quot; ISTR8=&quot;&quot; ISTR9=&quot;&quot; NUMATTRS=0 SMS_SITE_BACKUP 8/24/2009 6:10:14 PM 7828 (0x1E94)<br/>08/24/09 18:10:14 - starting backup. SMS_SITE_BACKUP 8/24/2009 6:10:14 PM 7828 (0x1E94)<br/>BackupDir = E:\CONFIGMGRBACKUP. SMS_SITE_BACKUP 8/24/2009 6:10:15 PM 7828 (0x1E94)<br/>Installation RootDir = D:\PROGRAM FILES (X86)\MICROSOFT CONFIGURATION MANAGER. SMS_SITE_BACKUP 8/24/2009 6:10:15 PM 7828 (0x1E94)<br/>Site SQL Dir = <a>\\SQL02\C$\PROGRAM</a> FILES\MICROSOFT SQL SERVER\MSSQL10.MSSQLSERVER\MSSQL\. SMS_SITE_BACKUP 8/24/2009 6:10:15 PM 7828 (0x1E94)<br/>Site Backup Location = <a>\\sccm01\configmgrbackup</a> SMS_SITE_BACKUP 8/24/2009 6:10:15 PM 7828 (0x1E94)<br/>SQL Backup Location = <a>\\sccm01\configmgrbackup</a> SMS_SITE_BACKUP 8/24/2009 6:10:15 PM 7828 (0x1E94)<br/>STATMSG: ID=5055 SEV=I LEV=M SOURCE=&quot;SMS Server&quot; COMP=&quot;SMS_SITE_BACKUP&quot; SYS=SCCM01 SITE=PC2 PID=10064 TID=7828 GMTDATE=Mon Aug 24 23:10:15.284 2009 ISTR0=&quot;&quot; ISTR1=&quot;&quot; ISTR2=&quot;&quot; ISTR3=&quot;&quot; ISTR4=&quot;&quot; ISTR5=&quot;&quot; ISTR6=&quot;&quot; ISTR7=&quot;&quot; ISTR8=&quot;&quot; ISTR9=&quot;&quot; NUMATTRS=0 SMS_SITE_BACKUP 8/24/2009 6:10:15 PM 7828 (0x1E94)<br/>LogEvent(): Successfully logged Event to NT Event Log. (4 - 48 - 1,073,746,879) SMS_SITE_BACKUP 8/24/2009 6:10:15 PM 7828 (0x1E94)<br/>Starting VSS initialization... SMS_SITE_BACKUP 8/24/2009 6:10:15 PM 7828 (0x1E94)<br/>Starting Asynchronous GatherWriterMetadata. SMS_SITE_BACKUP 8/24/2009 6:10:15 PM 7828 (0x1E94)<br/>Number of writers that responded: 10. SMS_SITE_BACKUP 8/24/2009 6:10:18 PM 7828 (0x1E94)<br/>Reading SMS Writer metadata... SMS_SITE_BACKUP 8/24/2009 6:10:19 PM 7828 (0x1E94)<br/>Number of FileIncludes: 0. SMS_SITE_BACKUP 8/24/2009 6:10:19 PM 7828 (0x1E94)<br/>Number of FileExcludes: 0. SMS_SITE_BACKUP 8/24/2009 6:10:19 PM 7828 (0x1E94)<br/>Number of Components: 7. SMS_SITE_BACKUP 8/24/2009 6:10:19 PM 7828 (0x1E94)<br/>Component 0 - PC2Backup\SiteServer\SMSServer\inboxes. SMS_SITE_BACKUP 8/24/2009 6:10:19 PM 7828 (0x1E94)<br/>FileGroupFile = D:\PROGRAM FILES (X86)\MICROSOFT CONFIGURATION MANAGER\INBOXES\* [Recursive: yes] SMS_SITE_BACKUP 8/24/2009 6:10:19 PM 7828 (0x1E94)<br/>Volume D:\ (that contains the file(s)) is marked as a candidate for snapshot. SMS_SITE_BACKUP 8/24/2009 6:10:19 PM 7828 (0x1E94)<br/>Component 1 - PC2Backup\SiteServer\SMSServer\Logs. SMS_SITE_BACKUP 8/24/2009 6:10:19 PM 7828 (0x1E94)<br/>FileGroupFile = D:\PROGRAM FILES (X86)\MICROSOFT CONFIGURATION MANAGER\LOGS\* [Recursive: yes] SMS_SITE_BACKUP 8/24/2009 6:10:19 PM 7828 (0x1E94)<br/>Volume D:\ (that contains the file(s)) is marked as a candidate for snapshot. SMS_SITE_BACKUP 8/24/2009 6:10:19 PM 7828 (0x1E94)<br/>Component 2 - PC2Backup\SiteServer\SMSServer\data. SMS_SITE_BACKUP 8/24/2009 6:10:19 PM 7828 (0x1E94)<br/>FileGroupFile = D:\PROGRAM FILES (X86)\MICROSOFT CONFIGURATION MANAGER\DATA\* [Recursive: yes] SMS_SITE_BACKUP 8/24/2009 6:10:19 PM 7828 (0x1E94)<br/>Volume D:\ (that contains the file(s)) is marked as a candidate for snapshot. SMS_SITE_BACKUP 8/24/2009 6:10:19 PM 7828 (0x1E94)<br/>Component 3 - PC2Backup\SiteServer\SMSServer\srvacct. SMS_SITE_BACKUP 8/24/2009 6:10:19 PM 7828 (0x1E94)<br/>FileGroupFile = D:\PROGRAM FILES (X86)\MICROSOFT CONFIGURATION MANAGER\SRVACCT\* [Recursive: yes] SMS_SITE_BACKUP 8/24/2009 6:10:19 PM 7828 (0x1E94)<br/>Volume D:\ (that contains the file(s)) is marked as a candidate for snapshot. SMS_SITE_BACKUP 8/24/2009 6:10:19 PM 7828 (0x1E94)<br/>Component 4 - PC2Backup\SiteServer\SMSbkSiteRegNAL.dat. SMS_SITE_BACKUP 8/24/2009 6:10:19 PM 7828 (0x1E94)<br/>FileGroupFile = D:\Program Files (x86)\Microsoft Configuration Manager\BackupTemp\SMSbkSiteRegNAL.dat [Recursive: no] SMS_SITE_BACKUP 8/24/2009 6:10:19 PM 7828 (0x1E94)<br/>Volume D:\ (that contains the file(s)) is marked as a candidate for snapshot. SMS_SITE_BACKUP 8/24/2009 6:10:19 PM 7828 (0x1E94)<br/>Component 5 - PC2Backup\SiteServer\SMSbkSiteRegSMS.dat. SMS_SITE_BACKUP 8/24/2009 6:10:19 PM 7828 (0x1E94)<br/>FileGroupFile = D:\Program Files (x86)\Microsoft Configuration Manager\BackupTemp\SMSbkSiteRegSMS.dat [Recursive: no] SMS_SITE_BACKUP 8/24/2009 6:10:19 PM 7828 (0x1E94)<br/>Volume D:\ (that contains the file(s)) is marked as a candidate for snapshot. SMS_SITE_BACKUP 8/24/2009 6:10:19 PM 7828 (0x1E94)<br/>Component 6 - PC2Backup\SiteDBServer\SMSbkSQLDBsite.dat. SMS_SITE_BACKUP 8/24/2009 6:10:19 PM 7828 (0x1E94)<br/>Dependency On SQL Writer , LogicalPath:\\SQL02, ComponentName:SCCM_PC2 SMS_SITE_BACKUP 8/24/2009 6:10:19 PM 7828 (0x1E94)<br/>After GatherWriterMetadata SMS Writer status = FAILED_AT_PREPARE_BACKUP. SMS_SITE_BACKUP 8/24/2009 6:10:19 PM 7828 (0x1E94)<br/>Starting to clean and prepare the backup location. SMS_SITE_BACKUP 8/24/2009 6:10:19 PM 7828 (0x1E94)<br/>Cleanup and/or preparation done. SMS_SITE_BACKUP 8/24/2009 6:10:19 PM 7828 (0x1E94)<br/>Info: Sending message to start the SQL Backup... SMS_SITE_BACKUP 8/24/2009 6:10:19 PM 7828 (0x1E94)<br/>Starting to create the snapshot set. SMS_SITE_BACKUP 8/24/2009 6:10:19 PM 7828 (0x1E94)<br/>Added volume containing D:\ to the snapshot set. SMS_SITE_BACKUP 8/24/2009 6:10:19 PM 7828 (0x1E94)<br/>Info: Starting Asynchronous PrepareForBackup... SMS_SITE_BACKUP 8/24/2009 6:10:19 PM 7828 (0x1E94)<br/>Info: Asynchronous PrepareForBackup finished... SMS_SITE_BACKUP 8/24/2009 6:10:20 PM 7828 (0x1E94)<br/>Info: Waiting for SQL to PrepareForBackup. SMS_SITE_BACKUP 8/24/2009 6:10:20 PM 7828 (0x1E94)<br/>Sleeping for 5 seconds... SMS_SITE_BACKUP 8/24/2009 6:10:20 PM 7828 (0x1E94)<br/>Sleeping for 5 seconds... SMS_SITE_BACKUP 8/24/2009 6:10:25 PM 7828 (0x1E94)<br/>Sleeping for 5 seconds... SMS_SITE_BACKUP 8/24/2009 6:10:30 PM 7828 (0x1E94)<br/>Sleeping for 5 seconds... SMS_SITE_BACKUP 8/24/2009 6:10:35 PM 7828 (0x1E94)<br/>Sleeping for 5 seconds... SMS_SITE_BACKUP 8/24/2009 6:10:40 PM 7828 (0x1E94)<br/>Sleeping for 5 seconds... SMS_SITE_BACKUP 8/24/2009 6:10:45 PM 7828 (0x1E94)<br/>Sleeping for 5 seconds... SMS_SITE_BACKUP 8/24/2009 6:10:50 PM 7828 (0x1E94)<br/>Sleeping for 5 seconds... SMS_SITE_BACKUP 8/24/2009 6:10:55 PM 7828 (0x1E94)<br/>Sleeping for 5 seconds... SMS_SITE_BACKUP 8/24/2009 6:11:00 PM 7828 (0x1E94)<br/>Sleeping for 5 seconds... SMS_SITE_BACKUP 8/24/2009 6:11:05 PM 7828 (0x1E94)<br/>Sleeping for 5 seconds... SMS_SITE_BACKUP 8/24/2009 6:11:10 PM 7828 (0x1E94)<br/>Sleeping for 5 seconds... SMS_SITE_BACKUP 8/24/2009 6:11:15 PM 7828 (0x1E94)<br/>Sleeping for 5 seconds... SMS_SITE_BACKUP 8/24/2009 6:11:20 PM 7828 (0x1E94)<br/>Sleeping for 5 seconds... SMS_SITE_BACKUP 8/24/2009 6:11:25 PM 7828 (0x1E94)<br/>Sleeping for 5 seconds... SMS_SITE_BACKUP 8/24/2009 6:11:30 PM 7828 (0x1E94)<br/>Sleeping for 5 seconds... SMS_SITE_BACKUP 8/24/2009 6:11:35 PM 7828 (0x1E94)<br/>Sleeping for 5 seconds... SMS_SITE_BACKUP 8/24/2009 6:11:40 PM 7828 (0x1E94)<br/>Sleeping for 5 seconds... SMS_SITE_BACKUP 8/24/2009 6:11:45 PM 7828 (0x1E94)<br/>Sleeping for 5 seconds... SMS_SITE_BACKUP 8/24/2009 6:11:50 PM 7828 (0x1E94)<br/>Sleeping for 5 seconds... SMS_SITE_BACKUP 8/24/2009 6:11:55 PM 7828 (0x1E94)<br/>Sleeping for 5 seconds... SMS_SITE_BACKUP 8/24/2009 6:12:00 PM 7828 (0x1E94)<br/>Sleeping for 5 seconds... SMS_SITE_BACKUP 8/24/2009 6:12:05 PM 7828 (0x1E94)<br/>Sleeping for 5 seconds... SMS_SITE_BACKUP 8/24/2009 6:12:10 PM 7828 (0x1E94)<br/>Sleeping for 5 seconds... SMS_SITE_BACKUP 8/24/2009 6:12:15 PM 7828 (0x1E94)<br/>Sleeping for 5 seconds... SMS_SITE_BACKUP 8/24/2009 6:12:20 PM 7828 (0x1E94)<br/>Sleeping for 5 seconds... SMS_SITE_BACKUP 8/24/2009 6:12:25 PM 7828 (0x1E94)<br/>Sleeping for 5 seconds... SMS_SITE_BACKUP 8/24/2009 6:12:30 PM 7828 (0x1E94)<br/>Sleeping for 5 seconds... SMS_SITE_BACKUP 8/24/2009 6:12:35 PM 7828 (0x1E94)<br/>Sleeping for 5 seconds... SMS_SITE_BACKUP 8/24/2009 6:12:41 PM 7828 (0x1E94)<br/>Sleeping for 5 seconds... SMS_SITE_BACKUP 8/24/2009 6:12:46 PM 7828 (0x1E94)<br/>Sleeping for 5 seconds... SMS_SITE_BACKUP 8/24/2009 6:12:51 PM 7828 (0x1E94)<br/>Sleeping for 5 seconds... SMS_SITE_BACKUP 8/24/2009 6:12:56 PM 7828 (0x1E94)<br/>Sleeping for 5 seconds... SMS_SITE_BACKUP 8/24/2009 6:13:01 PM 7828 (0x1E94)<br/>Sleeping for 5 seconds... SMS_SITE_BACKUP 8/24/2009 6:13:06 PM 7828 (0x1E94)<br/>Sleeping for 5 seconds... SMS_SITE_BACKUP 8/24/2009 6:13:11 PM 7828 (0x1E94)<br/>Sleeping for 5 seconds... SMS_SITE_BACKUP 8/24/2009 6:13:16 PM 7828 (0x1E94)<br/>Sleeping for 5 seconds... SMS_SITE_BACKUP 8/24/2009 6:13:21 PM 7828 (0x1E94)<br/>Sleeping for 5 seconds... SMS_SITE_BACKUP 8/24/2009 6:13:26 PM 7828 (0x1E94)<br/>Sleeping for 5 seconds... SMS_SITE_BACKUP 8/24/2009 6:13:31 PM 7828 (0x1E94)<br/>Sleeping for 5 seconds... SMS_SITE_BACKUP 8/24/2009 6:13:36 PM 7828 (0x1E94)<br/>Sleeping for 5 seconds... SMS_SITE_BACKUP 8/24/2009 6:13:41 PM 7828 (0x1E94)<br/>Sleeping for 5 seconds... SMS_SITE_BACKUP 8/24/2009 6:13:46 PM 7828 (0x1E94)<br/>Sleeping for 5 seconds... SMS_SITE_BACKUP 8/24/2009 6:13:51 PM 7828 (0x1E94)<br/>Sleeping for 5 seconds... SMS_SITE_BACKUP 8/24/2009 6:13:56 PM 7828 (0x1E94)<br/>Sleeping for 5 seconds... SMS_SITE_BACKUP 8/24/2009 6:14:01 PM 7828 (0x1E94)<br/>Sleeping for 5 seconds... SMS_SITE_BACKUP 8/24/2009 6:14:06 PM 7828 (0x1E94)<br/>Sleeping for 5 seconds... SMS_SITE_BACKUP 8/24/2009 6:14:11 PM 7828 (0x1E94)<br/>Sleeping for 5 seconds... SMS_SITE_BACKUP 8/24/2009 6:14:16 PM 7828 (0x1E94)<br/>Sleeping for 5 seconds... SMS_SITE_BACKUP 8/24/2009 6:14:21 PM 7828 (0x1E94)<br/>Sleeping for 5 seconds... SMS_SITE_BACKUP 8/24/2009 6:14:26 PM 7828 (0x1E94)<br/>Sleeping for 5 seconds... SMS_SITE_BACKUP 8/24/2009 6:14:31 PM 7828 (0x1E94)<br/>Sleeping for 5 seconds... SMS_SITE_BACKUP 8/24/2009 6:14:36 PM 7828 (0x1E94)<br/>Sleeping for 5 seconds... SMS_SITE_BACKUP 8/24/2009 6:14:41 PM 7828 (0x1E94)<br/>Sleeping for 5 seconds... SMS_SITE_BACKUP 8/24/2009 6:14:46 PM 7828 (0x1E94)<br/>Sleeping for 5 seconds... SMS_SITE_BACKUP 8/24/2009 6:14:51 PM 7828 (0x1E94)<br/>Sleeping for 5 seconds... SMS_SITE_BACKUP 8/24/2009 6:14:56 PM 7828 (0x1E94)<br/>Sleeping for 5 seconds... SMS_SITE_BACKUP 8/24/2009 6:15:01 PM 7828 (0x1E94)<br/>Sleeping for 5 seconds... SMS_SITE_BACKUP 8/24/2009 6:15:06 PM 7828 (0x1E94)<br/>Sleeping for 5 seconds... SMS_SITE_BACKUP 8/24/2009 6:15:11 PM 7828 (0x1E94)<br/>Sleeping for 5 seconds... SMS_SITE_BACKUP 8/24/2009 6:15:16 PM 7828 (0x1E94)<br/><strong>Error: Sql Server could not prepare for the Backup</strong>. SMS_SITE_BACKUP 8/24/2009 6:15:21 PM 7828 (0x1E94)<br/><strong>Aborting the backup process.</strong> SMS_SITE_BACKUP 8/24/2009 6:15:21 PM 7828 (0x1E94)<br/>SMS_SITE_BACKUP 8/24/2009 6:15:21 PM 7828 (0x1E94)<br/><strong>Error: CreateSnapshotSet failed</strong>... SMS_SITE_BACKUP 8/24/2009 6:15:21 PM 7828 (0x1E94)<br/>STATMSG: ID=5047 SEV=E LEV=M SOURCE=&quot;SMS Server&quot; COMP=&quot;SMS_SITE_BACKUP&quot; SYS=SCCM01 SITE=PC2 PID=10064 TID=7828 GMTDATE=Mon Aug 24 23:15:21.615 2009 ISTR0=&quot;&quot; ISTR1=&quot;&quot; ISTR2=&quot;&quot; ISTR3=&quot;&quot; ISTR4=&quot;&quot; ISTR5=&quot;&quot; ISTR6=&quot;&quot; ISTR7=&quot;&quot; ISTR8=&quot;&quot; ISTR9=&quot;&quot; NUMATTRS=0 SMS_SITE_BACKUP 8/24/2009 6:15:21 PM 7828 (0x1E94)<br/>SMS site backup failed. Please see previous errors. SMS_SITE_BACKUP 8/24/2009 6:15:21 PM 7828 (0x1E94)<br/>SMS site backup service is stopping. SMS_SITE_BACKUP 8/24/2009 6:15:21 PM 7828 (0x1E94)<br/>STATMSG: ID=502 SEV=I LEV=M SOURCE=&quot;SMS Server&quot; COMP=&quot;SMS_SITE_BACKUP&quot; SYS=SCCM01 SITE=PC2 PID=10064 TID=7828 GMTDATE=Mon Aug 24 23:15:21.647 2009 ISTR0=&quot;SMS site backup&quot; ISTR1=&quot;&quot; ISTR2=&quot;&quot; ISTR3=&quot;&quot; ISTR4=&quot;&quot; ISTR5=&quot;&quot; ISTR6=&quot;&quot; ISTR7=&quot;&quot; ISTR8=&quot;&quot; ISTR9=&quot;&quot; NUMATTRS=0 SMS_SITE_BACKUP 8/24/2009 6:15:21 PM 7828 (0x1E94)<br/>SMS site backup service stopped. SMS_SITE_BACKUP 8/24/2009 6:15:21 PM 7828 (0x1E94)<br/>STATMSG: ID=501 SEV=I LEV=M SOURCE=&quot;SMS Server&quot; COMP=&quot;SMS_SITE_BACKUP&quot; SYS=SCCM01 SITE=PC2 PID=10064 TID=7828 GMTDATE=Mon Aug 24 23:15:21.647 2009 ISTR0=&quot;SMS site backup&quot; ISTR1=&quot;&quot; ISTR2=&quot;&quot; ISTR3=&quot;&quot; ISTR4=&quot;&quot; ISTR5=&quot;&quot; ISTR6=&quot;&quot; ISTR7=&quot;&quot; ISTR8=&quot;&quot; ISTR9=&quot;&quot; NUMATTRS=0 SMS_SITE_BACKUP 8/24/2009 6:15:21 PM 7828 (0x1E94)<br/><br/><br/><strong>This is from my SMSWRITER.LOG</strong><br/><br/>OnIdentify event triggerred. SMS_SITE_VSS_WRITER 8/24/2009 6:10:17 PM 1012 (0x03F4)<br/>SMS Writer 08/24/09 18:10:17 - starting to build the metadata. SMS_SITE_VSS_WRITER 8/24/2009 6:10:17 PM 1012 (0x03F4)<br/>Successfully included D:\PROGRAM FILES (X86)\MICROSOFT CONFIGURATION MANAGER\INBOXES into to the metadata. SMS_SITE_VSS_WRITER 8/24/2009 6:10:17 PM 1012 (0x03F4)<br/>Successfully included D:\PROGRAM FILES (X86)\MICROSOFT CONFIGURATION MANAGER\LOGS into to the metadata. SMS_SITE_VSS_WRITER 8/24/2009 6:10:17 PM 1012 (0x03F4)<br/>Successfully included D:\PROGRAM FILES (X86)\MICROSOFT CONFIGURATION MANAGER\DATA into to the metadata. SMS_SITE_VSS_WRITER 8/24/2009 6:10:17 PM 1012 (0x03F4)<br/>Successfully included D:\PROGRAM FILES (X86)\MICROSOFT CONFIGURATION MANAGER\SRVACCT into to the metadata. SMS_SITE_VSS_WRITER 8/24/2009 6:10:17 PM 1012 (0x03F4)<br/>Successfully included <a>\\SCCM01\HKEY_LOCAL_MACHINE\Software\Wow6432Node\Microsoft\NAL</a> - D:\Program Files (x86)\Microsoft Configuration Manager\BackupTemp\SMSbkSiteRegNAL.dat into the metadata. SMS_SITE_VSS_WRITER 8/24/2009 6:10:17 PM 1012 (0x03F4)<br/>Successfully included <a>\\SCCM01\HKEY_LOCAL_MACHINE\Software\Wow6432Node\Microsoft\SMS</a> - D:\Program Files (x86)\Microsoft Configuration Manager\BackupTemp\SMSbkSiteRegSMS.dat into the metadata. SMS_SITE_VSS_WRITER 8/24/2009 6:10:17 PM 1012 (0x03F4)<br/>OnPrepareBackup event triggerred. SMS_SITE_VSS_WRITER 8/24/2009 6:10:19 PM 1012 (0x03F4)<br/>The backup task has selected the components in the Sms Writer. SMS_SITE_VSS_WRITER 8/24/2009 6:10:19 PM 1012 (0x03F4)<br/>ComponentName = PC2Backup\SiteServer\SMSServer\inboxes. SMS_SITE_VSS_WRITER 8/24/2009 6:10:19 PM 1012 (0x03F4)<br/>ComponentName = PC2Backup\SiteServer\SMSServer\Logs. SMS_SITE_VSS_WRITER 8/24/2009 6:10:19 PM 1012 (0x03F4)<br/>ComponentName = PC2Backup\SiteServer\SMSServer\data. SMS_SITE_VSS_WRITER 8/24/2009 6:10:19 PM 1012 (0x03F4)<br/>ComponentName = PC2Backup\SiteServer\SMSServer\srvacct. SMS_SITE_VSS_WRITER 8/24/2009 6:10:19 PM 1012 (0x03F4)<br/>ComponentName = PC2Backup\SiteServer\SMSbkSiteRegNAL.dat. SMS_SITE_VSS_WRITER 8/24/2009 6:10:19 PM 1012 (0x03F4)<br/>ComponentName = PC2Backup\SiteServer\SMSbkSiteRegSMS.dat. SMS_SITE_VSS_WRITER 8/24/2009 6:10:19 PM 1012 (0x03F4)<br/>ComponentName = PC2Backup\SiteDBServer\SMSbkSQLDBsite.dat. SMS_SITE_VSS_WRITER 8/24/2009 6:10:19 PM 1012 (0x03F4)<br/>Successfully exported the <a>\\SCCM01\HKEY_LOCAL_MACHINE\Software\Wow6432Node\Microsoft\NAL</a> to D:\Program Files (x86)\Microsoft Configuration Manager\BackupTemp\SMSbkSiteRegNAL.dat. SMS_SITE_VSS_WRITER 8/24/2009 6:10:20 PM 1012 (0x03F4)<br/>Successfully exported the <a>\\SCCM01\HKEY_LOCAL_MACHINE\Software\Wow6432Node\Microsoft\SMS</a> to D:\Program Files (x86)\Microsoft Configuration Manager\BackupTemp\SMSbkSiteRegSMS.dat. SMS_SITE_VSS_WRITER 8/24/2009 6:10:20 PM 1012 (0x03F4)<br/>Tue, 25 Aug 2009 00:01:25 Z2009-08-25T17:04:31Zhttp://social.technet.microsoft.com/Forums/en-US/configmgrbackup/thread/0077471f-051e-4b54-967c-6d6c747f24c5http://social.technet.microsoft.com/Forums/en-US/configmgrbackup/thread/0077471f-051e-4b54-967c-6d6c747f24c5Jeff Kuesperthttp://social.technet.microsoft.com/Profile/en-US/?user=Jeff%20KuespertSite backup fails when database is hosted on a clustered SQL instance<p>I know this post is similar to a few others, but after reading through them I am still experiencing issues. So..<br/><br/>Topology-<br/>&gt; Single Site server hosting all roles except database server role<br/>&gt;&gt; SCCM01<br/>&gt; 2-node A/P SQL 2005 SP3 cluster hosting database server role (Server 2K8 failover cluster)<br/>&gt;&gt; NODE1<br/>&gt;&gt; NODE2<br/>&gt;&gt; SCCMSQLCLU</p> <p>Configuration-<br/>&gt; SCCM01 computer account is resident in local admin groups on both SQL cluster nodes<br/>&gt; SQL service account has local admin rights on both SQL cluster nodes<br/>&gt; SPN properly registered for SQL service account<br/>&gt; Kerberos is enabled on clustered resource and is has been validated via SQL query<br/>&gt; Backup ConfigMgr Site Server configured to backup to a share local to site server<br/>&gt;&gt; Both SQL cluster nodes and virtual instance have FC rights (both share and NTFS)</p> <p>Observations-<br/>When running a site backup, the process quickly fails...<br/>&gt; The Application log only contains a single event (5055) indicating the start of the SMS_SITE_BACKUP component<br/>&gt; Migrating the database to a local SQL instance allows for a good backup<br/>&gt; The smsbkup.log from a clustered database backup attempt:</p> <p>&lt;START LOG&gt;<br/>Initializing the status message reporting system... SMS_SITE_BACKUP 8/4/2009 5:39:18 PM 6160 (0x1810)<br/>    The path to the &quot;Status Manager&quot; inbox is &quot;E:\SMS\inboxes\statmgr.box\statmsgs&quot;. SMS_SITE_BACKUP 8/4/2009 5:39:18 PM 6160 (0x1810)<br/>    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 8/4/2009 5:39:18 PM 6160 (0x1810)<br/>Registered this process as a source of &quot;SMS Server&quot; events. SMS_SITE_BACKUP 8/4/2009 5:39:18 PM 6160 (0x1810)<br/>Registered this process as a source of &quot;SMS Client&quot; events. SMS_SITE_BACKUP 8/4/2009 5:39:18 PM 6160 (0x1810)<br/>Registered this process as a source of &quot;SMS Provider&quot; events. SMS_SITE_BACKUP 8/4/2009 5:39:18 PM 6160 (0x1810)<br/>Status message reporting system initialized successfully. SMS_SITE_BACKUP 8/4/2009 5:39:18 PM 6160 (0x1810)<br/>Locale set to OS value (English_United States.1252). SMS_SITE_BACKUP 8/4/2009 5:39:18 PM 6160 (0x1810)<br/>SMS site backup service 4.00 started. SMS_SITE_BACKUP 8/4/2009 5:39:18 PM 6160 (0x1810)<br/>STATMSG: ID=500 SEV=I LEV=M SOURCE=&quot;SMS Server&quot; COMP=&quot;SMS_SITE_BACKUP&quot; SYS=SCCM01 SITE=JCS PID=4828 TID=6160 GMTDATE=Tue Aug 04 22:39:18.807 2009 ISTR0=&quot;SMS site backup&quot; ISTR1=&quot;&quot; ISTR2=&quot;&quot; ISTR3=&quot;&quot; ISTR4=&quot;&quot; ISTR5=&quot;&quot; ISTR6=&quot;&quot; ISTR7=&quot;&quot; ISTR8=&quot;&quot; ISTR9=&quot;&quot; NUMATTRS=0 SMS_SITE_BACKUP 8/4/2009 5:39:18 PM 6160 (0x1810)<br/>08/04/09 17:39:18 - starting backup. SMS_SITE_BACKUP 8/4/2009 5:39:18 PM 6160 (0x1810)<br/>BackupDir = E:\SMSSITEBACKUP. SMS_SITE_BACKUP 8/4/2009 5:39:18 PM 6160 (0x1810)<br/>Installation RootDir = E:\SMS. SMS_SITE_BACKUP 8/4/2009 5:39:19 PM 6160 (0x1810)<br/>Site SQL Dir = . SMS_SITE_BACKUP 8/4/2009 5:39:19 PM 6160 (0x1810)<br/>Warning: Backup location and the sms data (installation directory) are on the same volume. Sms Backup creates snapshot of the volume using VSS services and then copies the data to the backup location. It is advisable to have the backup location on a different volume (different than the one that has SMS data and SMS database files), so that the writes to the volume is minimal when the volume snapshot is active. SMS_SITE_BACKUP 8/4/2009 5:39:19 PM 6160 (0x1810)<br/>Site Backup Location = <a>\\SCCM01\SMSSITEBACKUP$</a> SMS_SITE_BACKUP 8/4/2009 5:39:19 PM 6160 (0x1810)<br/>SQL Backup Location = <a>\\SCCM01\SMSSITEBACKUP$</a> SMS_SITE_BACKUP 8/4/2009 5:39:19 PM 6160 (0x1810)<br/>STATMSG: ID=5055 SEV=I LEV=M SOURCE=&quot;SMS Server&quot; COMP=&quot;SMS_SITE_BACKUP&quot; SYS=SCCM01 SITE=JCS PID=4828 TID=6160 GMTDATE=Tue Aug 04 22:39:19.354 2009 ISTR0=&quot;&quot; ISTR1=&quot;&quot; ISTR2=&quot;&quot; ISTR3=&quot;&quot; ISTR4=&quot;&quot; ISTR5=&quot;&quot; ISTR6=&quot;&quot; ISTR7=&quot;&quot; ISTR8=&quot;&quot; ISTR9=&quot;&quot; NUMATTRS=0 SMS_SITE_BACKUP 8/4/2009 5:39:19 PM 6160 (0x1810)<br/>LogEvent(): Successfully logged Event to NT Event Log. (4 - 48 - 1,073,746,879) SMS_SITE_BACKUP 8/4/2009 5:39:19 PM 6160 (0x1810)<br/>Starting VSS initialization... SMS_SITE_BACKUP 8/4/2009 5:39:19 PM 6160 (0x1810)<br/>Starting Asynchronous GatherWriterMetadata. SMS_SITE_BACKUP 8/4/2009 5:39:20 PM 6160 (0x1810)<br/>Number of writers that responded: 10. SMS_SITE_BACKUP 8/4/2009 5:39:28 PM 6160 (0x1810)<br/>Reading SMS Writer metadata... SMS_SITE_BACKUP 8/4/2009 5:39:28 PM 6160 (0x1810)<br/>Number of FileIncludes: 0. SMS_SITE_BACKUP 8/4/2009 5:39:28 PM 6160 (0x1810)<br/>Number of FileExcludes: 0. SMS_SITE_BACKUP 8/4/2009 5:39:28 PM 6160 (0x1810)<br/>Number of Components: 7. SMS_SITE_BACKUP 8/4/2009 5:39:28 PM 6160 (0x1810)<br/>Component 0 - JCSBackup\SiteServer\SMSServer\inboxes. SMS_SITE_BACKUP 8/4/2009 5:39:28 PM 6160 (0x1810)<br/>FileGroupFile = E:\SMS\INBOXES\* [Recursive: yes] SMS_SITE_BACKUP 8/4/2009 5:39:28 PM 6160 (0x1810)<br/>Volume E:\ (that contains the file(s)) is marked as a candidate for snapshot. SMS_SITE_BACKUP 8/4/2009 5:39:28 PM 6160 (0x1810)<br/>Component 1 - JCSBackup\SiteServer\SMSServer\Logs. SMS_SITE_BACKUP 8/4/2009 5:39:28 PM 6160 (0x1810)<br/>FileGroupFile = E:\SMS\LOGS\* [Recursive: yes] SMS_SITE_BACKUP 8/4/2009 5:39:28 PM 6160 (0x1810)<br/>Volume E:\ (that contains the file(s)) is marked as a candidate for snapshot. SMS_SITE_BACKUP 8/4/2009 5:39:28 PM 6160 (0x1810)<br/>Component 2 - JCSBackup\SiteServer\SMSServer\data. SMS_SITE_BACKUP 8/4/2009 5:39:28 PM 6160 (0x1810)<br/>FileGroupFile = E:\SMS\DATA\* [Recursive: yes] SMS_SITE_BACKUP 8/4/2009 5:39:28 PM 6160 (0x1810)<br/>Volume E:\ (that contains the file(s)) is marked as a candidate for snapshot. SMS_SITE_BACKUP 8/4/2009 5:39:28 PM 6160 (0x1810)<br/>Component 3 - JCSBackup\SiteServer\SMSServer\srvacct. SMS_SITE_BACKUP 8/4/2009 5:39:28 PM 6160 (0x1810)<br/>FileGroupFile = E:\SMS\SRVACCT\* [Recursive: yes] SMS_SITE_BACKUP 8/4/2009 5:39:28 PM 6160 (0x1810)<br/>Volume E:\ (that contains the file(s)) is marked as a candidate for snapshot. SMS_SITE_BACKUP 8/4/2009 5:39:28 PM 6160 (0x1810)<br/>Component 4 - JCSBackup\SiteServer\SMSbkSiteRegNAL.dat. SMS_SITE_BACKUP 8/4/2009 5:39:28 PM 6160 (0x1810)<br/>FileGroupFile = E:\SMS\BackupTemp\SMSbkSiteRegNAL.dat [Recursive: no] SMS_SITE_BACKUP 8/4/2009 5:39:28 PM 6160 (0x1810)<br/>Volume E:\ (that contains the file(s)) is marked as a candidate for snapshot. SMS_SITE_BACKUP 8/4/2009 5:39:28 PM 6160 (0x1810)<br/>Component 5 - JCSBackup\SiteServer\SMSbkSiteRegSMS.dat. SMS_SITE_BACKUP 8/4/2009 5:39:28 PM 6160 (0x1810)<br/>FileGroupFile = E:\SMS\BackupTemp\SMSbkSiteRegSMS.dat [Recursive: no] SMS_SITE_BACKUP 8/4/2009 5:39:28 PM 6160 (0x1810)<br/>Volume E:\ (that contains the file(s)) is marked as a candidate for snapshot. SMS_SITE_BACKUP 8/4/2009 5:39:28 PM 6160 (0x1810)<br/>Component 6 - JCSBackup\SiteDBServer\SMSbkSQLDBsite.dat. SMS_SITE_BACKUP 8/4/2009 5:39:28 PM 6160 (0x1810)<br/>Dependency On SQL Writer , LogicalPath:\\SCCMSQLCLU, ComponentName:SMS_JCS SMS_SITE_BACKUP 8/4/2009 5:39:28 PM 6160 (0x1810)<br/>After GatherWriterMetadata SMS Writer status = FAILED_AT_PREPARE_BACKUP. SMS_SITE_BACKUP 8/4/2009 5:39:28 PM 6160 (0x1810)<br/>Starting to clean and prepare the backup location. SMS_SITE_BACKUP 8/4/2009 5:39:28 PM 6160 (0x1810)<br/>Cleanup and/or preparation done. SMS_SITE_BACKUP 8/4/2009 5:39:28 PM 6160 (0x1810)<br/>Info: Sending message to start the SQL Backup... SMS_SITE_BACKUP 8/4/2009 5:39:28 PM 6160 (0x1810)<br/>Starting to create the snapshot set. SMS_SITE_BACKUP 8/4/2009 5:39:28 PM 6160 (0x1810)<br/>Added volume containing E:\ to the snapshot set. SMS_SITE_BACKUP 8/4/2009 5:39:29 PM 6160 (0x1810)<br/>Info: Starting Asynchronous PrepareForBackup... SMS_SITE_BACKUP 8/4/2009 5:39:29 PM 6160 (0x1810)<br/>Info: Asynchronous PrepareForBackup finished... SMS_SITE_BACKUP 8/4/2009 5:39:29 PM 6160 (0x1810)<br/>Info: Waiting for SQL to PrepareForBackup. SMS_SITE_BACKUP 8/4/2009 5:39:29 PM 6160 (0x1810)<br/>Sleeping for 5 seconds... SMS_SITE_BACKUP 8/4/2009 5:39:30 PM 6160 (0x1810)<br/>ERROR: SQL Backup task failed. Error message - SMS_SITE_BACKUP 8/4/2009 5:39:35 PM 6160 (0x1810)<br/>STATMSG: ID=5052 SEV=W LEV=M SOURCE=&quot;SMS Server&quot; COMP=&quot;SMS_SITE_BACKUP&quot; SYS=SCCM01 SITE=JCS PID=4828 TID=6160 GMTDATE=Tue Aug 04 22:39:35.057 2009 ISTR0=&quot;<a>\\SCCMSQLCLU</a>&quot; ISTR1=&quot;SMS_JCS&quot; ISTR2=&quot;&quot; ISTR3=&quot;&quot; ISTR4=&quot;&quot; ISTR5=&quot;&quot; ISTR6=&quot;&quot; ISTR7=&quot;&quot; ISTR8=&quot;&quot; ISTR9=&quot;&quot; NUMATTRS=0 SMS_SITE_BACKUP 8/4/2009 5:39:35 PM 6160 (0x1810)<br/>Error: Sql Server could not prepare for the Backup. SMS_SITE_BACKUP 8/4/2009 5:39:35 PM 6160 (0x1810)<br/>Aborting the backup process. SMS_SITE_BACKUP 8/4/2009 5:39:35 PM 6160 (0x1810)<br/>SMS_SITE_BACKUP 8/4/2009 5:39:35 PM 6160 (0x1810)<br/>Error: CreateSnapshotSet failed... SMS_SITE_BACKUP 8/4/2009 5:39:35 PM 6160 (0x1810)<br/>STATMSG: ID=5047 SEV=E LEV=M SOURCE=&quot;SMS Server&quot; COMP=&quot;SMS_SITE_BACKUP&quot; SYS=SCCM01 SITE=JCS PID=4828 TID=6160 GMTDATE=Tue Aug 04 22:39:35.260 2009 ISTR0=&quot;&quot; ISTR1=&quot;&quot; ISTR2=&quot;&quot; ISTR3=&quot;&quot; ISTR4=&quot;&quot; ISTR5=&quot;&quot; ISTR6=&quot;&quot; ISTR7=&quot;&quot; ISTR8=&quot;&quot; ISTR9=&quot;&quot; NUMATTRS=0 SMS_SITE_BACKUP 8/4/2009 5:39:35 PM 6160 (0x1810)<br/>SMS site backup failed. Please see previous errors. SMS_SITE_BACKUP 8/4/2009 5:39:35 PM 6160 (0x1810)<br/>SMS site backup service is stopping. SMS_SITE_BACKUP 8/4/2009 5:39:35 PM 6160 (0x1810)<br/>STATMSG: ID=502 SEV=I LEV=M SOURCE=&quot;SMS Server&quot; COMP=&quot;SMS_SITE_BACKUP&quot; SYS=SCCM01 SITE=JCS PID=4828 TID=6160 GMTDATE=Tue Aug 04 22:39:35.276 2009 ISTR0=&quot;SMS site backup&quot; ISTR1=&quot;&quot; ISTR2=&quot;&quot; ISTR3=&quot;&quot; ISTR4=&quot;&quot; ISTR5=&quot;&quot; ISTR6=&quot;&quot; ISTR7=&quot;&quot; ISTR8=&quot;&quot; ISTR9=&quot;&quot; NUMATTRS=0 SMS_SITE_BACKUP 8/4/2009 5:39:35 PM 6160 (0x1810)<br/>SMS site backup service stopped. SMS_SITE_BACKUP 8/4/2009 5:39:35 PM 6160 (0x1810)<br/>STATMSG: ID=501 SEV=I LEV=M SOURCE=&quot;SMS Server&quot; COMP=&quot;SMS_SITE_BACKUP&quot; SYS=SCCM01 SITE=JCS PID=4828 TID=6160 GMTDATE=Tue Aug 04 22:39:35.291 2009 ISTR0=&quot;SMS site backup&quot; ISTR1=&quot;&quot; ISTR2=&quot;&quot; ISTR3=&quot;&quot; ISTR4=&quot;&quot; ISTR5=&quot;&quot; ISTR6=&quot;&quot; ISTR7=&quot;&quot; ISTR8=&quot;&quot; ISTR9=&quot;&quot; NUMATTRS=0 SMS_SITE_BACKUP 8/4/2009 5:39:35 PM 6160 (0x1810)<br/>&lt;END LOG&gt;</p> <p>Advice?</p>Wed, 05 Aug 2009 02:38:59 Z2009-08-12T16:21:25Z