O'Reilly logo

Microsoft SQL Server 2012 Internals by Bob Beauchemin Kalen Delaney Conor Cunningham, Jonathan Kehayias, Benjamin Nevarez, and Paul S. Randal

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

Partially contained databases

One main problem faced when moving databases between instances of SQL Server is the application dependency on instance-level objects or objects defined on some other user databases that typically are left behind and need to be identified and moved manually. These instance-level objects could be logins, linked servers, jobs, and so on. Objects defined outside the database are usually tables accessed on other user databases in the same instance. SQL Server 2012 introduces partially contained databases, which is a first step toward full contained databases. In full contained databases, everything required for the application to work is contained in the database without outside dependencies. Although a limited functionality ...

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