Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 274743 - Last Review: February 25, 2007 - Revision: 6.3
SMS: SQL Error 3023 in Collection Evaluator Log
This article was previously published under Q274743
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.
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.
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.
APPLIES TO
- Microsoft Systems Management Server 2003
- Microsoft Systems Management Server 2.0 Standard Edition
| kbcollections kbdatabase kbprb kbserver kbsmsutil KB274743 |
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate