Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Restore Version Problem
Message
General information
Forum:
Microsoft SQL Server
Category:
Backups
Miscellaneous
Thread ID:
01517756
Message ID:
01517758
Views:
43
>I have a back created on SQL 2008, and I'm trying to restore it on another machine also running 2008.
>
>I'm getting:
>
>
>System.Data.SqlClient.SqlError: 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.2573. Either restore the database on a server that 
>supports the backup, or use a backup that is compatible with this server. (Microsoft.SqlServer.Smo)
>
>
>I was able to restore it to another PC running 2008 R2, but not this one. Is there any way to restore this DB on this PC?

The version the backup is from is SQL2008 R2. The server you tried to restore to is NOT R2. They do not play nice in backup/restore.

Either upgrade the 2008 server to R2 or copy the database from the server you did restore the backup to.
____________________________________

Don't Tread on Me

Overthrow the federal government NOW!
____________________________________
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform