O'Reilly logo

Microsoft® SQL Server™ 2005 Administrator's Companion by Victor Isakov, Stacia Misner, Burzin Patel, Marcilina Garcia, Edward Whalen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Understanding System Databases

Every SQL Server 2005 instance contains five system databases—master, model, msdb, tempdb, and resource—that are used for the server initialization, housekeeping, and temporary storage required for application data. In addition, SQL Server 2005 also optionally installs two sample databases: AdventureWorks and AdventureWorksDW. The purpose of all these databases is described in the sections below.

master

The master is by far the most important system database in SQL Server 2005. It contains a set of system tables that serve as a central repository for the entire instance and maintaining information about login accounts, other databases, file allocations, system configuration setting, disk space, resource consumptions, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required