There are four system databases in SQL Server
- Master DB
- Master Stores Metadata for all user databases. (i.e stores information about all user databases and objects under it like Tables, Indexes etc.)
- It is the main system database.
- One master per Instance.
- Model DB
- Model DB is used as a template database while creating a new DB.
- MSDB
- Stores information related to SQL Server Jobs and Schedules.
- Database Backups.
- Database Mail Configuration.
- Temp DB
- Used to save Temporary Data.
- Transactions on TempDB are not logged in any logging mode.
- Recreated everytime system restarts.
No comments:
Post a Comment