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 |
|
senthilkmd
Starting Member
4 Posts |
 Posted - 2003-05-10 : 11:51:48
|
| Hi folks,how to restore/recover a database which is in suspect mode and don't have a backup of the database....thanks in advanceRegards,Senthil. |
|
|
monkeybite
Posting Yak Master
152 Posts |
Posted - 2003-05-10 : 12:02:50
|
| This article from MSDN (also found in SQL Books online) will help you with this problem:[url]http://msdn.microsoft.com/library/default.asp?url=/library/en-us/trblsql/tr_servdatabse_494j.asp[/url]~ monkey |
 |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2003-05-11 : 04:48:09
|
quote:
This article from MSDN (also found in SQL Books online) will help you with this problem:
I would rephrase that as '...May help you with this problem"In fact, sp_resetstatus in most cases won't help. You need to determine what caused it to go suspect to begin with. Look in your error log, and find the error that tells you why it went suspect.-Chadhttp://www.clrsoft.comSoftware built for the Common Language Runtime. |
|
|
|
|
|
|
Recover a suspect DataBase