Restoring Master Database 2

[mdr227]

I am trying to rebuild a SQL Server install and had a couple of questions.

1. What order should I install the databases (system and user) in?
2. WHen I try to reinstall the master database (after starting in single user mode) it tells me that SQL cannot drop the Master database because it is a system database. Should I drop the Master database manually (and if so how is this best done?) or is there something else that needs to be done?

 

[tlbroadbent]

I'm uncertain what you mean by "trying reinstall the master database." You can restore master from a current backup or rebuild it completely. SQL Books online give the steps to accomplish either task.

1- Restoring the master Database from a Current Backup
2- Rebuilding the master Database

It is preferrable to restore master because rebuilding creates a master datasbase just as it would be when SQL Server was first installed. All objects and settings will be lost so additional steps will be required to complete the restoration. Terry

http://members.home.net/tlbroadbent/index.htm

 

[mdr227]

I am sorry, I actually meant "restore" the Master database and not "reinstall".

 

[tlbroadbent]

Don't try to drop the master database - you can't do it as you found. Rather just issue the restore command.

Use master
go
RESTORE DATABASE master
FROM masterbackup
go



Terry

http://members.home.net/tlbroadbent/index.htm

 

[wrbodine]

What would you do if you want to move the master database from C drive to the D drive? I haven't gotten the restore with move to work yet (while in single user mode)

Any ideas?

Thanks,
Ray

 

[tlbroadbent]

Check the following article for instructions.

http://support.microsoft.com/support/kb/articles/Q224/0/71.ASP

FYI: You should start a new thread rather than add your question to an older archived thread. People are more likely to reply to a new question. This thread has been dormant for nearly 5 months. Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.

 

[wrbodine]

Thanks Terry, and I'll plan on starting a new one next time....

 

[gc]

Hi! Everyone:
we have a sql server 7 on the NT 4. After the crush of NT. we reinstall sql server. we don't have backup the databases in sql server but we have all the databases backup on tape. Now we try to use all these databses including system databases - master, model, msdb, and application databases from tape in the new installed SQL server.
Is anyone can tell me how to do it?
Thank you very much!
george