What is System Databases? What are the use of System database? What is Master database & their usage

Microsoft has developed a relational database management system (RDBMS) which is MS SQL Server. MS SQL Server is designed & developed to manage large volumes of data which is suitable for small businesses to large organizations.

In MS SQL Server, two types of databases are there:

1. System Databases and

2. User Databases.

System Databases:

System databases are important databases & they are automatically created during MS SQL Server installation. System databases store server information.

There are four main system databases in MS SQL Server but 2 other DBs are also available:

Master Database:-

1. The master database is one of the system databases and keeps details of MS SQL Server instances, system-level information, metadata, logins, and configurations.

2. If the Maser database is not online or up. SQL server service will not start.

3. The Recovery Mode of the master database is Simple, hence we can’t take the T-Log backup of this database.

4. The master is the first database; hence the ID of this database is 1.

5. Never store the master database-related files on the C drive.

6. We can't add files or file groups.

7. We can't change the database owner of the master database from SA to any other.

8. We can't drop the master database.

9. We can't set the database to OFFLINE.

10. We can't set the database or primary file group to READ ONLY.

11. We can't enable CDC (Change Data Capture) on the master database.

12. The master database will not be a part of mirroring or log shipping.