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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Real error or not?

Author  Topic 

LeoC
Starting Member

37 Posts

Posted - 2004-11-24 : 11:49:35
The following error appears at random in the log. Its timestamp (log and event viewer) coincides with the master job/plan. But the job does not fail.

Table error: Object ID 0, index ID 0, page ID (1:413911). The PageId in the page header = (0:0).



lec.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2004-11-24 : 13:27:30
Run DBCC CHECKDB to determine if you have database corruption.

Tara
Go to Top of Page

LeoC
Starting Member

37 Posts

Posted - 2004-11-24 : 14:21:02
CHECKDB is part of the M. plan; it's logged in Event Viewer as successful.


lec.
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2004-11-24 : 14:22:53
So this error is being generated when the CHECKDB maintenance plan is run? If so, run DBCC CHECKDB in QA for your user databases and all system ones.

Tara
Go to Top of Page
   

- Advertisement -