System database of SQL Server 2000

System database of SQL Server 2000

After the SQL Server 2000 Server is installed, four system databases are created. They are master, model, MSDB, and tempdb.
1. master database
The master database is the most important database in SQL Server 2000. It records the server-level system information of SQL Server 2000, including all accounts and passwords, disk space, file allocation and usage, system-level configuration parameters, initialization information, and other database information. Since the importance of the master database to SQL Server 2000, it is recommended that you do not directly modify it, it can be executed through the system stored procedures.
2. model database
The model database stores templates for all user databases and tempdb databases. It contains the system tables to be copied to each user database.
3. MSDB Database
MSDB databases are mainly used by the SQL Server 2000 proxy service for replication, task scheduling, and alarm management.
4. tempdb Database
The tempdb database is a temporary database that provides space for all temporary tables, stored procedures, and other temporary operations. SQL Server 2000 restarts the tempdb database. That is to say, the data in the tempdb database is temporary, and each restart will lead to the loss of previous data.