Help me about inconsinstence - 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

General SQL Server Forums

Data Corruption Issues

Help me about inconsinstence

Author

Topic

antonio.voce
Starting Member

2 Posts

Posted - 2005-11-25 : 06:26:26

I need help ,I have DB Sql server 2000 SP4 2040

I have executed DBCC check and this is the result.

CHECKDB found 0 allocation errors and 1 consistency errors in table '(Object ID 1933210799)' (object ID 193321079
Table error: Object ID 1937870211, index ID 44605, page ID (4:58819). The PageId in the page header = (15415:3170
CHECKDB found 0 allocation errors and 1 consistency errors in table '(Object ID 1937870211)' (object ID 193787021
Table error: Object ID 1944021862, index ID 63043, page ID (4:59032). The PageId in the page header = (53834:1681
.
CHECKDB found 0 allocation errors and 1 consistency errors in table '(Object ID 1944021862)' (object ID 194402186
Table error: Object ID 1973210851, index ID 39558, page ID (4:59196). The PageId in the page header = (12976:-195
).
CHECKDB found 0 allocation errors and 1 consistency errors in table '(Object ID 1973210851)' (object ID 197321085
Table error: Object ID 1984655935, index ID 42243, page ID (4:59140). The PageId in the page header = (38894:-204
.
CHECKDB found 0 allocation errors and 1 consistency errors in table '(Object ID 1984655935)' (object ID 198465593
Table error: Object ID 1991892156, index ID 25319, page ID (4:58980). The PageId in the page header = (52127:-166
).
CHECKDB found 0 allocation errors and 1 consistency errors in table '(Object ID 1991892156)' (object ID 199189215
Table error: Object ID 2014254711, index ID 42586, page ID (4:58875). The PageId in the page header = (23912:-167
).
CHECKDB found 0 allocation errors and 1 consistency errors in table '(Object ID 2014254711)' (object ID 201425471
Table error: Object ID 2017720197, index ID 13368, page ID (4:59129). The PageId in the page header = (6395:20327
CHECKDB found 0 allocation errors and 1 consistency errors in table '(Object ID 2017720197)' (object ID 201772019
Table error: Object ID 2028416236, index ID 44765, page ID (4:59113). The PageId in the page header = (58171:-191
.
CHECKDB found 0 allocation errors and 1 consistency errors in table '(Object ID 2028416236)' (object ID 202841623
Table error: Object ID 2032442077, index ID 7245, page ID (4:58999). The PageId in the page header = (42765:-7455
CHECKDB found 0 allocation errors and 1 consistency errors in table '(Object ID 2032442077)' (object ID 203244207
Table error: Object ID 2039509240, index ID 5096, page ID (4:59205). The PageId in the page header = (3719:482105
CHECKDB found 0 allocation errors and 1 consistency errors in table '(Object ID 2039509240)' (object ID 203950924
Table error: Object ID 2051499906, index ID 41080, page ID (4:58954). The PageId in the page header = (1325:-1230
.
CHECKDB found 0 allocation errors and 1 consistency errors in table '(Object ID 2051499906)' (object ID 205149990
Table error: Object ID 2062659138, index ID 11389, page ID (4:58854). The PageId in the page header = (2958:18751
CHECKDB found 0 allocation errors and 1 consistency errors in table '(Object ID 2062659138)' (object ID 206265913
Table error: Object ID 2071574907, index ID 41151, page ID (4:58743). The PageId in the page header = (40831:5418
CHECKDB found 0 allocation errors and 1 consistency errors in table '(Object ID 2071574907)' (object ID 207157490
Table error: Object ID 2078709045, index ID 27432, page ID (4:59198). The PageId in the page header = (34892:1856
.
CHECKDB found 0 allocation errors and 1 consistency errors in table '(Object ID 2078709045)' (object ID 207870904
Table error: Object ID 2079853039, index ID 45617, page ID (4:58767). The PageId in the page header = (28923:2123
.
CHECKDB found 0 allocation errors and 1 consistency errors in table '(Object ID 2079853039)' (object ID 207985303
Table error: Object ID 2081596332, index ID 17678, page ID (4:59016). The PageId in the page header = (14013:-164
).
CHECKDB found 0 allocation errors and 1 consistency errors in table '(Object ID 2081596332)' (object ID 208159633
Table error: Object ID 2109350408, index ID 11267, page ID (4:59188). The PageId in the page header = (25420:-137
).
CHECKDB found 0 allocation errors and 1 consistency errors in table '(Object ID 2109350408)' (object ID 210935040
Table error: Object ID 2113967733, index ID 40283, page ID (4:59070). The PageId in the page header = (32567:9827
CHECKDB found 0 allocation errors and 1 consistency errors in table '(Object ID 2113967733)' (object ID 211396773
Table error: Object ID 2114210993, index ID 47158, page ID (4:58763). The PageId in the page header = (60613:1234
CHECKDB found 0 allocation errors and 1 consistency errors in table '(Object ID 2114210993)' (object ID 211421099
Table error: Object ID 2119190717, index ID 44785, page ID (4:58920). The PageId in the page header = (38818:-914
.
CHECKDB found 0 allocation errors and 1 consistency errors in table '(Object ID 2119190717)' (object ID 211919071
Table error: Object ID 2120192857, index ID 2549, page ID (4:58864). The PageId in the page header = (23737:47818
CHECKDB found 0 allocation errors and 1 consistency errors in table '(Object ID 2120192857)' (object ID 212019285
Table error: Object ID 2121946480, index ID 61715, page ID (4:58939). The PageId in the page header = (37152:-181
).
CHECKDB found 0 allocation errors and 1 consistency errors in table '(Object ID 2121946480)' (object ID 212194648
Table error: Object ID 2126361917, index ID 40538, page ID (4:59025). The PageId in the page header = (746:-18137
CHECKDB found 0 allocation errors and 1 consistency errors in table '(Object ID 2126361917)' (object ID 212636191
CHECKDB found 0 allocation errors and 1241 consistency errors in database 'PRD'.
repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (PRD ).

Is There a way to update o rebuil table sysindexes on a production system ( i use this DB for SAP R/3 46c)

Thanks a lot

asha192
Starting Member

9 Posts

Posted - 2005-11-25 : 08:17:04

Can't you drop and rebuild all your indexes?

antonio.voce
Starting Member

2 Posts

Posted - 2005-11-25 : 09:34:31

do you intend one by one ?

paulrandal
Yak with Vast SQL Skills

899 Posts

Posted - 2005-11-25 : 11:20:44

quote:
Originally posted by asha192

Can't you drop and rebuild all your indexes?

How would that help?

Looks like the disk or controller has wiped out a section of one of your disks hosting file 4 (all the errors are clustered around the 59000 page range) - all the CHECKDB errors you didn't post will be complaining about not seeing pages or references to pages.

You're looking at restoring from your backups as a repair is going to cause a lot of data loss.

You also need to work out what happened. Look in the errorlog and Windows event logs for IO errors or h/w problems centered in the IO subsystem that hosts file 4. Are all you firmware/drivers up-to-date?

Regards

Paul Randal
Lead Program Manager, Microsoft SQL Server Storage Engine
(Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.)

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources