Restore RemoteBackup ZIP

Michael_Armbruster · August 9, 2019, 9:20am

I created a remote backup on a server. As a ZIP file. If I try to restore the same backup. The following message appears:

09.08.2019 09:11 Connecting to SQL Server: 2017 RTM Express Edition (64-bit). VM46C615F
09.08.2019 09:11 Uncompressing “C:\Eurotime\BACKUP\Eurotime201908090739.zip” file with Internal archiver.
09.08.2019 09:11 Restoring “Eurotime” database from files: “Eurotime201908090739.sql”
09.08.2019 09:11 Job execution error: The media family on device ‘C:\Windows\Temp\Pranas.NET\SQLBackupAndFTP\backup\554461b1-06b0-4865-b8c8-e57e04103f5d\Eurotime201908090739.sql’ is incorrectly formed. SQL Server cannot process this media family.
RESTORE FILELIST is terminating abnormally. Computer name: “VM46C615F”
09.08.2019 09:11 Job “Restore Job - 2” finished with “1” errors

Alexander · August 12, 2019, 11:01am

Hi Michael_Armbruster,

Thank you for the details.

To resolve the issue, please make sure that you have chosen “Microsoft SQL Server (remote)” as a server type at the connection window.