hey out there,

hit a weird one today: i've created a backpac file of a database in our umbraco cloud account using ssms but i can't seem to restore it locally!

from what i've gathered from support, the databases are v2012. i'm trying to restore it to a local instance of 2014 or 2016 but i don't think this is the root of the problem as usually going up versions is fine (and i'm trying to avoid installing 2012 if i can!).

this is the error i get back from ssms:

Could not import package.
Warning SQL72012: The object [MyDatabaseName_Data] exists in the target, but it will not be dropped even though you selected the 'Generate drop statements for objects that are in the target database but that are not in the source' check box.
Warning SQL72012: The object [MyDatabaseName_Log] exists in the target, but it will not be dropped even though you selected the 'Generate drop statements for objects that are in the target database but that are not in the source' check box.
Error SQL72014: .Net SqlClient Data Provider: Msg 12824, Level 16, State 1, Line 5 The sp_configure value 'contained database authentication' must be set to 1 in order to alter a contained database. You may need to use RECONFIGURE to set the value_in_use.
Error SQL72045: Script execution error. The executed script:
IF EXISTS (SELECT 1
FROM [master].[dbo].[sysdatabases]
WHERE [name] = N'$(DatabaseName)')
BEGIN
ALTER DATABASE [$(DatabaseName)]
SET CONTAINMENT = PARTIAL 
WITH ROLLBACK IMMEDIATE;
END

Error SQL72014: .Net SqlClient Data Provider: Msg 5069, Level 16, State 1, Line 5 ALTER DATABASE statement failed.
Error SQL72045: Script execution error. The executed script:
IF EXISTS (SELECT 1
FROM [master].[dbo].[sysdatabases]
WHERE [name] = N'$(DatabaseName)')
BEGIN
ALTER DATABASE [$(DatabaseName)]
SET CONTAINMENT = PARTIAL 
WITH ROLLBACK IMMEDIATE;
END

has anyone managed to restore a umbraco cloud database locally?!

cheers,

jake