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 |
|
armelson
Starting Member
2 Posts |
 Posted - 2009-02-24 : 10:49:02
|
| Hello,when I try to restore SQL2005-backup of DB into a SQL2000 instance I receive this error message:"the backup have a structural version on disk 611. the server use version 539 and can not restore or upgrade this DB"How can I solve this problem?Thanks for your help |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-02-24 : 10:51:58
|
quote:
Originally posted by armelson
Hello,when I try to restore SQL2005-backup of DB into a SQL2000 instance I receive this error message:"the backup have a structural version on disk 611. the server use version 539 and can not restore or upgrade this DB"How can I solve this problem?Thanks for your help
You can restore from SQL 2005 to SQL 2000. Use SSIS for it. |
 |
|
|
armelson
Starting Member
2 Posts |
Posted - 2009-02-24 : 11:30:45
|
| thanks you for your responeI'm a beginner in SQL, can you explain me or give me a link on which I can find a procedure to use SSIS to make this? |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-02-24 : 12:15:52
|
| You have to apply scripts to SQL 2000 from 2005 and Use Export/Import Wizard to migrate data. |
|
|
|
|
|
|
restore SQL 2005 DB into SQL2000 instance