Microsoft® SQL Server™ 2005 Administrator's Pocket Consultant

Chapter 7. Core Database Administration

In this chapter:

Database Files and Logs

Database Administration Basics

Creating Databases

Altering Databases and Their Options

Managing Database and Log Size

Manipulating Databases

Tips and Techniques

Core database administration tasks involve creating, manipulating, and supporting databases. In Microsoft SQL Server 2005, a database is a collection of data and the objects that represent and interact with that data. Tables, views, stored procedures, triggers, and constraints are typical database objects.

A single database server instance can have up to 32,767 databases, and each database can have more than 2 billion objects. These are theoretical limits, of course, but they demonstrate that SQL Server can handle ...