O'Reilly logo

Mastering SQL Server® 2008 by Gentry Bieker, Michael Lee

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required