I'm relatively new at administering MS SQL Server and I have run into problem. We have a maintenance plan that runs every Sunday at midnight. It performs database backups and database integrity checks. Last night the maintenance plan got an 8929 error on one of the databases. From what I have gathered from MSDN, this indicates a data corruption possibly caused by a hardware failure. The strange thing is I ran a DBCC CHECKDB on the same database this morning and it came back with no errors.
Has anyone ever run into a similar problem with a maintenance plan coming back with and error but CHECKDB does not? Is there any way to find out if there really is a data corruption error? We are running SQL Server 2000 on Windows NT 5.0
I appreciate any help you can give me.