SQL Server includes the following system databases:
- master - captures all the information about an SQL instance
- msdb - used by SQL Server agent(schedule alerts & jobs)
- model - Database Template for creating new DB
- Resource - read only database, contains system objects which are logically accessed via all the db via sys schema
- tempdb - storage for temporary objects
No comments:
Post a Comment