Viewing 4 posts - 1 through 4 (of 4 total)
I found the problem. Seems the code generated by SQL Server isn't working in the maintenance plan, though it works fine when I run that code manually:
USE [MYDATABASE]
GO
DBCC CHECKDB WITH...
June 5, 2008 at 4:16 pm
Part of the maintenance plan is working, because the backups are running fine. And the log says that the integrity check is succeeding as well, which is why it's odd....
June 5, 2008 at 1:15 pm
I'm having a similar problem. Check DB Integrity is part of my maintenance plan, but it returns no errors and the logs say it runs very quickly (around 15 seconds...
June 5, 2008 at 11:22 am
Thanks for the good advice! I think I'll go with Michael Earl's suggestion, since that would work nicely for my needs.
October 23, 2007 at 8:55 am
Viewing 4 posts - 1 through 4 (of 4 total)