05-30-2009 11:19 AM
When I run the Act! diagnostics (not from inside Act Check&Repair, but standalone on the database). If I run "Check" database, it halts and displays the following error message. Nothing has been done to alter the database. No other error messages. The internal Tools-Check&Repair works fine. Does anyone have an idea what is wrong with the database or the program.
The page (1:185), object ID 4, index ID 1, partition ID 262144, allocation unit ID 262144 (type In-row data) has been modified, but is not marked as modified in the differential backup bitmap.
Database 'MAGdb2009': consistency errors in system catalogs prevent further DBCC checkdb processing.
Database Maintenance error occurred with PRC_MAINT_REPAIRDB: CHECKDB
DBCC results for 'MAGdb2009'.
The repair level on the DBCC statement caused this repair to be bypassed.
There are 2546 rows in 21 pages for object "sys.sysrowsetcolumns".
CHECKDB found 0 allocation errors and 1 consistency errors in table 'sys.sysrowsetcolumns' (object ID 4).
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 'MAGdb2009'.
repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (MAGdb2009, repair_rebuild).
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
06-01-2009 01:03 PM