SQL Server 2019 : System Databases2020/01/30

There are two type of Databases on SQL Server, one is System Database, other is User Database.

User Databases are the common one users can use.

System Databases are created automatically by System and there are 5 System Databases like follows. (one is Hidden database)

System Database	Description
master	Records all the system-level information for a SQL Server system
msdb	Used by SQL Server Agent for scheduling alerts and jobs and by other features
model	Used as the template for all databases created on an instance of SQL Server
tempdb	Global resource that is available to all users connected to the instance of SQL Server or connected to SQL Database
resource	Read-only database that contains all the system objects that are included with SQL Server

Matched Content