Database

There are two types of database in SQL Server.

1.       System Database
2.       User Databases

System databases are default database which are mandatory to start SQL Engine services and user DB get created by SQL user for application use.

System Databases

Master
 Records all the system-level information for an instance of SQL Server.

Msdb
Used by SQL Server Agent for scheduling alerts and jobs.

Model
Used as the template for all databases created on the instance of SQL Server.

resource DB
A read-only database that contains system objects that are included with SQL Server. System objects are physically persisted in the Resource database, but they logically appear in the sys schema of every database.

Tempdb
A workspace for holding temporary objects or intermediate result sets.

User Database 
The DB created by SQL users called user database. Any user DB having 3 types of files.

o    Primary Files
o    Secondary Files
o    Transaction Log Files 

Database Filegroup

<-Back---Next->