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 |
|
dbist
Yak Posting Veteran
52 Posts |
 Posted - 2008-04-21 : 15:25:22
|
| hello, what is the general consensus on installing SQL 2005. I usually run a backup of SQL 2000 dbs and then restore on SQL 2005 and change compatibility to 9.0. Is it the right way to upgrade? I'm only asking because I also did one db in-place to SQL 2005 and thought it went well until I browsed my system dbs. All of them are missing tables that usually appear in SQL 2005 system dbs. Other than that I haven't run into too many problems. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-04-21 : 15:35:32
|
| I've heard lots of problems with in-place upgrades. I don't have any links to show though as I looked into it a while back. Why take the risk though?Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
dbist
Yak Posting Veteran
52 Posts |
Posted - 2008-04-21 : 16:25:28
|
| Well it was a database of low priority. I tried to save time. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-04-21 : 22:53:57
|
| I did in-place upgrade many times, worked fine so far. Always keep good backups. |
|
|
|
|
|
|
In-place upgrade vs fresh install 2005 from 2000