Chapter 3

Databases, Files, and Resource Management

Creating and managing databases, files, and their resources are required tasks for many administrators and developers working with SQL Server. Before many things can be accomplished with SQL Server, you must create a database to store database objects. In this chapter, we will focus on planning and creating new databases, understanding the options available for database creation, and maintaining databases and their resources on an ongoing basis.

In this chapter, you will learn to:

  • Create new SQL Server databases
  • Discover information about existing databases
  • Manipulate database files and filegroups
  • Take advantage of database snapshots

Planning a Database

Before we can do anything pertaining ...

Get Mastering SQL Server® 2008 now with O’Reilly online learning.

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