restoring master

Are there any special considerations for restoring the master database, or is it just like restoring any other database
TIA
FredTo restore the master database, you need to first start the server in
single-user mode. You can do this from the command-prompt by changing to
the target instance Binn folder and entering the command below. See the
Books Online <coprompt.chm::/cp_sqlservr_4apa.htm> for additional arguments
you may need, like instance name.
sqlservr -c -m
This command will start SQL Server in the command window. You can then
execute your master database restore command using the OSQL command-line
utility or Query Analyzer. When the restore completes, SQL Server will
automatically shutdown and you can then start the service as normal.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Fred" <anonymous@.discussions.microsoft.com> wrote in message
news:B3E3AAA1-5235-4A80-915A-3EE90D796A19@.microsoft.com...
> Are there any special considerations for restoring the master database, or
is it just like restoring any other database?
> TIA,
> Fred|||Hi,
1. Stop SQL Server
2. Execute the following command from a command prompt to start SQL
Serverin single user:
sqlservr -c -m
3. In SQL Server Query Analyzer, use the following to restore a backup of
the master database:
RESTORE DATABASE master FROM disk='d:\backup\master.bak'
WITH MOVE 'master' to 'd:\mssql\data\master.mdf',
MOVE 'mastlog' to 'd:\mssql\data\mastlog.ldf',
REPLACE
go
(Note:- Give the directory and drive letter based on ur setup)
4. SQL Server shuts down automatically after you restore the master
database. Now start the SQL Server
from Control Panel -- Services.
Thanks
Hari
MCDB
"Fred" <anonymous@.discussions.microsoft.com> wrote in message
news:B3E3AAA1-5235-4A80-915A-3EE90D796A19@.microsoft.com...
> Are there any special considerations for restoring the master database, or
is it just like restoring any other database?
> TIA,
> Fred