SQL Server System databases
Types of system databases Introduction Each time you install any SQL Server instance on a server, by default/automatically 4 primary system databases are created. m aster model msdb tempdb Master database It is a critical database, because SQL Server uses this database to store all the information about SQL Server instance, like · File location of the user database -> If you create any user database all the information and configuration details · Login accounts · Server configuration setting · Link Servers information · Start-up stored procedures If for any reason, master database is not accessible or doesn’t exist or can not be read then the SQL Server instance can not start. It’s important to backup the master database w...