FTGE
asked on
MSSQL Database Keeps Shutting Off
i have MSSQL 2005 on a windows 2003 Server.
I have an accounting software that keeps shutting off after it is launched. I moved the database manually to a new server.
I installed the accounting software from scratch and the sample company that is default installed is working perfectly.
However when adding the my database it just shuts off.
I ran:
DBCC CHECKDB (MYDATABASE) WITH NO_INFOMSGS, ALL_ERRORMSGS
Here is what I got:
Msg 211, Level 23, State 15, Line 1
Possible schema corruption. Run DBCC CHECKCATALOG.
Msg 0, Level 20, State 0, Line 0
A severe error occurred on the current command. The results, if any, should be discarded.
I ran:
DBCC CHECKCATALOG
I Got:
Msg 3853, Level 16, State 1, Line 1
Attribute (object_id=830235054) of row (object_id=830235054,colum n_id=1) in sys.columns does not have a matching row (object_id=830235054) in sys.objects.
Msg 3853, Level 16, State 1, Line 1
Attribute (object_id=830235054) of row (object_id=830235054,colum n_id=2) in sys.columns does not have a matching row (object_id=830235054) in sys.objects.
Msg 3853, Level 16, State 1, Line 1
Attribute (object_id=830235054) of row (object_id=830235054,colum n_id=3) in sys.columns does not have a matching row (object_id=830235054) in sys.objects.
Msg 3853, Level 16, State 1, Line 1
Attribute (object_id=830235054) of row (object_id=830235054,colum n_id=4) in sys.columns does not have a matching row (object_id=830235054) in sys.objects.
Msg 3853, Level 16, State 1, Line 1
Attribute (object_id=830235054) of row (object_id=830235054,colum n_id=5) in sys.columns does not have a matching row (object_id=830235054) in sys.objects.
Msg 3853, Level 16, State 1, Line 1
Attribute (object_id=830235054) of row (object_id=830235054,colum n_id=6) in sys.columns does not have a matching row (object_id=830235054) in sys.objects.
Msg 3853, Level 16, State 1, Line 1
I recall that i was asked to point to a catalog directory. Maybe i picked the wrong directory. Where is this option located? or is there any idea what I can do?
I have an accounting software that keeps shutting off after it is launched. I moved the database manually to a new server.
I installed the accounting software from scratch and the sample company that is default installed is working perfectly.
However when adding the my database it just shuts off.
I ran:
DBCC CHECKDB (MYDATABASE) WITH NO_INFOMSGS, ALL_ERRORMSGS
Here is what I got:
Msg 211, Level 23, State 15, Line 1
Possible schema corruption. Run DBCC CHECKCATALOG.
Msg 0, Level 20, State 0, Line 0
A severe error occurred on the current command. The results, if any, should be discarded.
I ran:
DBCC CHECKCATALOG
I Got:
Msg 3853, Level 16, State 1, Line 1
Attribute (object_id=830235054) of row (object_id=830235054,colum
Msg 3853, Level 16, State 1, Line 1
Attribute (object_id=830235054) of row (object_id=830235054,colum
Msg 3853, Level 16, State 1, Line 1
Attribute (object_id=830235054) of row (object_id=830235054,colum
Msg 3853, Level 16, State 1, Line 1
Attribute (object_id=830235054) of row (object_id=830235054,colum
Msg 3853, Level 16, State 1, Line 1
Attribute (object_id=830235054) of row (object_id=830235054,colum
Msg 3853, Level 16, State 1, Line 1
Attribute (object_id=830235054) of row (object_id=830235054,colum
Msg 3853, Level 16, State 1, Line 1
I recall that i was asked to point to a catalog directory. Maybe i picked the wrong directory. Where is this option located? or is there any idea what I can do?
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
Hi Author,
Does your issue is resolved?
Please update on this.
Does your issue is resolved?
Please update on this.
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
check out this link.
http://sqlskills.com/BLOGS/PAUL/post/TechEd-Demo-Using-the-SQL-2005-Dedicated-Admin-Connection-to-fix-Msg-8992-corrupt-system-tables.aspx
It may helps