Conclusion
Although a typical SQL Server installation has many databases, it always includes the following three: master, model, and tempdb. An installation also includes msdb, but that database can be removed. (Removing msdb requires a special traceflag and is rarely recommended.) A SQL Server instance also includes the mssqlsystemresource database, which can’t be seen using the normal tools. Also, as of SQL Server 2005, you can take database snapshots, which are a read-only view of a user database and are required to reside on the same instance as the source database. Finally, contained databases, a new feature with SQL Server 2012, can be a very useful feature for database portability, which allows you to easily move user databases between ...
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.
