We all know there are some system databases available in our SQL Server.But the purpose of these databases also we should know.
The following databases are available in SQL Server:
- Master
- Model
- msdb
- tempdb
Purpose Of Master Database:
When you create databases or any other objects, information about the objects is maintained inside the master database. The master database contains a set of system tables that track most of the objects on the server.
Purpose Of Model Database:
The model database is used as a template for all new user databases. Users do not use the model database. Template can include specific settings, security constructs and all sorts of useful stuff.
Purpose Of Msdb Database:
The msdb database contains information about tasks, alerts, and operators for both user-defined tasks and tasks related to replication.If the MSDB database is corrupted or damaged then scheduling information used by SQL Server Agent will be lost. This will result in the failure of all scheduled activities.
Purpose Of Tempdb Database:
The TempDB is recreated every time when ever SQL Server restarts. It stores all the temporary objects such as temporary tables, global temporary tables, temporary stored procedures, cursors, table variables information. You cannot take the the backup and recovery operation in TempDB database.
