Microsoft® SQL Server 2000 systems have four system databases:

 
master

    The master database records all of the system level information for a SQL Server system. It records all login accounts and all system configuration settings. master is the database that records the existence of all other databases, including the location of the database files. 

tempdb -

    Tempdb holds all temporary tables and temporary stored procedures. It also fills any other temporary storage needs such as work tables generated by SQL Server. tempdb is re-created every time SQL Server is started so the system starts with a clean copy of the database. 
By default, tempdb autogrows as needed while SQL Server is running. If the size defined for tempdb is small, part of your system processing load may be taken up with autogrowing tempdb to the size needed to support your workload each time to restart SQL Server. You can avoid this overhead by using ALTER DATABASE to increase the size of tempdb. 

model

    The model database is used as the template for all databases created on a system. When a CREATE DATABASE statement is issued, the first part of the database is created by copying in the contents of the model database, then the remainder of the new database is filled with empty pages. Because tempdb is created every time SQL Server is started, the model database must always exist on a SQL Server system. 

msdb

    The msdb database is used by SQL Server Agent for scheduling alerts and jobs, and recording operators. 

 

 

model資料庫:樣版資料庫(template)。
msdb資料庫:儲存系統約定工作(scheduled task)的資料。
pubs資料庫:教學示範。
tempdb資料庫:使用者執行程式時可以在此資料庫上產生暫存表格。

創作者介紹

Frank's Blog

Frank 發表在 痞客邦 PIXNET 留言(0) 人氣()