Failed to restore

Application issues
1

Tried to restore to my hosted (simply.com) database:

2024-02-06 23:01:28 [Error] Failed to restore “angavangen_se_db_testlager” database. T-SQL command error: /* ==Scripting Parameters==

Source Server Version : SQL Server 2019 (15.0.4003)
Source Database Engine Edition : Microsoft SQL Server Standard Edition
Source Database Engine Type : Standalone SQL Server

Target Server Version : SQL Server v160
Target Database Engine Edition : Unknown
Target Database Engine Type : Standalone SQL Server

*/

/****** Object: Database [angavangen_se_db_planklager] Script Date: 2024-02-06 22:31:20 ******/
CREATE D…er]
CONTAINMENT = NONE
ON PRIMARY
( NAME = N’angavangen_se_db_testlager’, FILENAME = N’D:\SQL\angavangen_se_db_planklager.mdf’ , SIZE = 51200KB , MAXSIZE = 15728640KB , FILEGROWTH = 51200KB )
LOG ON
( NAME = N’angavangen_se_db_testlager_log’, FILENAME = N’D:\SQL\angavangen_se_db_planklager_log.ldf’ , SIZE = 51200KB , MAXSIZE = 2097152KB , FILEGROWTH = 51200KB )
COLLATE Danish_Norwegian_CI_AS
WITH CATALOG_COLLATION = DATABASE_DEFAULT

CREATE DATABASE permission denied in database ‘master’.

What should I ask them to do?

2

Hello Lennart_Bosrup,

We have checked the issue, and it seems this is a user permission problem related to the privilege settings. Since the issue doesn’t relate to SQLBackupAndFTP, there is nothing we can do from our side. For more details, we recommend you to contact your DBA.

Also, you can try to restore that backup under the SA user (root superuser).

If you have any other questions, please let us know.

Thank you, and sorry for the inconvenience.