O'Reilly logo

Microsoft SQL Server 2012 Internals by Bob Beauchemin Kalen Delaney Conor Cunningham, Jonathan Kehayias, Benjamin Nevarez, and Paul S. Randal

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

Understanding database files

A database file is nothing more than an operating system file. (In addition to database files, SQL Server also has backup devices, which are logical devices that map to operating system files or to physical devices such as tape drives. This chapter won’t discuss files used to store backups.) A database spans at least two, and possibly several, database files, which are specified when a database is created or altered. Every database must span at least two files: one for the data (as well as indexes and allocation pages) and one for the transaction log.

SQL Server 2012 allows the following three types of database files.

  • Primary data files. Every database has one primary data file that keeps track of all the rest of the ...

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