Multi restore errors

Application issues
1

We are trying to restore the backups made by SQLBackupAndFTP from when server to another, But when we use MS SQL (Local) we get an error saying : “.sql is incorrectly formed. SQL server cannot process this media family. RESTORE FILEIST is terminating abnormally.” When though the two SQL server has the same version: 14.0.3281

But when we choose MS SQL (remote) we get this error instead: “Failed to run T-SQL command, Object: User”… ‘User’ is not valid login or you do not have permission.

We even tried to only take backup of the schemas, tables and data, and its still trying to “create and grant” users.

How can we solve this problem?

Thanks

/Abdi

2

Hi Abdi,

It seems you try to restore backups that were made via remote connection. To restore such backups please use Microsoft SQL Server (remote) connection type, and make sure that on the server you try to restore to, “User” user exists.

Please find more details about the remote backups at https://sqlbackupandftp.com/blog/remote-sql-server-backups-explained

If you have any other questions, please feel free to contact us.