Conclusion
A database is a collection of objects such as tables, views, and stored procedures, and one SQL Server instance can contain many databases. 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 log. You can increase and decrease the size of databases and their files easily, either manually or automatically.
Get Microsoft SQL Server 2012 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.
