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 |
|
y.koteswarrao
Starting Member
3 Posts |
 Posted - 2009-02-21 : 03:36:18
|
| Hi,When i executed DBCC CHECKDB it was marked as suspect, how to recover/fix the suspect database?Koteswar Rao |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-02-21 : 09:00:20
|
quote:
Originally posted by y.koteswarrao
Hi,When i executed DBCC CHECKDB it was marked as suspect, how to recover/fix the suspect database?Koteswar Rao
First of all, Did you search for it? This topic is designed to support data corruption and inconsistency errors for real time scenerio not for interview question. |
 |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2009-02-24 : 05:13:11
|
| Depends why it was marked suspect. What were the errors, what messages are there in the SQL error log?--Gail ShawSQL Server MVP |
|
|
|
|
|
|
Database Corrupt