NReed.Dev

Sitecore | Optimizely | .NET

Setting Database Containment

Occasionally when using a bacpac along with Sitecore Installation Framework you will run into an error mentioning setting the containment property to NONE.

Below is a SQL script that should solve your issue.

SQL
USE master;
GO
ALTER DATABASE <db> SET SINGLE_USER WITH ROLLBACK IMMEDIATE; 
GO
ALTER DATABASE <db> SET CONTAINMENT = NONE;
GO 
ALTER DATABASE <db> SET MULTI_USER; 
GO

Leave a Reply

Your email address will not be published. Required fields are marked *