Backup from Sql Server 2005 cannot be restored on Sql Server 2000

May 6, 2007 · Filed under SqlServer, Technology

In this post, I mentioned that you can restore a Sql Server backup file to a Sql Server 2005 server.

You cannot do it the other way, though. A backup taken on Sql Server 2005 cannot be restored on a Sql Server 2000 server. If you try, this is the likely message you will get:

Msg 3169, Level 16, State 1, Line 1
The backed-up database has on-disk structure version 611. The server supports version 539 and cannot restore or upgrade this database.

1 Comment »

  1. Ramesh Said,

    August 7, 2007 @

    Getting the same Error.Though i tried to restore the BackupFile.BAK
    In 2005

RSS feed for comments on this post · TrackBack URI

Leave a Comment