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.
Join MindStick Community
You need to log in or register to vote on answers or questions.
We use cookies to ensure you have the best browsing experience on our website. By using our site, you
acknowledge that you have read and understood our
Cookie Policy &
Privacy Policy.
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.