Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SQL Backup Error

Status
Not open for further replies.

biktoryah

Programmer
Mar 14, 2003
9
0
0
PH
When I tried backing up a database in the server this error came up

"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. Backup or restore operation terminating abnormally"

what does this mean? and what can i do to fix it?

your reply is very much appreciated..thank you

biktoryah
 
It sounds like another process, of the type listed, is currently running.

Are you already in the middle of a backup?
Do you have any bulk copy jobns scheduled which are running (DTS etc..)?
Are you running any DBCC checks?

Check the output of sp_who to see current connections and see if you can see anything odd. It may be that a process was started a while ago but failed and the connection is stuck open.

--James
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top