April 10, 2008 at 10:24 am
On a DB Maintenance plan for one of our SQL Server 2005 sp2, when you have a 'Check Database Integrity' task and you set it to 'all user databases' or just select the individual user databases, SQL Error Log shows that the 'master' and 'mssqlsystemresource' have been checked instead (also appeared in Application Log in Event Viewer). Both entries appear for each user database. If you have 1 DB, they will appear once, if you have 13, you will have 13 entries for 'master' and 13 for 'mssqlsystemresource'.
Why would this be? Are the user databases really being checked, and how would you know which one had an issue if there was one?
Thanks for any ideas.
April 10, 2008 at 11:47 am
This is a problem in SP2. This problem was not there in SP1..
Better script the process and schedule it to run through job.
NJ
April 10, 2008 at 12:33 pm
There is a fix for this Maintenance Plan bug.
http://support.microsoft.com/kb/934459
If you're interested in a script, I have a stored procedure that you can use to check the integrity of all your databases.
http://ola.hallengren.com/sql-server-integrity-check.html
Ola Hallengren
April 10, 2008 at 12:51 pm
Thanks very much. I will explore these options.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply