Introduction to the Database list for SQL Server databases

SQL Sever2008 Server System Database list

1.: Server instantiation object.

2. master database: Records all system-level information for the SQL Server system. such as login accounts, endpoints, linked servers, and system configuration settings.

3. Model database: When a new database is created, the first part of the database is created by copying the contents of the model database, and then the remainder of the new database is populated with an empty page. The model database can be understood as a parent class, and other databases are inherited from the model database.

4. Used by SQL Server Agent to schedule alerts and jobs and record operators.

5. The ReportServer database is a reporting database for SQL Server Reporting Services (for short SSRS, a tool for publishing reports).

6, the Reportservertemp database is the interim reporting database.

7. The tempdb database has two uses: one for all users connected to an instance of SQL Server, and two: to save temporary content, such as temporary user objects.