Chapter 5. SQL Server 2008 Databases

The database is the heart of SQL Server 2008, handling everything from storing user information for later retrieval to acting as a temporary storage area for SQL Server operations. Previous chapters discussed the SQL Server installation process and the internal structure of all the files that make up a SQL Server 2008 database. This chapter delves into creating user databases and the various options that can be configured on them.

System Databases

As mentioned in Chapter 1, when SQL Server 2008 is installed, five system databases are created to store system information and support database operations. Four of the system databases (master, model, msdb, and tempdb) are visible during normal database operations, but the fifth (the resource database, as described in Chapter 4) is not. Distribution databases can also be created if the SQL Server instance is configured as a distributor for SQL Server Replication.

User Databases

User databases are those databases that are created by any server login that possesses the appropriate permissions. In past versions of SQL Server, you had the option to install the AdventureWorks2008 sample databases that were briefly described in Chapter 1, but this ability has since been removed from the product. You can download the AdventureWorks2008 sample database and code samples from the "Microsoft SQL Server Community Projects and Samples" located at

Database Planning

One of the key responsibilities ...

Get Beginning, Microsoft® SQL Server® 2008 Administration now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.