Re: Cannot recover the master database.
From: Steve Lin (lins_at_nospam.portptld.com)
Date: 04/05/04
- Next message: Joe: "Use SQL Server Agent to schedule for the execution of DTS package"
- Previous message: Steve Lin: "Re: Disaster/recovery techniques"
- In reply to: Daniela: "Cannot recover the master database."
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 5 Apr 2004 15:17:40 -0700
i hope you been backing up your system database regularly. if you don't. you
are in trouble.
you can't restore a corrupt master.mdb thru GUI.
-- to exclusive use the master database (to restore)
/* start the server in exclusive mode
>From a command prompt (the dos prompt, get to the c:\mssql7\binn directory
(adjust accordingly for sql2k), enter:
sqlservr.exe -c (standard)
sqlservr -m (exclusive)
restore master db from the last known good backup
stop server and re-start in normal mode
*/
once the master is restored. you can use Enterprise Manger GUI to restore
the last known good copy of msdb.
Steve Lin
MCDBA
"Daniela" <daniela@perfilcs.com.br> wrote in message
news:257101c41b18$e6f5f3e0$3a01280a@phx.gbl...
>
> Hi,
>
> In my computer when sql is starting occur the follow
> message in log :
> - Error: 9003, Severity: 20, State: 1.
> - Cannot recover the master database.
>
> What I do? Why this happened?
>
> Thanks,
>
> Daniela
>
- Next message: Joe: "Use SQL Server Agent to schedule for the execution of DTS package"
- Previous message: Steve Lin: "Re: Disaster/recovery techniques"
- In reply to: Daniela: "Cannot recover the master database."
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
