---
title: "How to rebuild Master Database in SQL?"  
description: "How to rebuild Master Database in SQL?"  
author: "Sumit Kesarwani"  
published: 2014-08-21  
updated: 2020-09-23  
canonical: https://www.mindstick.com/interview/1965/how-to-rebuild-master-database-in-sql  
category: "mssql server"  
tags: ["mssql server"]  
reading_time: 2 minutes  

---

# How to rebuild Master Database in SQL?

Master database is system database and it contains information about running server's configuration. When SQL Server 2005 is installed it usually creates master, model, msdb, tempdb resource and distribution system database by default. Only Master database is th one which is absolutely must have database. Without Master database SQL Server cannot be started. This is the reason it is extremely important to backup Master database.

To rebuild the Master database, Run Setup.exe, verify, and repair a SQL Server instance, and rebuild the system databases. This procedure is most often used to rebuild the master database for a corrupted installation of SQL Server.

## Answers

### Answer by Sumit Kesarwani

Master database is system database and it contains information about running server's configuration. When SQL Server 2005 is installed it usually creates master, model, msdb, tempdb resource and distribution system database by default. Only Master database is th one which is absolutely must have database. Without Master database SQL Server cannot be started. This is the reason it is extremely important to backup Master database.

To rebuild the Master database, Run Setup.exe, verify, and repair a SQL Server instance, and rebuild the system databases. This procedure is most often used to rebuild the master database for a corrupted installation of SQL Server.


---

Original Source: https://www.mindstick.com/interview/1965/how-to-rebuild-master-database-in-sql

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.