When I attempt to restore a master database I am having some issues. I am using SQL Server 2000. I have set the start up option with -c -m to set the database in single user mode.
When I run the restore from enterprise manager I am get an popup window that is titled "SQL-DMo(odbc SQLSTATE:HY000)" with not message and then the database conection is lost. Thus the master datbase is appears to it was not resotred. As when I close enterprise manager and then restart the MSSQLSERVER service the database is in the same state.
Please advise on how i can get the Database restored.
Enterprise Manager takes up many connections to the server. You need to do the restore of the master database from Query Analyzer without the Object Browser running (hit F8, if it is up). When you use -m, the server is started in Single User mode. Use that single user wisely.