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 |
|
jamie
Aged Yak Warrior
542 Posts |
 Posted - 2006-10-24 : 04:47:58
|
| HI,I need to install a new instance of SQL on a SQL Server enterprise server (SP3)problem is the only cd's I have are sql2000 enterprise (SP2) and then an additional SP3 cd.my question is what do I need to install to put a correct instance on this server ?do I install sql2000 SP2 , choosing a new instance name, then install the sp3 cd ,will it give me the option to run the sp3 against the new instance ?also, will any of these steps require a reboot ?thank you.Jamie |
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2006-10-24 : 04:59:59
|
| Yes, you install the product at whatever service release it is, then afterwards you install the service pack 3 (or whatever) on top. Either step may require a reboot. Generally you can get away without reboots if various other files are not in use during the installation (eg enterprise manager and other sql services).-------Moo. :) |
 |
|
|
jamie
Aged Yak Warrior
542 Posts |
Posted - 2006-10-24 : 05:01:08
|
| thank you.this server is currently a live server, so as the default instance is being used, you say I will infact need to reboot ? |
|
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2006-10-24 : 05:14:13
|
| I believe that you should accept the possibility of needing to reboot. Based on my experiences the machine will "sometimes" ask for one. (Especially if SQL Server is in use during the install). This means that you wouldn't be able to apply SP3 over the instance because of pending reboot requests. Of course, you can hack the registry to get around that, but that's not something that I would recommend. To be honest, you're better off doing the whole job in a downtime window. If your server cannot take being offline for a while then it needs more resilience.-------Moo. :) |
|
|
|
jamie
Aged Yak Warrior
542 Posts |
Posted - 2006-10-24 : 05:23:13
|
| ok, thank you for the info. I will wait until out of hours !. |
|
|
|
|
|
|
|
|
installing a new instance