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 |
|
Kristen
Test
22859 Posts |
 Posted - 2006-11-27 : 05:18:44
|
| I need to upgrade a SQL 2000 box which is servicing a busy web site from Standard to Enterprise so it can use more memory.Is this just an install-over-the-top type of deal, or are there going to be all sorts of gotchas?(The web site has become very busy with little quiet time 24/7, it has lots of scheduled jobs and about 6 databases, so I'm keen to avoid a reinstall)Kristen |
|
|
Kristen
Test
22859 Posts |
Posted - 2006-11-27 : 10:43:55
|
| Any suggestions chaps? |
 |
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2006-11-27 : 16:31:04
|
| I believe you are looking at an uninstall-reinstall routine. Make sure you have scripts in hand that create logins, attach databases, and re-create jobs. So long as SQL Server is shut down cleanly, you should be all set with the detach-attach. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2006-11-27 : 16:37:05
|
| Thanks Matt.Our usage of MASTER is minimal - a few users at worst.However, we have extensive jobs. Can I just re-attach MSDB? (Restoring it would be fine as an alternative) or does it convey some part of the Enterprise environment?Kristen |
|
|
|
Westley
Posting Yak Master
229 Posts |
Posted - 2006-11-27 : 22:26:30
|
| Kristen, There is no need to uninstall and re-install for this upgrade, I just did one a few weeks ago, it just stright install over the top, where it will just ask if you are upgrading, no issues for a few weeks after I upgraded it. Simple, it will have a bit of downtime tho, but will be less then 10 mins.Make sure you do have backup tho :) |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2006-11-28 : 00:20:27
|
| Thanks for that Westley. Fingers crossed then!Kristen |
|
|
|
Westley
Posting Yak Master
229 Posts |
Posted - 2006-11-28 : 02:12:18
|
| :) shouldn't have any issues, I upgraded for log shipping and its still wroking fine for me. you can use that 40 mins of installing and patching for something else :) |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2006-11-28 : 09:41:53
|
"you can use that 40 mins of installing and patching for something else "Biting my nails, presumably  |
|
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2006-11-28 : 15:53:28
|
| Never tried it myself. Not sure how it would handle updates from service packs, either. Hopefully it is just a bit in the registry that flips from "standard" to "enterprise". Let us know how it goes, Kristen. |
|
|
|
Westley
Posting Yak Master
229 Posts |
Posted - 2006-11-28 : 23:32:45
|
| I think it is, as it doesn't really install anything new. As for me, I need to run the sql script to add in all those system stored proc for log shipping (and tables) So it is just a matter of a registry change, maybe some binary update as well. |
|
|
|
|
|
|
|
|
Upgrade Standard to Enterprise