This is live, old I know, but I really need advice.
So I had a corrupt db. Backups all screwed. So we decided to repair if poss.
set the db to single_user
dbcc checkdb (db, repair_rebuild) - no joy.
dbcc checkdb (db, repair_allow_data_loss) - successful, fixed 1 error.
dbcc checkdb (db) - no more errors
set the db to mutli_user
& now it's not there.
error log shows the db.
"setting database option MULTI_USER to ON for database xx"
then nothing …
there are disk issues on here supposedly fixed. but I see also
BEGIN STACK DUMP
.. encountered error... Invalid access to memory location.
mdf & ldf not there either.
help, what to do