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 - 2003-10-20 : 08:22:45
|
| Mala writes "Hi,Please let me know how can i recover a database which is gone into to suspect mode in a scenario where i don't have any backup file. Also please let me know the reasons for database slipping to suspect mode.Thanks in advance.Regards,Mala" |
|
|
VyasKN
SQL Server MVP & SQLTeam MVY
313 Posts |
Posted - 2003-10-20 : 08:52:13
|
| If you look at your SQL Server error log, you will see the exact reason why the database was marked suspect. Typical reasons include, not enough space on the disk, or the database file got deleted etc.Look up the page titled "Resetting the Suspect Status" in SQL Server Books Online.--HTH,Vyashttp://vyaskn.tripod.com |
 |
|
|
KnooKie
Aged Yak Warrior
623 Posts |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-10-20 : 12:24:33
|
| Take a look at sp_resetstatus in SQL Server Books Online. If you can get your database out of suspect mode using this system stored procedure, then immediately back up your database. You should also test this backup as well.Tara |
|
|
|
|
|
|
Database Suspect