Contained Databases
There is a new set of features in SQL Server 2012 that allow for the creation of a contained database. By definition, a contained database is one that is isolated from other databases and from the instance of SQL Server that it is running on. When contained, no relationship exists between the database and the instance of SQL Server that it is running on. So the database can be moved from one server to another without affecting the usability of the database. Issues such as orphaned database users where the user/login relationship is broken are eliminated with the use of a contained database.
In reality, SQL Server 2012 actually supports partially contained databases. Databases can be created so that they are fully contained ...
Get Microsoft® SQL Server 2012 Unleashed 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.
