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:
01518092
Views:
62
Yes I did. I installed R2. Sorry I didn't reply. Busy busy week.

Thanks Bill.


>Did you get anywhere with this?
>
>>>>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.
>>
>>1) Is there an 'upgrade' or are we talking a full install?
>>2) Will I still be able to access all the other DB's currently in 2008?
Everything makes sense in someone's mind
public class SystemCrasher :ICrashable
In addition, an integer field is not for irrational people
Previous
Reply
Map
View

Click here to load this message in the networking platform