Summary
A database is a collection of objects such as tables, views, and stored procedures. Although a typical SQL Server installation has many databases, it always includes the following three: master, model, and tempdb. An installation usually also includes msdb, but that database can be removed. (To remove msdb requires a special traceflag and is rarely recommended.) A SQL Server instance also includes the mssqlsystemresource database that cannot be seen using the normal tools. Every database has its own transaction log; integrity constraints among objects keep a database logically consistent.
Databases are stored in operating system files in a one-to-many relationship. Each database has at least one file for data and one file for the transaction ...
Get Microsoft® SQL Server® 2008 Internals now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
