I can’t restore the database. Copy made of SQLBackupAndFTP. The content of the backup task is below. During the restore, I got the message as in the screenshot. The contents of the backup files look like sql commands, but it is not possible to restore them using MS Studio. Who can advise?
Message from restore as zip:
Can’t unzip …filename The zip end headers signature could not be found in teh zip file.
Zip file: c:\Kopia\filename.zip
It looks like a multi zip. But it has an extension of *.sql. I tried to change the extension to * .zip, * .bak but does not bring the result when restoring through a simple Restore in the program.
Backup Job:
…
Files to restore (backup)
17.11.2023 13:11 102 473 234 MY_DATABASE001.sql
…
17.11.2023 13:16 92 374 838 MY_DATABASE035.sql
…
Content:
USE [master]
GO
/****** Object: Database [MY_DATABASE] Script Date: 27.10.2023 16:40:26 ******/
IF NOT EXISTS (SELECT name FROM sys.databases WHERE name = N’MY_DATABASE’)
BEGIN
CREATE DATABASE [MY_DATABASE]
CONTAINMENT = NONE
ON PRIMARY
…
SQL messages of errors:
Msg 544, Level 16, State 1, Line 5
Cannot insert explicit value for identity column in table ‘BnkZapisy’ when IDENTITY_INSERT is set to OFF.