In creating a new database on SQL Server 2014, the "Containment Type" dropdown in the create database dialog has only "None", and "Partial". This kind of hints that there should be a "Full" option, but there isn't.

And, indeed, this article actually refers to both partially contained, and fully contained databases.


Is there some SQL Server configuration option that I didn't select when installing SQL Server? Or is there really just no actual "Fully Contained" option?

1 Answer 1


SQL Server doesn't support fully contained databases (yet).

Azure SQL databases are fully contained.


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.