KB: A Configuration Manager 2007 backup doesn’t backup the database files even though the backup logs show that it was successful

Here’s a new Knowledge Base article we published. This one talks about an issue where a Configuration Manager 2007 backup doesn’t backup the database files even though the backup logs show that it was successful. ===== Symptoms A scheduled Configuration Manager 2007 backup runs and appears to complete but the database files are not present… Read more

How to install or move the Configuration Manager 2007 site database to a clustered Microsoft SQL Server instance

Hi everyone, my name is Fei Xia and I wanted to take this opportunity to show you how to successfully install or move the Configuration Manager 2007 site database to a clustered Microsoft SQL Server instance. The System Center Configuration Manager 2007 site database can be installed or moved to a clustered virtual Microsoft SQL… Read more

Moving the Configuration Manager 2007 site database from SQL 2005 SP2 to SQL 2008

Hi everyone, Anurag Shukla here.  The following article discusses how to move the Configuration Manager (ConfigMgr 2007) site database (DB) from a SQL Server 2005 SP2 based computer to a SQL Server 2008 based computer.  Note that this may not be the only way to successfully migrate the DB but it’s a method I’ve used… Read more

Troubleshooting Duplicate or Missing SPNs for a ConfigMgr 2007 SQL Database

This blog post addresses a common problem customers face during the installation of System Center Configuration Manager 2007 in which the following error appears: “Setup failed to install SMS Provider.” When this error occurs, there are several possible causes, but the first thing I check is Service Principal Names or SPNs. Background When setting up… Read more

Fix: The ConfigMgr 2007 database grows excessively large and DPs do not honor the "Number of retries" and "Delay before retrying (minutes)" retry settings

You may notice that an unusually large number of System Center Configuration Manager 2007 status messages are generated causing significant growth in database size.  Further investigation also shows a large number of these entries repeating over and over again in the distmgr.log: Compressed files for package xxx hasn’t arrived from site xxx Note: These messages… Read more