Meg,

All of these database operations need to happen in isolation to each other.

ie. If you are running a Backup, you can not run a CHECKALLOC on the same
database.

Check that you don't have more than one process trying to do these things at
the same time. Could be a couple of different maintenance plans clashing.

Rob

Robert Elmes
Database Administrator
Thales Defence - Communications Division
Tel: +44-1344-387613



-----Original Message-----
From: Meg Hardy [mailto:[Email Address Removed] 25 June 2002 09:40
To: SQLDBA (E-mail)
Subject: error message?


Hi there,

Does anyone know what this could mean...


Msg 3023, Sev 16: 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. [SQLSTATE 42000]


...thankyou!, Meg


MS Sql Server LazyDBA home page