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 |
|
Newhar
Starting Member
1 Post |
 Posted - 2008-07-28 : 05:24:03
|
| HiWe had a problem with our database a while back and put in a support call to Microsoft.One of the commands the support guy ran was sp_msforeachtable 'DBCC DBREINDEX(''?'')'This seemed to fix quite a few of the consistency errors we had at the time.Recently we had some more consistency errors and the minimum repair level was allow data loss.I tried running the command above and it repaired all the errors and the Database came up clean.I don’t really understand this. Can anyone please explain why the minimum repair level is allow data loss but this reindex repairs the problem.Is this an undocumented MS fix?Thanks in advance. |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2008-07-28 : 06:12:13
|
| Sometimes the checkDB recommendation is wrong. You're lucky.The preferred way to fix corruption is to restore from backup, rather than trusting the repair.--Gail ShawSQL Server MVP |
 |
|
|
|
|
|
Repair allow data loss