Windows 2019
Sponsored Link

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