Restore failure on enrypted backup

lculley

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!

Robert C

Hi,

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

lculley

Robert--

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

Robert C

No problem, glad it's sorted :-)

Rob