|
 |
About Us | |
|
SSWUG Articles | |
 |
Articles | |
|
FAQ |
|
Administration | |
 |
Backup/Restore | |
|
Connectivity | |
|
Development | |
|
General | |
|
Installation | |
|
OLAP | |
|
Replication | |
|
Transfer/move | |
|
Trouble | |
|
SQL 6.5 |
|
Scripts | |
|
Tips | |
|
Test Exams | |
|
Advertise | |
|
Download | |
|
History | |
|
Search | |
|
Traffic | |
|
Related Links | |
|
||
|
|
||
 How do I restore the master database? It tell me that I should be in the single user mode, but there is no such db option for the master database. Answer: Yes, there is no such database option for the master database. There is SQL Server configuration option. You need to run SQL Server in the single-user mode. Try the following: 1. Stop MSSQLServer and SQLServerAgent services. 2. From a command prompt, enter this command: sqlservr.exe -m 3. Run Enterprise Manager to restore the master database from the backup. |