September 9, 2009 at 8:21 am
I have a maintenance plan which takes the db in to simple recovery model , rebuild the indexes , and then get it back to full recovery model.
The step where the db is taken to Full recovery model is failing with 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 have no backup being taken at the same time when the job runs. I am not sure why I am getting this error.
Thanks.
September 9, 2009 at 8:27 am
Trooper (9/9/2009)
I have a maintenance plan which takes the db in to simple recovery model , rebuild the indexes , and then get it back to full recovery model.The step where the db is taken to Full recovery model is failing with 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 have no backup being taken at the same time when the job runs. I am not sure why I am getting this error.
Thanks.
I would also check to see if there is any server side backup software running at the time like legato backup. Also check to see if any other jobs are running and see what they are doing.
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
September 9, 2009 at 8:35 am
The server side backups happen at a differen time however we have transactional log backups taken every 15 mins. But I cross checked the timing when the last step was being executed and it was not conflicting the transactional log backups (they are lessa than 10 sec in duration)
September 9, 2009 at 8:37 am
there are two things you could do now, one to check the windows event logs and see what else is running, or re-schedule your maintenance job + - 1 hour perhaps.
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
September 9, 2009 at 8:42 am
No more information was present in the log apart from the failure of the Jobs. Anything else that needs to be looked into?
September 9, 2009 at 8:49 am
Are there any other sql jobs that run on that database anywhere near the time it failed, or any that might have either failed or over run.
can you check to see if you have antivirus or anti-spyware running on that server and if so check the exclusion lists and see if the database files (mdf,ldf etc) are on the exclusion list.
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
September 9, 2009 at 8:55 am
I have a job that takes transactional log backup every 15 mins....for example the last step when the db had to be taken to full recovery model ran 7:02 PM and the transactinal log backup ran at 7:00 Pm.....would that be a problem....?
September 9, 2009 at 8:58 am
Possibly not, but if possible I would have the step that you are having problems with, run in a period where you know there is nothing else running, that could contend with it.
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply