imageHere’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 in the backup location. There are no errors logged in the smsbkup.log or the smssqlbkup.log and they both show that the backup was successful.

Cause

This can occur if the database was attached in SQL using lower case characters for the database name. Note that this issue happens only when the database was first detached and then reattached again using the lower case database name.

Resolution

Follow the steps mentioned below to properly detach the database and attach it back with an upper case name.

1. On the Configuration Manager site server, stop the following services:

SMS_Executive
SMS_Site_Backup
SMS_Site_Component_Manager
SMS_Site_VSS_Writer
SMS Agent Host (on the server where the management point for that site is installed)

2. On the SQL Server stop the following service:

SMS_Site_SQL_Backup_(siteservername)

3. Perform the following SQL commands or manually right-click and choose the Tasks->Detach option.

USE master;
GO
EXEC sp_detach_db @dbname = '<DB Name>';
GO

4. Attach the database either using the SQL commands below or manually by using the Databases->Attach option. If you're doing it manually, make sure that the Attach As column has the correct DB name in upper case.

USE master;
GO
CREATE DATABASE <DB Name in upper case>
ON (FILENAME = '<SQL DB file path>\<db>.mdf'),
(FILENAME = '<SQL DB log file path>\<db>.ldf')
FOR ATTACH;
GO

4. Restart the services on the SQL server and the Configuration Manager server.

=====

For the most current version of this article, please see the following:

KB2733915 - A Configuration Manager 2007 backup doesn't backup the database files even though the backup logs show that it was successful (http://support.microsoft.com/kb/2733915)

J.C. Hornbeck | System Center & Security Knowledge Engineer

Get the latest System Center news on Facebook and Twitter:

clip_image001 clip_image002

App-V Team blog: http://blogs.technet.com/appv/
ConfigMgr Support Team blog: http://blogs.technet.com/configurationmgr/
DPM Team blog: http://blogs.technet.com/dpm/
MED-V Team blog: http://blogs.technet.com/medv/
Orchestrator Support Team blog: http://blogs.technet.com/b/orchestrator/
Operations Manager Team blog: http://blogs.technet.com/momteam/
SCVMM Team blog: http://blogs.technet.com/scvmm
Server App-V Team blog: http://blogs.technet.com/b/serverappv
Service Manager Team blog: http://blogs.technet.com/b/servicemanager
System Center Essentials Team blog: http://blogs.technet.com/b/systemcenteressentials
WSUS Support Team blog: http://blogs.technet.com/sus/

The Forefront Server Protection blog: http://blogs.technet.com/b/fss/
The Forefront Endpoint Security blog : http://blogs.technet.com/b/clientsecurity/
The Forefront Identity Manager blog : http://blogs.msdn.com/b/ms-identity-support/
The Forefront TMG blog: http://blogs.technet.com/b/isablog/
The Forefront UAG blog: http://blogs.technet.com/b/edgeaccessblog/