How can we help you today? How can we help you today?

Restore failure on enrypted backup

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!
lculley
0

Comments

3 comments

Sort by
  • 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
    Robert C
    0
  • 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
    lculley
    0
  • Robert C
    No problem, glad it's sorted :-)

    Rob
    Robert C
    0

Add comment

Please sign in to leave a comment.