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 |
|
sharmiabivas
Starting Member
3 Posts |
 Posted - 2009-02-24 : 00:29:03
|
| how to Recover from suspect mode to normal mode in mssql 7Sharmila |
|
|
shaggy
Posting Yak Master
248 Posts |
Posted - 2009-02-24 : 04:13:38
|
| EXEC sp_resetstatus 'ur database name' |
 |
|
|
shaggy
Posting Yak Master
248 Posts |
Posted - 2009-02-24 : 04:18:32
|
| Why it has gone to suspect mode check for disk space and rights for the folders where the MDF and LDF Files available |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2009-02-24 : 05:08:27
|
| Depends on why it's suspect in the first place. Check the SQL error log for messages relating to this database.--Gail ShawSQL Server MVP |
|
|
|
sharmiabivas
Starting Member
3 Posts |
Posted - 2009-02-25 : 02:06:35
|
quote:
Originally posted by shaggy
Why it has gone to suspect mode check for disk space and rights for the folders where the MDF and LDF Files available
i dont know why it has gone to suspect mode but the disk is not fullSharmila |
|
|
|
sharmiabivas
Starting Member
3 Posts |
Posted - 2009-02-25 : 02:17:24
|
quote:
Originally posted by shaggy
EXEC sp_resetstatus 'ur database name'
hi shaggythanks for ur help i executed this command EXEC sp_resetstatus 'ur database name'the mode have changed but am not able to view any table its throwing the error "it has been marked SUSPECT by recovery"so help me how to recover from this suspect mode Sharmila |
|
|
|
shaggy
Posting Yak Master
248 Posts |
Posted - 2009-02-25 : 04:24:14
|
| Check for event log error msg. Run DBCC CHECKDB(dbname) |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2009-02-25 : 13:32:06
|
quote:
Originally posted by sharmiabivasi dont know why it has gone to suspect mode
Check the SQL error log for messages indicating why SQL has marked the DB suspect. Without knowing the root cause, an appropriate solution cannot be determined.--Gail ShawSQL Server MVP |
|
|
|
|
|
|
Recovery from suspect mode ?