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 |
|
catchvaas
Starting Member
22 Posts |
 Posted - 2010-11-01 : 23:57:52
|
| Hello All,I am a beginner in SQL DBA role.I am trying to fix a database corruption issue in SQL 2000.Could anyone tell me the best ways to troubleshoot database corruption issues in SQL 2000?Thanks much in advance.Regards,Catchvaas |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2010-11-02 : 01:55:46
|
Very wide question. Depends on the exact problem you have. Please run the following and post the full and unedited output.DBCC CHECKDB (<Database Name>) WITH NO_INFOMSGS, ALL_ERRORMSGS Do you have a clean backup of this database? One without the corruption?Take a look at this article. [url]http://www.sqlservercentral.com/articles/65804/[/url]--Gail ShawSQL Server MVP |
 |
|
|
|
|
|
Help Please..