Restore of a Master DB

SQL 7.0, SQL 2000 and SQL 2005 items
Darco
Site Admin
Posts: 80
Joined: Tue Jan 09, 2007 10:03 pm

Restore of a Master DB

Postby Darco » Tue May 01, 2007 12:46 pm

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.

:?:

User avatar
daniel
Site Admin
Posts: 237
Joined: Tue Jan 09, 2007 9:54 pm
Contact:

Postby daniel » Tue May 01, 2007 12:47 pm

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.


Return to “SQL”

Who is online

Users browsing this forum: No registered users and 1 guest