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.


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.


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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.