Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1539
  • Last Modified:

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
0
anushahanna
Asked:
anushahanna
Advertise Here
1 Solution
 
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.

Join & Write a Comment

Featured Post

What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

Take the quiz
Advertise Here
Tackle projects and never again get stuck behind a technical roadblock.
Join Now