I hope you won't ban me for asking the thing that people already discussed somewhere in 2008, but I have faced the error that shouldn't probably appear.
I have created the DB backup using the SA 22.214.171.1244 that I wanted to transfer to my PC and make a copy of the DB file. I used SQL Central to create the backup file (ml1.bak.1).
When I was trying to restore the DB file on my SA 126.96.36.1999 using RESTORE DATABASE, I got an error: Backup file format is invalid.
My SQL command is:
As far as I understood, after googling for some time, I have to use the same SA version to recover the DB file from the "tape"-format. However, I didn't find this in the documentation. The only sentence that I found in SA 17 docs was:
But it says nothing about SA 16 or 17. Is it really important to have the exact version of the DB server? I can easily create a copy using dbbackup, but I am curious if there is a known solution.
Thank you in advance, as always.
asked 16 Mar '16, 12:48