SQL Server 2005 won't start

My SQL Server on a VM suffered some hard drive failures.  After restoring the RAID array, I'm able to start the OS, but I can't get SQL server to start.  I still get event ID 824 in the event logs.  I can't run DBCC CheckDB because I can't connect to the SQL DBs.  Is there a way to run DBCC... from a command prompt or something?  I also went through so many other posts, but I can't get anywhere on starting the SQL Server service to run.  Any help will be appreciated!
parkerOneAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

arnoldCommented:
You would need to use isq/osql command line tool to check.

A filesystem backup is insufficient method to backup SQL unless SQL server is not running while the backup/image is taken. If SQL is running when the backup image is taken it will have the issue as you see it.


Do you have good backups of the system and user DBS prior to this issue?

https://msdn.microsoft.com/en-us/aa337274.aspx
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Deepak ChauhanSQL Server DBACommented:
@but I can't get SQL server to start?

DBCC is an SQL consol command Windows OS does not recognise it. You can run this command only when sql server services are running.

You are getting error 824 it means corrupt database files or corruption in disk.
If you can you share the event log for error 824. Did you check for which database you are getting this error like Master\Model\TempDB.

If master is corrupted then service would not start in this case you have to rebuild the master and restore it from the last one good backup.

If Model is corrupted and Master is good in this case service will start but crashed immediately because TempDB can not be created in absence of Model database.

We can suggest further accordingly on the basis of message logged for the event 824.
0
parkerOneAuthor Commented:
I would've tried this, but due to time constraints, I went ahead and uninstalled SQL server.  Attaching wasn't a problem (I thought it would be that's why I kept trying to get master to work) I guess since it's the same server name and file locations.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2005

From novice to tech pro — start learning today.

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.