Re: Can't restore master db!!
From: Hari Prasad (hari_prasad_k_at_hotmail.com)
Date: 08/02/04
- Next message: Nags: "Re: tempdb full. When do you get this error ?"
- Previous message: Aaron [SQL Server MVP]: "Re: tempdb full. When do you get this error ?"
- In reply to: Cathy Finnegan: "Can't restore master db!!"
- Next in thread: Keith Kratochvil: "Re: Can't restore master db!!"
- Reply: Keith Kratochvil: "Re: Can't restore master db!!"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 2 Aug 2004 20:51:32 +0530
Hi,
To restore the master database you have start the SQL server itself in
Single user mode.
1. Stop the MSSQL server and sql agent service
2. Go to command prompt and execute below command,.
sqlservr.exe -c -m
3. Login to sql server using query analyzer and retore the master database.
4. After the restore .. go to old comamnd prompt and press CONTRL and C to
close the old session
5. Go to control panel and start the MSSQL server and Sql agent service.
Note:
I recommend you to restore the master database first followed with other
databases.
Thanks
Hari
MCDBA
"Cathy Finnegan" <eliminates_spam_caeriel1@cablespeed.com> wrote in message
news:jamsg0tqoig5fqs15kdonltvlitoiktf3u@4ax.com...
> Hi:
>
> I've got a problem that's causing me headaches! I'm using Veritas Backup
Exec to perform my db backups. I've just
> recently taken over the DBA responsibilities and one of the first things
I've wanted to do is test those backups since
> we've never had occassion to use the backups. I have a test system that
I'm using and have it configured exactly as the
> production system.
>
> After installing MS SQL Server 7 putting on SP4 and all the security
patches I try to restore all the databases. I can
> get all my databases restored except the master db that contains all my
security info. I keep getting the message
> "must be in single user mode". I've tried to set the master db into
single user mode and there's just no way to do it!!
> I've tried using the EM and the sp_dboption. Without that master db
restored I'm in deep doo-doo!
>
> Any ideas how I can handle this?? Any help/suggestions is greatly
appreciated.
>
> TIA
>
> Cathy
>
> SQL Server 7( SP4), NT4.0
- Next message: Nags: "Re: tempdb full. When do you get this error ?"
- Previous message: Aaron [SQL Server MVP]: "Re: tempdb full. When do you get this error ?"
- In reply to: Cathy Finnegan: "Can't restore master db!!"
- Next in thread: Keith Kratochvil: "Re: Can't restore master db!!"
- Reply: Keith Kratochvil: "Re: Can't restore master db!!"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
