How to restore master db in SQL 2005???

[winsys]

I've tried starting SQL from the command line in single user mode (-m). When I try to open Management Studio I receive an error that it can't connect. Can you only restore master from a command line in SQL 2005? Or can I do it from a GUI?

Thanks,
Mark

 

[winsys]

OK, I now tried starting the SQL Server Service form the 'Services' GUI in Windows, using the parameters -c and -m. Now I am able to open Management Studio. When I right-click on the master database and choose 'Tasks-Restore-Database' master is not in the list of databases to restore.
I tried typing it in manually, but the restore failed.

 

[mrdenny]

Restart SQL from the command line using the -m switch.

Connect a query window (not the Object Explorer).

Now run your restore database command.

Master database must be restored via a T/SQL command not via the GUI.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com