Database inconsistency issues

Hi,

When I run DBCC CHECKDB, I get a severe error.

When I run DBCC CHECKCATALOG, I get database inconsistency errors.

I googled and came across the following solution:
1. Start instance  in single user mode.
2. Connect with DAC
3. sp_configure allow update on
4. edit sys.columns manually

My question is - how do I go about editing sys.columns manually? What are the steps, the SQL statements involved, etc.?

Thanks.
zeekay22Asked:
Who is Participating?
 
Anthony PerkinsConnect With a Mentor Commented:
Then unfortunately, the best you can do is something like this (but do a backup first):
ALTER DATABASE YourDatabase SET SINGLE_USER WITH NO_WAIT
GO
DBCC CHECKDB (YourDatabase, REPAIR_ALLOW_DATA_LOSS)
GO
ALTER DATABASE YourDatabase SET MULTI_USER WITH NO_WAIT
0
 
Scott PletcherConnect With a Mentor Senior DBACommented:
You can't directly update the systems table in SQL 2008, so that's not really a solution.

How to recover from db error(s) depends on the specific db in which the error occurred, the specific error(s), whether or not you have a clean backup and other factors.  So, unfortunately, without further details, I can't provide any more help on how to recover.
0
 
zeekay22Author Commented:
This is SQL Server 2008R2 Express Edition.

There are no clean backups available.

The errors have been delineated in the question above.
0
 
zeekay22Author Commented:
Ended up having to do a db to db copy.
0
 
Anthony PerkinsCommented:
I am sorry you did not like the answer.  Unfortunately given the circumstances the question was complicated to say the least.

The best part of this is that you have now learned the importance of backups.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.