SMS: SQL Error 3023 in Collection Evaluator Log

Article translations Article translations
Article ID: 274743 - View products that this article applies to.
This article was previously published under Q274743
Expand all | Collapse all

SYMPTOMS

The Collection Evaluator component, along with various other Systems Management Server (SMS) components, may generate an SQL error 3023 if it runs during the backup of the SMS database.

The following error messages are generated in the Colleval.log file on the site server:
********~Evaluating SMS00007
Next due date for collection SMS00007 is 09/26/00 11:00:00
Preparing to refresh collection SMS00007
SQL Err #10007> General SQL Server error: Check messages from the SQL Server.
SQL Msg #3023> Backup, CHECKALLOC, bulk copy, SELECT INTO, and file manipulation (such as CREATE FILE) operations on a database must be serialized. Reissue the statement after the current backup, CHECKALLOC, or file manipulation operation is completed.
CCollectionSource_SQL::RefreshResults - could not create index
Could not refresh collection SMS00007. Will retry later.

CAUSE

These messages can appear if the SMS services are allowed to run while the backup operation is in progress, and a component attempts a database operation.

Some SQL operations are serial in nature, meaning that only one operation can be performed at a time while this operation is in a running state. The backup operation is one such operation. Any operations specified in the error message in the "Symptoms" section may fail, and generate a 3023 error message while the backup operation is running. This creates the need to shut down all SMS services before starting an SMS database backup.

The Backup SMS Site Server database maintenance task that is included with SMS stops the necessary SMS services during execution. Using other methods to perform the same task may result in this error message if the SMS services are not shut down prior to performing the backup.

WORKAROUND

It is highly recommended that the SMS database maintenance task be used to shut down the SMS services, and also to back up the SMS database, files, and registry.

For additional information on how to perform a backup of the SMS database refer to Chapter 18, "Maintaining SMS Systems" in the Microsoft Systems Management Server 2.0 Administrator's Guide.

Properties

Article ID: 274743 - Last Review: February 25, 2007 - Revision: 6.3
APPLIES TO
  • Microsoft Systems Management Server 2003
  • Microsoft Systems Management Server 2.0 Standard Edition
Keywords: 
kbcollections kbdatabase kbprb kbserver kbsmsutil KB274743

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com