Viewing 6 posts - 1 through 6 (of 6 total)
Anyway, thanks for your help, GilaMonster 🙂
May 31, 2010 at 7:26 am
Message output:
Msg 7985, Level 16, State 2, Line 5
System table pre-checks: Object ID 3. Could not read and latch page (1:1400) with latch type SH. Check statement terminated due to...
May 31, 2010 at 7:20 am
Log:
Date,Source,Severity,Message
05/31/2010 16:23:37,spid51,Unknown,EMERGENCY MODE DBCC CHECKDB (InProSys<c/> repair_allow_data_loss) executed by sa terminated abnormally due to error state 0. Elapsed time: 0 hours 0 minutes 34 seconds.
05/31/2010 16:23:37,spid51,Unknown,Unable to read and latch...
May 31, 2010 at 6:29 am
GilaMonster (5/31/2010)
Now for an emergency mode repair.
DBCC CheckDB('InProSys', REPAIR_ALLOW_DATA_LOSS)
Post any output.
I got this message:
Repair statement not processed. Database needs to be in single user mode.
I assume, since it's a test...
May 31, 2010 at 5:30 am
I did what you wrote.
Command(s) completed successfully.
Here is a part of log:
Date,Source,Severity,Message
05/31/2010 14:31:06,spid51,Unknown,The database 'InProSys' is marked EMERGENCY_MODE and is in a state that does not allow recovery to be...
May 31, 2010 at 4:39 am
I don't have backup. Maybe I can try something else ?
May 31, 2010 at 1:38 am
Viewing 6 posts - 1 through 6 (of 6 total)