June 2, 2010 at 2:08 am
Error :
Job 'Job Name' : Step 4, 'LOGTRUNCATE 1' : Began Executing 2010-05-30 22:54:20
Msg 3023, Sev 16: 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. [SQLSTATE 42000]
Msg 3013, Sev 16: BACKUP LOG is terminating abnormally. [SQLSTATE 42000]
Job 'Job Name' : Step 17, 'Email Notification Failure' : Began Executing 2010-05-30 22:54:20
June 2, 2010 at 2:15 am
you're trying to do a log backup while some file operation (file add, grow, remove) is in progress. As the error says, they cannot run together. Rerun the job when the file operation has finished.
What's the job doing?
Is this SQL 2000?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 2, 2010 at 2:27 am
Hi,
Thanks..
Yes it is sql 2000, This is a WEEKLYMAINTENANCE job in PROD. (It is sync with DR, logshipping and it will take log backup form every 30 min)
It will do rebuild indexes, update statistics and shrink DB.
June 2, 2010 at 2:33 am
Why the hell are you shrinking the database after rebuilding indexes? You may as well not bother rebuilding indexes at all since the shrink will fragment them probably worse than they were before the rebuild.
http://sqlinthewild.co.za/index.php/2007/09/08/shrinking-databases/
Check for file operations that were running at the same time. Alter database add file, alter database remove file, autogrow, autoshrink (which I hope is not enabled)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 29, 2010 at 7:14 am
Hi, I get the same error as the user above...
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. ...
however, I am not runnning any other jobs at the same time. My logs backups are running normally. I tried to do a Full back to a new media set and I get the same error....
I am clueless what is causing the error....
June 29, 2010 at 7:32 am
Please post new questions in a new thread. Thanks
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply