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 |
|
CanadaDBA
583 Posts |
 Posted - 2007-11-08 : 12:01:52
|
| I want to copy a SQL2005 database to a SQL2000 environment? I created a backup from the DB in SQL2005 and moved the file to the other server but SQL2000 says the BAK file is invalid since the backup has structure version 611 while the server supports version 539. Any solution?Canada DBA |
|
|
CanadaDBA
583 Posts |
Posted - 2007-11-08 : 12:06:39
|
| I guess I found. There is a copy database wizard in SQL2005. Lets test it...Canada DBA |
 |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-11-08 : 12:08:06
|
| http://weblogs.sqlteam.com/mladenp/archive/2007/02/15/60101.aspx_______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenpSSMS Add-in that does a few things: www.ssmstoolspack.com |
|
|
|
CanadaDBA
583 Posts |
Posted - 2007-11-08 : 12:10:10
|
| I was wrong! The Copy Database wizard copies from SQL2000/SQL2005 to SQL2005 not vice-versa.Canada DBA |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-11-08 : 13:46:16
|
| See http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=55210&SearchTerms=Restore+SQL+2005+to+SQL+2000+via+Downgrade |
|
|
|
CanadaDBA
583 Posts |
Posted - 2007-11-08 : 15:52:48
|
| Thanks Spirit1! I followed the link and resolved my problem. Thanks Kristen! Why didn't I refer to your KB before posting my topic :)Canada DBA |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-11-09 : 01:43:23
|
| "Why didn't I refer to your KB before posting my topic"I'll let you answer that one for yourself! |
|
|
|
|
|
|
Restore a SQL2K5 DB into SQL2000 environment