If i restore master | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

If i restore master

If i restore master do i need to create a user db before restoring it?
Not necessarily. You can restore a non-existent database and the records will be automatically created in the Master database during the restore.
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. Make sure to take full db backup for all user databases.
During user database restore if any of the h/w configuration changes i.e.,disk drives then use RESTORE…. WITH MOVE option. Refer to BOL for more information. _________
Satya SKJ
Moderator
SQL-Server-Performance.Com
]]>