Chapter 5 -- Database Files

[Previous] [Next]

Chapter 5

About This Chapter

A Microsoft SQL Server database is a collection of information, tables, and other objects used to facilitate searching, sorting, and recombining data. Databases are stored in primary and secondary data files and use log files to ensure data integrity.

This chapter shows how to create databases and discusses ways to manage them, including advanced management techniques that utilize multiple files and disks. Related topics covered in this chapter are the transaction log, database files and filegroups, and techniques for estimating database size requirements.

Before You Begin

To complete the lessons in this chapter you must have

• Installed SQL Server 7. See Chapter 2, "Installation," for installation instructions.
• The ability to log on to SQL Server as an Administrator.
• Installed the Exercise files from the Supplemental Course Materials CD-ROM to your hard disk drive. See Chapter 2, "Installation," for installation instructions.