Restore failure on enrypted backup
lculley
Posts: 36
I have a backup of a red gate sql v5 encrypted backup from a sql 2000 enterprise sp4 server. I'm trying to restore it to a sql 2000 sp4 developer edition server and I am getting the following error after decrypting the file successfully in sql backup:
SQL server error
SQL error 3013: SQL serror 3013: RESTORE FILELIST is terminating abnormally
SQL error 3169: SQL error 3169: The backed-up database has on-disk structure version 611. The server supports version 539 and cannot restore or upgrade this database.
SQL error 0: Failed to read filelist details(0 rows).
SQL backup exit code: 1100
Why am I getting this error?
Thanks in advance!
SQL server error
SQL error 3013: SQL serror 3013: RESTORE FILELIST is terminating abnormally
SQL error 3169: SQL error 3169: The backed-up database has on-disk structure version 611. The server supports version 539 and cannot restore or upgrade this database.
SQL error 0: Failed to read filelist details(0 rows).
SQL backup exit code: 1100
Why am I getting this error?
Thanks in advance!
Comments
The version of 611 suggests it's a SQL 2005 (Pre-SP2) backup that you're trying to restore to a SQL 2000 server.
There's some details on database version vs. server version and compatibility level here: http://www.sqlskills.com/blogs/paul/200 ... Level.aspx
Hope that helps,
Robert
Red Gate
After doing some further investigation as to how those files were backed up, you are right that it was from a sql 2005 instance and not sql 2000 like I thought.
Thanks for clearing that up!
Laura
Rob
Red Gate