September 29, 2010 at 7:36 am
I get the following error when my maintanse job runs, the error not all the time:
Executed as user: NT AUTHORITY\SYSTEM. ERROR -- Shrink Database Task: Database1 - 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] (Error 50000). The step failed.
Why I am getting this? Someone told me because we ran every 15 min transaction job,that interfering with Maintenance job
Thank you
September 29, 2010 at 7:49 am
what step is failing in the maintenance job?
What other job is running while this 1 is failing?
what transaction job is running every 15min? Tlog backup?
MCITP: Database Administrator 2005
MCTS SQL Server 2008
MCP SQL 2012/2014
MCSA SQL Server 2012/2014
MCSE Data Management and Analytics
September 29, 2010 at 7:57 am
Firstly why are you shrinking your database in a maintenance plan?
You probably have autoshrink enabled as well and the autoshrink is shrinking while the scheduled shrink is trying to run.
Error has nothing to do with tran log backups
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
September 29, 2010 at 7:59 am
what step is failing in the maintenance job?
Shrink Database Task: Database1- Backup and file manipulation operations (such as ALTER DATABASE ADD FILE)
What other job is running while this 1 is failing?
Tlog backup
what transaction job is running every 15min? Tlog backup?
Tlog backup
September 29, 2010 at 8:34 am
That step was removed by me,someone created this code before me and I didn't get any errors since that.Do you know why I got this error? Is this because we were shrinking db?
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply