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?