We have a SQL 2005 Server Running on A win2k SP4 Box. we have a gotten some db corruption and not sure how to fix it, or if it can be fixed.Here is the output from the DBCC CheckDB:DBCC results for 'GIS2_Ltd__MSCRM'.Msg 2515, Level 16, State 1, Line 1Page (1:35326), object ID 4, index ID 1, partition ID 262144, alloc unit ID 262144 type In-row data) has been modified but is not marked modified in the differential backup bitmap. The repair level on the DBCC statement caused this repair to be bypassed.There are de6733 rows in 70 pages for object "sys.sysrowsetcolumns".CHECKDB found 0 allocation errors and 1 consistency errors in table 'sys.sysrowsetcolumns' (object ID 4).Msg 7995, Level 16, State 1, Line 1Database 'GIS2_Ltd__MSCRM': consistency errors in system catalogs prevent further DBCC checkdb processing.CHECKDB found 0 allocation errors and 1 consistency errors in table 'ALLOCATION' (object ID 99).CHECKDB found 0 allocation errors and 2 consistency errors in database 'GIS2_Ltd__MSCRM'.repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (GIS2_Ltd__MSCRM, repair_rebuild).DBCC execution completed. If DBCC printed error messages, contact your system administrator.
We noticed the problem this afternoon, but appears to be going back to saturday. We run nightly full backups through our back up software, but would like to try and recover the data if possible.
Msg 2515 and Msg 7995
Posted - 2007-04-26 : 00:40:26
