O'Reilly logo

Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition by Mark Spenik, Orryn Sledge

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

A Database Primer

The following sections discuss the fundamental terminology and concepts necessary to manage a SQL Server database.

What Is a Database?

A database is an organized collection of data (see Figure 8.1). This collection of data is logically structured and systematically maintained. SQL Server extends the concept of a database by allowing you to create and store other types of objects, such as stored procedures, triggers, views, and other objects that interact with your data.

Figure 8.1. A database.

What Is the Transaction Log?

The transaction log is the history of data modifications to a database (see Figure 8.2). Whenever you create ...

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