Answer» - Master: It contains framework catalogs that keep data about disk space, record portions, use, system-wide setup settings, LOGIN accounts, the presence of other databases, and the presence of other SQL SERVERS (for appropriate activities). If this database does not exist or corrupted then the SQL Server instance cannot start. Although we user objects in the master database, it is not advised to do so. This database should always remain as static as possible. In the case of a master database being rebuilt, all user objects will be lost.
- Model: It is basically a template database. Each time you make another database, SQL Server makes a duplicate of a model to frame the premise of the NEW database. Any changes made to this database, related DB size, collation, recovery model, and any other configurations, are applied to any new database created afterward.
- Tempdb: Temporary database, tempdb, is a workspace. SQL Server tempdb database is ONE of a kind among every single other database since it is reproduced not recuperated each time SQL Server is started.
- Msdb: This database is utilized by the SQL Server Agent Service, which performs planned exercises, for example, backup and replication assignments.
|
