May 20, 2008 at 6:49 am
Hi, we installed sql2005 RTM, then installed SP2 (3042). We create two jobs for integrity checks one for system databases and one for user databases. It appears that only the system databases get checked. Is there a hotfix that I need to apply to SP2?
May 20, 2008 at 7:22 am
Are you using a maintenance plan? I beleive in a maint plan you can specify system databases only, user databases only or all databases.
If it's set to all, is the maint plan giving any errors? Are the user databases online at the time the job runs (not restoring, offline, single user, etc)
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
May 20, 2008 at 7:27 am
We are using a maintenance plan. I think the issues is the SP2 release. I think I need the hotfix to correct the maintenance plan bug.
Just can;t seem to get the plans to check the user databases.
Now I have to find the right one.
May 20, 2008 at 10:03 am
May 20, 2008 at 10:12 am
Ola is right.
I had the same issue on several machines and the hotfix solved the problem.
[font="Verdana"]Markus Bohse[/font]
May 20, 2008 at 10:18 am
Thanks all, I downloaded it.
May 20, 2008 at 10:20 am
If you for some reason can not implement the Microsoft hotfix, I have a Maintenance Plan - like stored procedure that you could use to check the integrity of your databases.
http://ola.hallengren.com/sql-server-integrity-check.html
Ola Hallengren
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply