Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
edeleon
Starting Member
3 Posts |
 Posted - 2006-10-09 : 12:00:05
|
| After recovering SQL DB it was identified as "SUSPECT". Changed the status of the the DB to "Emergency Mode" to recreate the log file. I cannot change the status back to normal. Can anyone please tell me how to change the status back to normal. Please help. |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-10-09 : 12:20:29
|
| All emergency mode does is enable you to access the database without it attempting recovery.Now you need o create another database and copy everything into it.seehttp://www.nigelrivett.net/SQLAdmin/RecoverCorruptDatabase.htmlIf you think it is ok then you can try recovering by setting the flag back but I doubt if that will get anywhere.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
SQLDB Emergency Mode