A brief introduction to the five system databases in SqlServer

This article brings you a brief introduction to the five system databases in SqlServer. It has certain reference value. Friends in need can refer to it. I hope it will be helpful to you.

There are five system databases in SqlServer. I usually don’t pay much attention to them when writing code, but I studied them on a whim today.

1. master

Records all system-level information of the SQL Server system, such as: login account information, linked server and system configuration settings, Record the existence of all other databases, the location of data files, SQL Server initialization information, etc. If the master database is not available, SQL Server cannot be started.

2.msdb

is used for SQL Server Agent scheduled alerts and jobs. The database regularly performs certain operations, database emails, etc.

3.model

is used as a template for all databases created on the SQL Server instance. Modifications made to the model database (such as database size, collation, recovery model, and other database options) will apply to all future databases created. Create a table in the model database, and every time you create a database in the future, there will be the same table by default.

4.tempdb

A workspace used to save temporary objects or intermediate result sets. A global resource available to all users connected to an instance of SQL Server. tempdb is re-created every time SQL Server is started.

##5.resource

A read-only database that contains system objects included in SQL Server . System objects reside physically in the Resource database but appear logically in each database's sys schema. The physical file names of the Resource database are mssqlsystemresource.mdf and mssqlsystemresource.ldf. These files are located in :\Program Files\Microsoft SQL Server\MSSQL10_50.\MSSQL\Binn\. Each SQL Server instance has one (and only one) associated mssqlsystemresource.mdf file, and this file is not shared between instances

The above is the detailed content of A brief introduction to the five system databases in SqlServer. For more information, please follow other related articles on the PHP Chinese website!