Your DTs may have a Select into statements or create file statements. Since your backup has failed this Statements cannot be run.
Please run your first and then run the DTS .It will solve the Issue.
regards
Elias

-----Original Message-----
From: Adil Basha [mailto:[Email Address Removed] November 25, 2003 9:28 AM
To: LazyDBA.com Discussion
Subject: Scheduled DTS Jobs Failed Urgent !!!


Hi All,

SQL Server 7
I have many DTS jobs running some of them have failed
to run as per schedule time, when i try to run
manually its giving the below error. pls see the below
error
and help me as it is a case of urgency.

"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."


The Scheduled backup has also failed. when i look at
the job history details it gives
sqlmaint.exe failed (SQLSTATE 42000) (Error 22029).
The step failed.

Wating for Response
TIA
Adil


__________________________________
Do you Yahoo!?
Free Pop-Up Blocker - Get it now
http://companion.yahoo.com/

---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Get today's cartoon: http://www.LazyDBA.com
To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page