November 17, 2004 at 4:55 am
Hi,
I have a db maint plan which backs up a db on a daily basis to a file but since last week, an error has occurred with the following message:-
"Microsoft SQL-DMO (ODBC SQLState: 42000)
Backup, CHECKALLOC, bulk copy, SELECT INTO, and the file manipulation (such as CREATE FILE) operations on a database must be serialised. Reissue the statement after the current backup, CHECKALLOC, or file manipulation operation is completed.
Backup or restore operation terminating abnormally."
Any ideas? Many thanks in advance for your help.
p.s. The db is on MS-SQL 7.
November 17, 2004 at 5:37 am
I would say the message is pretty much self-describing. Could it be that any of the above mentioned operations runs while you try to backup the db?
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
November 17, 2004 at 7:18 am
Can't see anything in sysprocesses. Will have to schedule a re-boot I think...
November 19, 2004 at 7:49 am
Have you looked at the error_log to see if you can get more details about why the job is failing?
Could you post the portion of the error_log with the related error message and your syntax here.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply