Sobes.tech
Middle

What system databases are available in MS SQL Server?

sobes.tech AI

Answer from AI

In MS SQL Server, there are several system databases that ensure the operation of the server and data management:

  • master — stores information about the server configuration, all databases, logins, settings, and other system objects.
  • model — a template for creating new databases. When a new database is created, the contents of model are copied.
  • msdb — used for managing SQL Server Agent jobs, schedulers, backups, and restores.
  • tempdb — a temporary database for storing temporary tables, table variables, cursors, and intermediate results.
  • Resource (hidden) — contains system objects and is used for updating system tables without overwriting.

These databases ensure the stable operation of the server and resource management.