Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

In what circumstances should I restore the MS SQL Server ‘master’ database?

April 26, 2017circumstances database MS restore SQL Server

0

Posted

In what circumstances should I restore the MS SQL Server ‘master’ database?

2 Answers

0

Posted

You need to restore the `master’ database if you are doing the following: a. Rebuilding all your databases from scratch b. Changing any server-wide or database configuration options c. Added logins or other login security-related operations d. Created or removed logical backup devices e. Configured the server for distributed queries and remote procedure calls such as adding linked servers or remote logins. There is no need to restore your master database, if you just want to restore a user database. For more information on Microsoft SQL Server Master Database, please visit http://www.microsoft.com/sql/.

0

Posted

You need to restore the `master’ database if you are doing the following: a. Rebuilding all your databases from scratch b. Changing any server-wide or database configuration options c. Added logins or other login security-related operations d. Created or removed logical backup devices e. Configured the server for distributed queries and remote procedure calls such as adding linked servers or remote logins.