Re: Master database corrupt.
- From: Erland Sommarskog <esquel@xxxxxxxxxxxxx>
- Date: Thu, 24 Sep 2009 07:30:36 +0000 (UTC)
david (david@xxxxxxxxx) writes:
After our SBS rebooted repeatedly one night due to a faulty
"Uninterruptable" Power Supply, SQL Server isn't working at all. WSUS,
Monitoring, and SharePoint are all down. The SQL error log seems to say
that the master database is corrupt.
How do I fix this? Is there something simple I can restore from backup?
Or a "recreate master database" command?
If you have a backup of the master database, you can restore it. But if
you don't have a good backup of master, well you don't.
But even if you don't have backup of master, this is not the end of the
world. You can rebuild the master database, but you will need to reattch
the databases and recreate logins. Only hope that no user databases have
been hurt!
While this issue might be possible to sort over a newsgroup thread, it
may take some time until you are back in business. It may be better to
open a support case with Microsoft, and have a support professional to
guide you through the process. It's certainly going to cost you and arm
and a leg, but so might having the databases offline as well.
--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.
- References:
- Master database corrupt.
- From: david
- Master database corrupt.
- Prev by Date: Re: SQL CommandTimeOut problem
- Next by Date: stop that happening
- Previous by thread: Master database corrupt.
- Next by thread: SQL CommandTimeOut problem
- Index(es):
Relevant Pages
|
Loading
