It seems like your browser didn't download the required fonts. Please revise your security settings and try again.
Barracuda Yosemite Server Backup

How do I restore a Microsoft SQL Server Master Database with Yosemite Server Backup?

  • Type: Knowledgebase
  • Date changed: one year ago

Solution #00004039



Yosemite Server Backup, version 8.0 and above and associated management domain clients running Microsoft SQL, versions 7 and above. 



The installation of Microsoft SQL Server is composed of several databases. The Master Database is the one which is responsible for maintaining information like login accounts, the pointers to the other databases and so on. Without this database, SQL Server will not start up.


To perform a restore of a Microsoft SQL Master Database with Yosemite Server Backup, you must stop the Yosemite Server Backup Service, and put SQL into Single User Restore Mode. You must also have the correct permissions to the SQL Server Master Database to perform a restore.

  1. Close Yosemite Server Backup Administrator.
  2. Stop the Yosemite Server Backup Service. For details on starting/stopping the Yosemite Server Backup Service, refer to Solution #00004025.
  3. Stop the SQL service using SQL Enterprise Manager.
  4. Open a command prompt, Start > Run > CMD <Enter>, and Initiate Single User Restore Mode by entering the following commands. Leave the window open after executing the command. (Example C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Binn)
    CD \program files\microsoft sql server\<sql version>\mssql\binn
    sqlservr -c -m
      (SQL 7 only)
    sqlservr -c -m -s %<Named Instance>% (SQL 8 only)
  5. Open Yosemite Server Backup Administrator.
  6. Create a restore job, selecting the SQL Master Database (.MDF) file only, and then run the job. For details on creating a restore job, refer to Solution #00004036.
  7. After you are finished using single-user mode, you must remove the -m; before you can restart the server instance in the normal multi-user mode. Close the command prompt when finished.
    CD \program files\microsoft sql server\<sql version>\mssql\binn
      (SQL 7 only)
    sqlservr -s %<Named Instance>% (SQL 8 only) 
  8. Close Yosemite Server Backup Administrator.
  9. Start the Yosemite Server Backup Service.
  10. Restart the SQL Service using SQL Enterprise Manager.

Link to This Page: