Types of Databases in MSSQLServer

In MS SQL Server, two types of databases are available.

• System databases
• User Databases

System Databases

System databases are created automatically when we install MS SQL Server. Following is a list of system databases −

1. Master
2. Model
3. MSDB
4. Tempdb
5. Resource (Introduced in 2005 version)
6. Distribution (It’s for Replication feature only)

User Databases

User databases are created by users (Administrators, developers, and testers who have access to create databases).