When you try to run the SMS 2003 built-in backup task, the backup task may not finish or may stop running (922361)


The information in this article applies to:

  • Microsoft Systems Management Server 2003

SYMPTOMS

When you try to run the Microsoft Systems Management Server (SMS) 2003 built-in backup task, the backup task may not finish or may stop running. Additionally, an error message that resembles the following may be logged in the Smsbkup.log file:
Failed to backup site database SMS up to Drive:\SMSBCKUP\CENBackup\SiteDBServer\SMSbkSQLDBsite.dat: unable to execute SQL command. SMS_SITE_BACKUP 05/24/2006 09:41:11
The Microsoft SQL Server error log also may contain an error message that resembles the following:
2006-05-24 09:41:11.42 spid51 BackupDiskFile::CreateMedia: Backup device 'F:\_SM1B9.tmp' failed to create. Operating system error = 5(error not found). 2006-05-24 09:41:11.42 backup BACKUP failed to complete the command backup database SMS to DISK = 'C:\_SM1B9.tmp' with INIT

CAUSE

This issue occurs when the MSSQLServer service account (MSSQLSERVER) does not have local administrator permissions, even though the "Scenarios and Procedures for Systems Management Server 2003: Planning and Deployment" document recommends that you use a domain user account for the service account.

In this case, the root drive of the SQL Server installation is hard-coded as the location where the temp file for the SMS database backup is created. If the MSSQLServer service account has restricted permissions, the required temp file is not created, and the backup fails.

WORKAROUND

To work around this issue, make sure that the MSSQLServer service account has administrative permissions. To do this, follow these steps:
  1. Click Start, click Administrative Tools, and then click Services.
  2. In the Services MMC snap-in, locate the MSSQLSERVER service, and then click Properties.
  3. In the MSSQLSERVER Properties dialog box, click the Log On tab.
  4. Under Log on as, click the button next to This account, and then click Browse.
  5. In the Select User dialog box, enter an account that has local administrator permissions, and then click OK.

MORE INFORMATION

To download the "Scenarios and Procedures for Systems Management Server 2003: Planning and Deployment" document, visit the following Microsoft Web site:

http://www.microsoft.com/downloads/details.aspx?FamilyID=e0644bb4-2336-4254-8a18-9bc180713f7e&displayLang=en

Modification Type:MajorLast Reviewed:7/24/2006
Keywords:kbprb KB922361 kbAudITPRO
©2004 Microsoft Corporation. All rights reserved.