changed servers and now having sql issues RRS feed

  • Question

  • So I am in the process of upgrading a server which has a ms sql database on it. It is running ms sql 2008 r2 standard. The new server is running ms sql 2008 r2 developer. The data imports just fine into the new sql server but when I launch the program that uses that database it gives this error...

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

    Error Number - 2147217900

    I have followed all the suggestions on line like going to options and changing the compatibility level but I always get the same error. If someone could provide some assistance it would be greatly appreciated.

    Monday, June 24, 2019 2:01 AM