Search:     Advanced search
Browse by category:
C/C++   |   Java   |   Oracle/Database   |   SAP   |   ASP .NET   |   Mainframe-DB2   |   Freshers

How to rebuild Master Databse?

Add comment
Views: 53
Votes: 0
Comments: 0

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 the 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.
Others in this Category
document What is Difference between Function and Stored Procedure?
document Q: Explain the concept of NULL
document What is PIVOT and UNPIVOT?
document What is DataWarehousing?
document When is the use of UPDATE_STATISTICS command?
document What is Row_Number()?
document How to find tables without Indexes?
document What are the Advantages of using CTE?
document What is De-normalization?
document Q: What is a join ? Explain the different types of joins ?
» More articles



RSS