Restore Master Database in SQL Server 2000 -- sql server new users

Robertwsu
7/26/2005 4:12:25 PM

I am attempting to restore the master database in SQL Server 2000. However,
I continually receive the message:

"You are attempting to overwrite an existing database. Check the force
restore over existing database option to overwrite the existing database."

I have started SQL Server in single user mode.

Selected the Master Database task for database restore.

Selected the restore file from device.

In the options tab, I make sure to check force restore over existing
database AND Leave database operational.

I am running Win2k SP4 and SQL 2erver 2000 SP4.

Why do I continue to receive the message to check the force restore when I
have checked the option.

Please help and thank you in advance,

Robert

Hari Prasad
7/27/2005 12:00:00 AM

Hi,

Try the below steps:-

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 restore 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.

Thanks
Hari
SQL Serer MVP

[quoted text, click to view]

sql server new users : Restore Master Database in SQL Server 2000