SQL Server database list

SQLSever2008 Server System Database List 1. Server instantiation object. 2. master database: records all system-level information of the SQLServer system. Such as Logon account, endpoint, linked server, and system configuration settings. 3. model database: when a new database is created, the content of the model database is copied to create

SQL Sever2008 Server System Database List 1. Server instantiation object. 2. master database: records all system-level information of the SQL Server system. Such as Logon account, endpoint, linked server, and system configuration settings. 3. model database: when a new database is created, the content of the model database is copied to create

SQL Sever2008 Server System database list

1. Server instantiation object.

2. master database: records all system-level information of the SQL Server system. Such as Logon account, endpoint, linked server, and system configuration settings.

3. model database: when a new database is created, the first part of the database is created by copying the content of the model database, and then the remaining part of the new database is filled with blank pages. The model database can be understood as a parent class, and other databases inherit from the model database.

4. It is used by the SQL Server Agent to schedule alarms and jobs and record operators.

5. The ReportServer database is a report database that acts on SQL Server Reporting Services (SSRS for short ).

6. The ReportServerTemp database is a temporary report database.

7. The tempdb database has two purposes: one is used by all users connected to the SQL server instance; the other is to save temporary content, such as temporary user objects.