O'Reilly logo

Microsoft® SQL Server 2012 Unleashed by Alex T. Silverstein, Chris Gallelli, Paul T. Bertucci, Ray Rankins

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

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 ...

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