During SQL Server installation, databases master, tempdb, and msdb are created.
master: Records all of the system level information for a SQL Server system, that is, all loginaccounts, system configuration settings, existence of all other databases and the location of the
primary files.
msdb: Used by SQL Server Agent for scheduling alerts and jobs, e.g. regular backups.
tempdb: Contains all temporary tables and is re-created every time SQL Server is started.
Temporary tables are automatically dropped at disconnect, and no connections are active when
the system is shut down.
No comments:
Post a Comment