MBisch
asked on
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=<acco unts>) , but it fails.
Any suggestions?
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=<acco
Any suggestions?
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
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
ASKER
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.
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.
Will it start in minimal configuration mode?
http://technet.microsoft.com/en-us/library/ms186400(v=sql.100).aspx
//Marten
http://technet.microsoft.com/en-us/library/ms186400(v=sql.100).aspx
//Marten
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
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
ASKER
MSDB was missing.
restoring that database fixed the issue.
restoring that database fixed the issue.
ASKER
EVENT ID: 912
Script level upgrade for database 'master' failed because upgrade step 'msdb_upgrade_discovery.sq