hi all, I need some help here.
Recently, I've found a db with error 8905... error suggested using repair_allow_data_loss . Since I have no clean backup because I inherited from someone else...
Error before fix:
Msg 8905, Level 16, State 1, Line 5
Extent (1:7546104) in database ID 5 is marked allocated in the GAM, but no SGAM or IAM has allocated it.
Msg 8905, Level 16, State 1, Line 5
Extent (1:7554192) in database ID 5 is marked allocated in the GAM, but no SGAM or IAM has allocated it.
Msg 8905, Level 16, State 1, Line 5
Extent (1:7562280) in database ID 5 is marked allocated in the GAM, but no SGAM or IAM has allocated it.
Msg 8905, Level 16, State 1, Line 5
Extent (1:7570368) in database ID 5 is marked allocated in the GAM, but no SGAM or IAM has allocated it.
CHECKDB found 127 allocation errors and 0 consistency errors in database 'DWH_LANDING'.
repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (DWH_LANDING, repair_rebuild).
after fix:
=========
Extent (1:6656424) in database ID 5 is marked allocated in the GAM, but no SGAM or IAM has allocated it.
The error has been repaired.
Msg 8905, Level 16, State 1, Line 5
Extent (1:6664512) in database ID 5 is marked allocated in the GAM, but no SGAM or IAM has allocated it.
The error has been repaired.
Msg 8905, Level 16, State 1, Line 5
Extent (1:6672600) in database ID 5 is marked allocated in the GAM, but no SGAM or IAM has allocated it.
The error has been repaired.
Msg 8905, Level 16, State 1, Line 5
Extent (1:6680688) in database ID 5 is marked allocated in the GAM, but no SGAM or IAM has allocated it.
The error has been repaired.
CHECKDB found 127 allocation errors and 0 consistency errors in database 'DWH_LANDING'.
CHECKDB fixed 127 allocation errors and 0 consistency errors in database 'DWH_LANDING'.
question:
=============
Is there any data loss during the process? this is the million dollar question!!
Thanks a lot!