3.2. Create and Alter Databases

SQL Server stores almost all of its data, indexes, and configurations in databases. When you install a SQL Server instance, you get four systems databases by default. The installer creates these for you automatically.

master

The master database is essentially the master catalog for the entire server instance. It stores all instance-level configuration information and instance-level artifacts such as server logins. You can think of the master database as everything that SQL Server knows about itself.

model

The model database serves as the template for all new user databases that you will create on an instance. When you create a new database, you get a copy of the model database. Adding artifacts such as tables ...

Get SQL Server® 2008 Administration: Instant Reference now with O’Reilly online learning.

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