The SQL Server installer has an option to repair the database. This option will allow you to repair the SQL Server database, including the master database. To use this option, follow these steps:<\/p>
- \n
- Run the setup.exe in your SQL Server installer folder.<\/li>\n<\/ul>\n
![\"Image](\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/02\/setup-exe.png\")
<\/figure>\n<\/div>- \n
- Go to Maintenance <\/strong>and select the Repair<\/strong> option.<\/li>\n<\/ul>\n
![\"Image](\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/02\/Repair-sql-installation-1024x773.png\")
<\/figure>\n<\/div>- \n
- Select the instance to repair and press Next<\/strong>.<\/li>\n<\/ul>\n
![\"Image](\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/02\/server-instance-in-repair.png\")
<\/figure>\n<\/div>- \n
- Finally, press the Repair<\/strong> button.<\/li>\n<\/ul>\n
![\"Image](\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/02\/ready-to-repair.png\")
<\/figure>\n<\/div>Restore the Master Database<\/strong><\/h2>
If you have a backup of the database, you can use it to restore the database. However, the master database is a special database and it cannot be restored as other databases. You need to first run the SQL Service in single-user mode. To do this, open the SQL Server Configuration Manager.<\/p>
- \n
- Go to SQL Server Services <\/strong>and select the Service instance that you want to work with. Right-click the instance and click Stop<\/strong>.<\/li>\n<\/ul>\n
![\"Image](\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/02\/Stop-SQL-Server-1024x504.png\")
<\/figure>\n<\/div>- \n
- Right-click the instance again and select Properties.<\/strong><\/li>\n<\/ul>\n
![\"Image](\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/02\/SQL-Server-properties-in-config-manager.png\")
<\/figure>\n<\/div>- \n
- Go to the Startup Parameters<\/strong>, specify the -m<\/strong> parameter, and press the Add <\/strong>button.<\/li>\n<\/ul>\n
![\"Image](\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/02\/startup-parameters.png\")
<\/figure>\n<\/div>- \n
- Here, -m<\/strong> is used to set the instance to single-user mode.<\/li>\n<\/ul>
Optionally, you can use the -f start option to set the instance with minimal configurations.<\/p>
If you prefer to set the SQL Server instance in single-user mode using the command line, run the following commands.<\/p>
NET STOP MSSQLSERVER<\/code><\/pre>NET START MSSQLSERVER \/m<\/code><\/pre>The first line is to stop the SQL Server. Use the correct SQL Server instance name. Here, MSSQLServer is used as an example.<\/p>
The second line will start the SQL Server instance in single-user mode.<\/p>
Once the database is in single-user mode, you can connect with the SQLCMD and restore the database by using the following command:<\/p>
SQLCMD -S MSSQLServer -E -d master<\/code><\/pre>Here, MSSQLSERVER is the server’s name, -E is to connect with Windows Authentication, -S is to provide the instance name, and -d is to specify the database to connect.<\/p>
Finally, run the below restore command to restore the database.<\/p>
restore database master from disk = 'c:\\stellarbackups\\master.bak' with replace;<\/code><\/pre>Rebuild the Master Database<\/strong><\/h2>
There is an option to rebuild the database using the command line. In the SQL Server installer, look for the setup.exe and run the following command:<\/p>
setup \/QUIET \/ACTION=REBUILDDATABASE \/INSTANCENAME=MSSQLServer \/SQLSYSADMINACCOUNTS=sa \/SAPWD= MyP983”#3 \/SQLCOLLATION=Latin1_General_CI_AS<\/code><\/pre>Here, MSSQLServer is the instance name, SQLSYSADMINACCOUNTS is the system administrator user, SAPWD is the password, and CollationName is the collation used.<\/p>
An Alternative Solution to Repair and Restore SQL Database<\/strong><\/h2>
Another solution is to use a third-party SQL database repair tool, such as Stellar Repair for MS SQL<\/a>. This software can repair corrupt SQL server databases. The MDF and NDF files are used to store the information. This software restores these files if they are corrupted. This software is compatible with all SQL Server versions. The software is intuitive and simple to use. Just follow the below steps:<\/p>
- \n
- Launch the software and browse to the location of the master database file. To know the master database location, you can use the Find button in the application.<\/li>\n<\/ul>
- Here, -m<\/strong> is used to set the instance to single-user mode.<\/li>\n<\/ul>
- Go to the Startup Parameters<\/strong>, specify the -m<\/strong> parameter, and press the Add <\/strong>button.<\/li>\n<\/ul>
- Right-click the instance again and select Properties.<\/strong><\/li>\n<\/ul>
- Go to SQL Server Services <\/strong>and select the Service instance that you want to work with. Right-click the instance and click Stop<\/strong>.<\/li>\n<\/ul>
- Finally, press the Repair<\/strong> button.<\/li>\n<\/ul>
- Select the instance to repair and press Next<\/strong>.<\/li>\n<\/ul>
- Go to Maintenance <\/strong>and select the Repair<\/strong> option.<\/li>\n<\/ul>
![\"Image](\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/02\/find-database.png\")
<\/figure>\n<\/div>![\"Image](\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/02\/repair-database.png\")
<\/figure>\n<\/div>![\"Image](\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/02\/Stop-SQL-Server-1-1024x504.png\")
<\/figure>\n<\/div>