Hi Gail

in my test instance i have managed to changed the db status to mergency. this i was able to do so by putting the instance into single user mode...

Hi Gail

how can we allow ad hoc updates to system catalogs in sql 2005?

We tried using a recovery tool and it has actualy retrieved a lot of data by reading the mdf file, which states that the mdf is not corrupted. we have...

Thank you Gail.

Hi Gail

I am in office now

Hi Gail

I am going out of office for now for (2 hours).

Thanks Steve

We have been doing regular backups and have manage to get back all DB's online except for this one. Its a newly created DB (7 months) and somehow we...

Hi Gail

I have tried all the steps you had requested in the live system but still get the same error when trying to set mode to emergency

Msg 602, Level 21,...

hi Gail

Please let me know when u online

Thanks Gail

I get this error when i run set to emergency

Msg 602, Level 21, State 33, Line 1

Could not find an entry for table or index with partition ID 327680...

yes they are identical

on the same server we have 2 instances of the sql server. not to muck up the production file (which is in suspect mode) i copied the mdf and ldf...

Actualy the logs have been over-written as we have been trying out some cammands like:

sp_resetstatus

alter database card set emergency

dbcc checkdb

alter database card set single_user

dbcc checkdb (card, repair_allow_data_loss)

sp_configure 'allow_updates', 1 Reconfigure...

Error: 9003, Severity: 20, State: 9.

Error: 3414, Severity: 21, State: 1.

Error: 928, Severity: 20, State: 1.

During upgrade, database raised exception 926, severity 14, state 1, address 00000000017238A8. Use the exception...

The log scan number (78939:11140:1) passed to log scan in database 'card' is not valid. This error may indicate data corruption or that the log file (.ldf) does not match...