Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Restore Version Problem
Message
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Copies de sauvegarde
Divers
Thread ID:
01517756
Message ID:
01517763
Vues:
50
>>>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!
____________________________________
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform