Re: Master Database is corrupted.

Hi,

Go thru the below article, this gives you the step by step GUI process to
rebuild the master database using rebuildm.exe. This
will also detail the steps to restore the old backup.

http://www.dbarecovery.com/restoremasterdb.html



Thanks
Hari
SQL Server MVP

"Ryan" <Ryan@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:E9743F39-11C0-41B5-8815-FC6A1B79DD80@xxxxxxxxxxxxxxxx
> I'm having a problem on the PC where MSDE is installed. The SQLServer
> can't
> start when OS starts.
>
> - When I check the "Auto-start service when OS starts" checkbox in the SQL
> Server Service Manager window, the checkbox is checked.
> - When I check the logs in the SQLServer folder, it says "Cannot recover
> master database. Exiting."
>
> My questions are:
> 1. Am I right in saying that the master database is indeed corrupted?
> 2. What would be the cause why master databases get corrupted?
> 3. How can I fix this problem, and ensure it won't happen in the future?
>
> Also, if you have any links of websites that address the questions above,
> kindly post them too.
>
> Thanks a lot.


.

Relevant Pages

  • Re: Cross database granting
    ... Just create a user in the master database for your login and then grant EXEC ... Tibor Karaszi, SQL Server MVP ... > Chris Buys ...
    (microsoft.public.sqlserver.programming)
  • Re: Mismatch between sysaltfiles and sysaltfiles
    ... It sound a bit scary to me, so I'd open a case with MS support to make sure that ... Tibor Karaszi, SQL Server MVP ... > sysaltfiles table in the master database for a datafile ...
    (microsoft.public.sqlserver.server)
  • Re: Quickest way to change Collation of Master DB?
    ... If you want to change the collation of the master database, you must rebuild ... you must export the login information before you ...
    (microsoft.public.sqlserver.setup)
  • Re: Quickest way to change Collation of Master DB?
    ... > If you want to change the collation of the master database, ... When you rebuild the master database, ... you must export the login information before ...
    (microsoft.public.sqlserver.setup)
  • Re: can no longer add new logins
    ... > Seems like the transaction log of the Master database is not available - ... Then restore the master database from the last valid backup. ... > Dejan Sarka, SQL Server MVP ... and all of a sudden I can't add new logins. ...
    (microsoft.public.sqlserver.security)