Microsoft KB Archive/922361

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

Article ID: 922361

Article Last Modified on 7/24/2006

-

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 \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 = ' :\_SM1B9.tmp' with INIT



CAUSE
This issue occurs when the MSSQLServer service account (MSSQLSERVER) does not have local administrator permissions, even though the &quot;Scenarios and Procedures for Systems Management Server 2003: Planning and Deployment&quot; 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 &quot;Scenarios and Procedures for Systems Management Server 2003: Planning and Deployment&quot; document, visit the following Microsoft Web site:

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

Keywords: kbprb KB922361

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.