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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-07-09 : 10:55:49
|
| oyuntulga writes "How to recovery database in sql2000 . The base suspect.(not backup,not restory)" |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2004-07-09 : 12:22:15
|
| I know you say not backup/restore, but that is probably the best way. You need to figure out why it went suspect to begin with, the error log should give you some hints. You can try sp_resetstatus, but usually if you don't fix the root cause, this will do nothing for you.-Chadhttp://www.clrsoft.comSoftware built for the Common Language Runtime. |
 |
|
|
|
|
|
How to recovery database in sql2000