September 28, 2009 at 2:21 pm
Hello I have this version of SQL 2005
Microsoft SQL Server 2005 - 9.00.4035.00 (X64) Nov 24 2008 16:17:31 Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2)
I have a maintenance plan on my server that has several blocks like
1) Full backup,
2) Trn backup,
3) update stats
4) check db and
5) rebuild index
6) cleanup history
--history of maint. plan says the plan runs fine until step-3.
After that no error message but it never goes to step- 4, 5 and 6
--the maint plan runs from sql job and the job says it failed but
its not telling why the job failed.
Is there any prob with checkdb task in sql 2005 -sp3?
September 29, 2009 at 4:25 am
dallas13 (9/28/2009)
Hello I have this version of SQL 2005Microsoft SQL Server 2005 - 9.00.4035.00 (X64) Nov 24 2008 16:17:31 Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2)
I have a maintenance plan on my server that has several blocks like
1) Full backup,
2) Trn backup,
3) update stats
4) check db and
5) rebuild index
6) cleanup history
--history of maint. plan says the plan runs fine until step-3.
After that no error message but it never goes to step- 4, 5 and 6
Unless you define a workflow for the on failure event it obviously won't go to steps 4 ,5 and 6
--the maint plan runs from sql job and the job says it failed but
its not telling why the job failed.
Is there any prob with checkdb task in sql 2005 -sp3?
Not that I'm aware of.
Did you check the logfile for the dbcc checkdb step?
Are you sure there's no consistency error somewhere?
[font="Verdana"]Markus Bohse[/font]
September 29, 2009 at 7:11 am
Of course I have defined the workflow.. and that is on completion of the task go to next step
so it doesnt matter its successful or fail.
--I checked the log file and I dont see any entry like dbcc checkdb for so and so database
for any database.
September 29, 2009 at 7:14 am
Do you have a log file redirection which can tell where the exact issue is!
Try splitting the operation into 2 jobs and see if they are working fine as seperate.
September 29, 2009 at 1:38 pm
Agree with above suggestion.. try to create seperate Maintanance Plan to do CheckDB and/or Rebuild Index.
Each task has its own plan and hence its own job, it will be easier to figure out what is wrong.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply