May 2010
Intermediate to advanced
815 pages
21h 55m
English
book
SQL Server® 2008 Administration: Real World Skills for MCITP Certification and Beyond
by Tom Carpenter
Content preview from SQL Server® 2008 Administration: Real World Skills for MCITP Certification and BeyondBecome an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
SQL Server Databases
SQL Server is a database management system, so it's essential that the DBA understand the types of databases it supports. Two broad categories exist. First, you have the system databases, which are used by SQL Server and the SQL Server services and functions. Second, you have the user databases, which are used to store the intentional data—the data for which you've implemented SQL Server in the first place. This section discusses both.
System Databases
Four system databases exist in SQL Server 2008, and this is unchanged from previous versions. The system databases contain configuration information about the SQL Server services and the various user databases, which are attached to the database server. The system databases ...