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:
01517763
Views:
49
>>>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?
>>
>>Worse comes to worse, if you've restored it elsewhere, you can copy the database from the server you restored it to.
>
>Well, I detached it & tried to attach it on the other pc and it won't work.

Detach/Attach won't work on different versions.

SQL Management Studio allows you to copy a database from server to server (right click on a server or a database in the object tree on the left and you can select tasks.. where one of the tasks is to copy a database).
____________________________________

Don't Tread on Me

Overthrow the federal government NOW!
____________________________________
Previous
Reply
Map
View

Click here to load this message in the networking platform