What are the default databases in SQL Server

Article for: MySQL

On every SQL Server instance there is a number of default system databases. Those are"

  • master - keeps the information for an instance of SQL Server.
  • msdb - used by SQL Server Agent.
  • model - template database copied for each new database.
  • resource - read only database that keeps system objects that are visible in every database on the server in sys schema.
  • tempdb - keeps temporary objects for SQL queries.

View in SSMS.

Comments are only visible when the visitor has consented to statistics cookies. To see and add comments please accept statistics cookies.
There are no comments. Click here to write the first comment.