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.
Author |
Topic |
ussanjeewa
Starting Member
1 Post |
Posted - 2012-10-04 : 09:17:58
|
One of our databases is giving this errorMsg 8929, Level 16, State 1, Line 1Object ID 60, index ID 1, partition ID 281474980642816, alloc unit ID 281474980642816 (type In-row data): Errors found in off-row data with ID 1082130432 owned by data record identified by RID = (1:415:1)Msg 8929, Level 16, State 1, Line 1Object ID 60, index ID 1, partition ID 281474980642816, alloc unit ID 281474980642816 (type In-row data): Errors found in off-row data with ID 1082130432 owned by data record identified by RID = (1:632:0)Msg 8914, Level 16, State 1, Line 1Incorrect PFS free space information for page (1:9780) in object ID 60, index ID 1, partition ID 281474980642816, alloc unit ID 71776119065149440 (type LOB data). Expected value 80_PCT_FULL, actual value 100_PCT_FULL.Msg 8961, Level 16, State 2, Line 1Table error: Object ID 60, index ID 1, partition ID 281474980642816, alloc unit ID 71776119065149440 (type LOB data). The off-row data node at page (1:9780), slot 1, text ID 1082130432 does not match its reference from page (1:415), slot 1.CHECKDB found 0 allocation errors and 4 consistency errors in table 'sys.sysobjvalues' (object ID 60).CHECKDB found 0 allocation errors and 4 consistency errors in database 'TBS_Master'.repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (MYDB). |
|
chadmat
The Chadinator
1974 Posts |
Posted - 2012-10-04 : 13:14:41
|
If you have a backup, you can either restore from backup, or try to retrieve the corrupt pages/data. You could also try to run a dbcc checkdb with repair, but will likely lose data.-Chad |
|
|
NehwalSaina
Starting Member
2 Posts |
Posted - 2012-10-08 : 07:04:38
|
Repairing corrupt and damaged SQL Server database has never been so easy before. For excellent and accurate database recovery, use <unspammed> that is not only easy to use but its interactive and user-friendly screens makes this tool a favorite among novice computer users as well. It is the most effective tool to deal with any corruption issues and retrieve MDF files along with their inaccessible data. |
|
|
|
|
|
|
|