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 |
|
SQLServerDBA_Dan
Aged Yak Warrior
752 Posts |
 Posted - 2006-02-10 : 15:03:44
|
| I did this on a test server and it seemed to be ok. Are there any dangers/gotcha's in doing this?Thanks,Daniel |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-02-10 : 15:14:24
|
| If you know the application will work on 2000, then change its compatibility mode to 80 as its at 70 upon restore/upgrade. I haven't run into any problems in the past with 7.0 to 2000 upgrades. The problems that we ran into with upgrades was from 6.5 to 7.0 or 6.5 to 2000.Tara Kizeraka tduggan |
 |
|
|
SQLServerDBA_Dan
Aged Yak Warrior
752 Posts |
Posted - 2006-02-10 : 15:50:30
|
quote:
Originally posted by tkizer
If you know the application will work on 2000, then change its compatibility mode to 80 as its at 70 upon restore/upgrade. I haven't run into any problems in the past with 7.0 to 2000 upgrades. The problems that we ran into with upgrades was from 6.5 to 7.0 or 6.5 to 2000.Tara Kizeraka tduggan
Danke.  |
|
|
|
|
|
|
Restore 7.0 DB to 2000, any dangers?