Hi last night at one of client side we had one of our databases RECOVERY PENDING state.what it is .I searched for error log but found nothing that database had % recovered so as suggest told by senior dba took steps of emergency followed by single user and then checkdb.
checkdb did not find any allocation or consistency error what are both, what is difference between them and what is more lethal
after tha i rune checkdb repair_allow_data_loss command it to did not find anything but my database was up.i heard there is also option of repair_rebulid.
what`s difference between "repair_allow_data_loss" and "repair_rebulid"
issue was that log file of that particular database was full so i shrinked log file once database was up
thanks and regards