I have a corrupt sql server 2000 database table, dbcc checktable yields:
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 738101670: Errors found in text ID 1922475229184 owned by data record identified by RID = (1:5663655:28) PageId = 53918671.
Server: Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 738101670. The text, ntext, or image node at page (1:5663737), slot 0, text ID 1922475229184 is referenced by page (1:4527446), slot 9, but was not seen in the scan.
When I try to use dbcc page( testdb, page#,1 ) where I plug in any of the reported page#'s above I always get the following:
"Server: Msg 8968, Level 16, State 1, Line 2
Table error: DBCC PAGE page (41728:1) (object ID 0, index ID 0) is out of the range of this database.
DBCC execution completed. If DBCC printed error messages, contact your system administrator."
The only page value which does not yield this error is page 1, which is the only pageno I found on any examples on the web. I guess this is because this is the only page it works on?
Can you post the exact command your using?Also, can you tell me the result of 'SELECT DB_ID()'?
Thanks,|||Looks like you've got your parameters swapped. It should be dbcc page(testdb, 1, page#). The second parameter is the file number (which will always be 1 if your database has no secondary data files).
|||
You are correct! The format I originally found on the internet was either for a prior version or something else unexplained. I found the correct format in one of Ken Henderson's books.
Thanks!
