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 |
|
Viral
Starting Member
3 Posts |
 Posted - 2009-04-23 : 02:34:05
|
| Hi,If I run "dbcc checkdb" on one of databaseIt gives me below errorDBCC results for 'GHAVAI'.CHECKDB found 0 allocation errors and 0 consistency errors in database 'GHAVAI'.Msg 211, Level 23, State 51, Line 1Possible schema corruption. Run DBCC CHECKCATALOG.And When I run "DBCC CHECKCATALOG"It gives me same errorPossible schema corruption. Run DBCC CHECKCATALOG.Viral Patel |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2009-04-23 : 04:13:43
|
| Do you have a backup that doesn't have corruption? From the looks of the message you've got one of the irreparable corruptions there.--Gail ShawSQL Server MVP |
 |
|
|
Viral
Starting Member
3 Posts |
Posted - 2009-04-23 : 05:35:44
|
| I tried with previous Backup but found same Problem. And at client site this Database is in working state.Viral PatelNelito Systems Ltd |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2009-04-23 : 11:23:10
|
| Can you take a backup of the database at the client site and restore that? Does that give checkDB errors?--Gail ShawSQL Server MVP |
|
|
|
Viral
Starting Member
3 Posts |
Posted - 2009-04-24 : 03:53:52
|
| Yes I did but found same errorViral Patel |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2009-04-24 : 11:59:31
|
| And if you run a checkDB on the client's database?--Gail ShawSQL Server MVP |
|
|
|
|
|
|
Database Recovery