SQL: Error 3023

Executing a 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.

It took a lot of time understanding the meaning because I wasn't making a backup, finally I checked the sysprocesses and I found a backup background process launched from a colleague...

I waited the process end and then it worked !
Tags: , , ,

About author

Vittorio Pavesi