Microsoft KB Archive/274743

= SMS: SQL Error 3023 in Collection Evaluator Log =

Article ID: 274743

Article Last Modified on 2/25/2007

-

APPLIES TO


 * Microsoft Systems Management Server 2003
 * Microsoft Systems Management Server 2.0 Standard Edition

-



This article was previously published under Q274743



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 &quot;Symptoms&quot; 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, &quot;Maintaining SMS Systems&quot; in the Microsoft Systems Management Server 2.0 Administrator's Guide.

Additional query words: prodsms backup collection evaluator evaluation

Keywords: kbcollections kbdatabase kbprb kbserver kbsmsutil KB274743

-

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

© Microsoft Corporation. All rights reserved.