Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AgaK
Yak Posting Veteran
86 Posts |
 Posted - 2010-03-01 : 17:37:32
|
| Hi,I am checking the integrity of the databases with a Maint Plan with Check Database Integrity Task. When I run dbcc dbinfo it reports that the integrity was never checked. When I am checking the integrity with dbcc checkdb, the dbcc dbinfo reports the last valid integrity check properly.Is the maintenance plan way a viable solution?Thank youAK |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2010-03-01 : 19:13:05
|
| I'm 100% against maintenance plans, and that's just an example of why. The best example of why though is that when they fail, they don't provide enough information to figure out what's wrong.Instead of a maintenance plan, simply add DBCC CHECKDB to a SQL job. You'll need to loop through the databases, but that's easy with a WHILE loop.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog"Let's begin with the premise that everything you've done up until this point is wrong." |
 |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2010-03-02 : 03:18:26
|
| SQL 2005 SP2 by any chance? Check the SQL error log, there was a bug in some of the SP2 builds that resulted in maint plans repeatedly doing checkDB on master, not on the user databases.--Gail ShawSQL Server MVP |
|
|
|
AgaK
Yak Posting Veteran
86 Posts |
Posted - 2010-03-02 : 17:18:33
|
| It's on 9.00.3042 so SQL 2005 SP2. I will have to apply SP3...Thank you!AK |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2010-03-03 : 00:54:23
|
| Set up a manual checkDB job, like Tara suggests, at least until you get SP3 installed.--Gail ShawSQL Server MVP |
|
|
|
|
|
|
integrity checks