Backup and file manipulation operations on a database must be serialized

I am getting the following for the above:

Msg 3023, Level 16, State 3, Line 2
Backup and file manipulation operations (such as ALTER DATABASE ADD FILE) on a database must be serialized. Reissue the statement after the current backup or file manipulation operation is completed.
Msg 3013, Level 16, State 1, Line 2
BACKUP LOG is terminating abnormally.

is there a way to check what operation is going on that it is blocking?

thanks
LVL 6
anushahannaAsked:
Who is Participating?
 
cnemcse1Commented:
What SQL Server version are you using? The current activity window can help you, you can also try the profile analyzer, and the SP_locks.
To solve your problem you have to separate your statements using different steps, batches, or transactions. it seems that you are trying to backup and alter the database in the same batch, statement, or transaction. Both operations are not allowed in a single statement or transaction.  
0
 
anushahannaAuthor Commented:
sql 2000.

i am just trying to run the backup log; i have no idea if another backup is happening, as it is not there in msdb.dbo.backupset..
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.

Advertise Here