?
Solved

MSSQL Database Keeps Shutting Off

Posted on 2010-11-08
5
Medium Priority
?
466 Views
Last Modified: 2012-05-10
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,column_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,column_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,column_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,column_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,column_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,column_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?
0
Comment
Question by:FTGE
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
5 Comments
 
LVL 29

Accepted Solution

by:
Michael Pfister earned 2000 total points
ID: 34091435
You may want to give
DBCC CHECKDB (yourDB,  REPAIR_REBUILD)
a try.
The best option is to do a restore from a good backup.
0
 
LVL 19

Expert Comment

by:Bhavesh Shah
ID: 34091479
0
 
LVL 19

Expert Comment

by:Bhavesh Shah
ID: 34221905
Hi Author,

Does your issue is resolved?
Please update on this.
0
 
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 36032513
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0

Featured Post

Fill in the form and get your FREE NFR key NOW!

Veeam® is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Recently, Microsoft released a best-practice guide for securing Active Directory. It's a whopping 300+ pages long. Those of us tasked with securing our company’s databases and systems would, ideally, have time to devote to learning the ins and outs…
What we learned in Webroot's webinar on multi-vector protection.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…

718 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question