Master: System tables, System and Information_Schema Views, All extended and system-stored procedures
Model: A template db, Any new database created has to be at least as large as the model database, Default 100 MB Size
MSDB: SQL Agent process stores, Jobs, Schedules related information, SSIS packages
and policy-based management definitions
Tempdb: Temporary db, the key working areas for your server, temporary storage of a large/complex sql, Consist local and global temporary tables (temp table is just an alias of table in current db, physically its available in tempdb), tempdb rebuilt from scratch every time you start your SQL Server.
ReportServer: The database that serves Reporting Server confi guration and model storage needs
ReportServerTempDB: The working database for Reporting Server
No comments:
Post a Comment