on 2016 Mar 16 12:48 PM
Hello everyone,
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 16.0.0.1324 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 17.0.0.1359 using RESTORE DATABASE, I got an error: Backup file format is invalid.
My SQL command is:
RESTORE DATABASE 'C:\\somewhere\\ml1.db' FROM 'C:\\somewhere\\ml1.bak';
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:
As of version 12, you cannot restore archive backups created with version 11 or earlier database servers.
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.
Vlad
User | Count |
---|---|
71 | |
11 | |
10 | |
10 | |
10 | |
8 | |
7 | |
7 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.