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 |
|
mayoorsubbu
Yak Posting Veteran
95 Posts |
 Posted - 2013-08-10 : 03:04:30
|
| Dear All,I am running SQL Server 2000. My database is running in Suspect mode. When I explore the database through the enterprise manager no objects can be seen. I am not able to set the database in EMERGENCY mode which is the first step to recover the same. I tried to run the following scriptALTER DATABASE [MyDatabase] SET EMERGENCYCan someone suggest a way out. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Recover Suspect Database