Search

Tuesday, May 8, 2012

Error 3023

Today I got below error while executing a backup query 
BACKUP LOG MyDB WITH TRUNCATE_ONLY


I got the following error:


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.


I checked the sysprocesses and I found a backup background process launched from someone else. so I waited for the process to end and above query worked. 

No comments:

Post a Comment