Back to Blog
Sql server rebuild master database5/16/2023 NOTE: If you have another backup solution like Data Protection Manager there is a more easy way o restore SQL backup. Now remove – m flag services from the SQL Server and restart the SQL server to return to the multi-client mode. After doing this, you will be able to restore the master database backup easily ĥ. But, if you have a public connection, then use the – U and – P flags Ĥ. Use the – S flag for a private connection. Navigate to …/Tools/Bin directory and look for sqlcmd.exe Ģ. Use the command line in SQL Server Management Studio to restore your SQL server master database from the backup.ġ. Type – m in the Specify the startup parameter text box and click the Add button. After that select the startup parameters tab Ĥ. Right-click the SQL Server service and click on Properties ģ. Run the SQL Server Configuration Manager Ģ. Restoring the master database from the SQL server or another backup solution.ġ.
0 Comments
Read More
Leave a Reply. |