Problem with DBREINDEX - SQL Server Forums

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)

Problem with DBREINDEX

Author

Topic

rasopeng
Starting Member

1 Post

Posted - 2006-07-21 : 10:37:10

Hi.

Let me get straight to the problem.

when I run DBCC CHECKTABLE() I get the following error:

Server: Msg 8928, Level 16, State 1, Line 1
Object ID 868198143, index ID 0: Page (1:645871) could not be processed. See other errors for details.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 868198143, index ID 0, page (1:645871). Test (IS_ON (BUF_IOERR, bp->bstat) && bp->berrcode) failed. Values are 2057 and -1.
Server: Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 868198143, index ID 1. Page (1:645816) is missing a reference from previous page (1:645871). Possible chain linkage problem.
Server: Msg 8976, Level 16, State 1, Line 1
Table error: Object ID 868198143, index ID 1. Page (1:645871) was not seen in the scan although its parent (1:646257) and previous (1:645870) refer to it. Check any previous errors.
DBCC results for 'Member'.
The repair level on the DBCC statement caused this repair to be bypassed.
The repair level on the DBCC statement caused this repair to be bypassed.
The repair level on the DBCC statement caused this repair to be bypassed.
The repair level on the DBCC statement caused this repair to be bypassed.
There are 195257 rows in 2172 pages for object 'Member'.
CHECKTABLE found 0 allocation errors and 4 consistency errors in table 'Member' (object ID 868198143).
repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKTABLE (DHSLog.dbo.Member repair_rebuild

Can please someone help.

Mpho

nr
SQLTeam MVY

12543 Posts

Posted - 2006-07-21 : 10:38:48

I would create a new table an copy as much data as posible into it from this table.
Do you know what caused the problem?

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

KenW
Constraint Violating Yak Guru

391 Posts

Posted - 2006-07-21 : 13:49:36

Try posting this in the Database Corruption forum.

Ken

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources