Re: Cannot recover the master database.
From: Bob Simms (bob_simms_at_somewhere.com)
Date: 04/05/04
- Next message: Dennis Passmore: "DBPROPSET-> ?????"
- Previous message: Nags: "Re: Move a file"
- In reply to: Daniela: "Cannot recover the master database."
- Next in thread: Steve Lin: "Re: Cannot recover the master database."
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 5 Apr 2004 19:53:43 +0100
"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?
>
To fix a corrupted master database run rebuildm.exe. This will destroy your
master, msdb and modle databases and replace them with blank ones. Then
restore your master, msdb and model backups.
Erm... You do have a backup of your system databases, don't you?
If not, then after rebuildm.exe you'll have to execute sp_attach_db or
sp_attach_single_file_db to repopulate your sysdatabases table in Master.
Also you will have to recreate your SQLAgent jobs etc if you do not have a
MSDB backup
--- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.647 / Virus Database: 414 - Release Date: 29/03/2004
- Next message: Dennis Passmore: "DBPROPSET-> ?????"
- Previous message: Nags: "Re: Move a file"
- In reply to: Daniela: "Cannot recover the master database."
- Next in thread: Steve Lin: "Re: Cannot recover the master database."
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
