Hi'
I ma getting the following error some nights when I do
backups:
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3023:
[Microsoft][ODBC SQL Server Driver][SQL Server]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.
[Microsoft][ODBC SQL Server Driver][SQL Server]Backup or
restore operation terminating abnormally.
[43] Database master: Database Backup...
Nothing is running against the db at that time except the
backup.
Thanks in advace> Nothing is running against the db at that time except the
> backup.
If you are 100% certain it isn't, then you've found a bug and should search
if such is documented in KB and if not open a case with MS PSS. But start
with running a Profiler trace just to make sure you don't have such, could
be a job or something.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
<anonymous@.discussions.microsoft.com> wrote in message
news:e56501c40b72$badd5060$a101280a@.phx.gbl...
> Hi'
> I ma getting the following error some nights when I do
> backups:
> [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3023:
> [Microsoft][ODBC SQL Server Driver][SQL Server]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.
> [Microsoft][ODBC SQL Server Driver][SQL Server]Backup or
> restore operation terminating abnormally.
> [43] Database master: Database Backup...
> Nothing is running against the db at that time except the
> backup.
> Thanks in advace
No comments:
Post a Comment