Restore Database Problem

  • Hi All,

    When I tried to Restore one of the Databases to another Server it gave me the following message:

    Msg 3169, Level 16, State 1, Line 1

    The database was backed up on a server running version 10.50.1617. That version is incompatible with this server, which is running version 10.00.4064. Either restore the database on a server that supports the backup, or use a backup that is compatible with this server.

    Msg 3013, Level 16, State 1, Line 1

    RESTORE DATABASE is terminating abnormally.

    Would anyone know other ways of Restoring the Database please?

    Thank you,

  • You can't downgrade a db like that.

    You're taking a backup from 2008 R2 and trying to restore on 2008. That's never going to work (and it never has).

    You can script out everything from the original db and rebuild on the 2008 server.

  • Or upgrade to R2 on the server you are restoring to

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply