SQL Server error

I have a dell R710 server (Windows server 2008 Standard with MS SQL Server 2008) that had a hard drive fail.
I received a replacement hard drive and attempted to let the raid 0 array rebuild itself, but it kep failing.
I replaced both raid HDD's and restored from a Simplified Disaster Recovery backup from Backup Exec.
The server is back up and running (partially).
I am unable to get the MSSQLSERVER instance running because I get error messages about the master database being corrupt.

event id: 3417
Cannot recover the master database. SQL Server is unable to run. Restore master from a full backup, repair it, or rebuild it. For more information about how to rebuild the master database, see SQL Server Books Online.

I have tried to rebuild the database with (etup /ACTION=REBUILDDATABASE /QUIET /INSTANCENAME=<instance name> /SQLSYSADMINACCOUNTS=<accounts>) , but it fails.

Any suggestions?
MBischAsked:
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.

MBischAuthor Commented:
Also getting the following error

EVENT ID: 912
Script level upgrade for database 'master' failed because upgrade step 'msdb_upgrade_discovery.sql' encountered error 945, state 2, severity 14. This is a serious error condition which might interfere with regular operation and the database will be taken offline. If the error happened during upgrade of the 'master' database, it will prevent the entire SQL Server instance from starting. Examine the previous errorlog entries for errors, take the appropriate corrective actions and re-start the database so that the script upgrade steps run to completion.
0
Marten RuneSQL Expert/Infrastructure ArchitectCommented:
Do you have a backup?
If so, the master has the server collation, the databases, and users.

a fairly recent backup should be ok. Restoring is not that straightforeward though.

this: http://technet.microsoft.com/en-us/library/ms190679.aspx
is how you do it.

Regards Marten
0
MBischAuthor Commented:
I have a full backup that was completed using Symantec Backup Exec.
I have tried to restore the whole server and I am getting this error.
I also have a complete backup of the SQL database but cannot restore the master database unless i can connect to SQL on this machine.
0
Making Bulk Changes to Active Directory

Watch this video to see how easy it is to make mass changes to Active Directory from an external text file without using complicated scripts.

Marten RuneSQL Expert/Infrastructure ArchitectCommented:
Will it start in minimal configuration mode?
http://technet.microsoft.com/en-us/library/ms186400(v=sql.100).aspx

//Marten
0
MBischAuthor Commented:
I was able to get the SQL Server going again by restoring the MSDB database to a different SQL Server (with an alternate filename).
After it was restored to the alternate SQL Server, the Database was copied over to the problem SQL Server  and renamed it to the MSDB.
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
Marten RuneSQL Expert/Infrastructure ArchitectCommented:
Now you have your SQL up and running.
You MUST run the DBCC CHECKDB on all user databases. They might be broken to, but you wont see that directly as you do with the system databases.
Regards Marten
0
MBischAuthor Commented:
MSDB was missing.
restoring that database fixed the issue.
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 2008

From novice to tech pro — start learning today.