Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
darenkov
Yak Posting Veteran
90 Posts |
 Posted - 2010-07-29 : 10:38:08
|
| I get this error:------------------------The database was backed up on a server running version 10.50.1600. That version is incompatible with this server, which is running version 10.00.1600. Either restore the database on a server that supports the backup, or use a backup that is compatible with this server.-------------------------Is there any easy way to do this (my databases are in two different shared hosting providers). I read about an old publishing wizard from MS but it only works for 2000 + 2005? |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2010-07-29 : 11:13:08
|
| Those aren't two versions of SQL 2008.10.50.1600 is SQL 2008 R2, 10.00.1600 is SQL 2008. They're different versions entirely (just like 2005 and 2008) and you can't restore a database down-version ever.Script the objects, export all the data and recreate the database on SQL 2008--Gail ShawSQL Server MVP |
 |
|
|
darenkov
Yak Posting Veteran
90 Posts |
Posted - 2010-07-29 : 11:33:06
|
| thanks gilamonster.can you provide any suggestion on the easiest way to export the data (in a shared server environment)? |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2010-07-29 : 12:07:58
|
| Can you use bcp? SSIS? Import/export wizard?--Gail ShawSQL Server MVP |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
|
|
|
Restore db from one version of 2008 to another