Tuesday, March 27, 2012

Does sql server 2000 require a reboot?

Hi All,
I'm installing 2k developer, and the service pack 3a. Do either of these
require a reboot?
Thanks in advance
RyanSee the SP3a readme, section 3.4 (but I always reboot the computer after
installing a service pack. You need to take down SQL Server anyway if you
install an SP, so what's another 2 minutes for a server reboot?):
3.4 Stop Services and Applications Before Running SP3a Setup
The following information applies to all components.
You can apply SP3a without shutting down services. If you do not shut down
services, you are prompted to reboot the computer when Setup is complete.
Without rebooting, the following services fail to start:
a.. Microsoft Distributed Transaction Coordinator (MS DTC) and the
Microsoft Search and MSSQLServerOLAPService services.
b.. The MSSQLServer and SQLServerAgent services for the instance being
upgraded (for example, MSSQL$NamedInstance).
c.. Microsoft Component Services, Microsoft Message Queuing, and Microsoft
COM Transaction Integrator.
d.. All applications, including Control Panel. (optional)
You can apply SP3a without restarting your computer by stopping these
services and applications before applying the SP3a.
You cannot stop the services in a clustered environment. For more
information, see Section 3.10 Installing on a Failover Cluster.
Jacco Schalkwijk
SQL Server MVP
"Ryan Breakspear" <r.breakspear@.removespamfdsltd.co.uk> wrote in message
news:%23WDWxN0CEHA.688@.tk2msftngp13.phx.gbl...
> Hi All,
> I'm installing 2k developer, and the service pack 3a. Do either of these
> require a reboot?
> Thanks in advance
> Ryan
>|||Sorry, maybe I didn't make it clear. I'm installing SQL Server 2000
developer as well as the 3a service pack. I've since read that the service
pack requires a restart of the SQL Server services (which I'm not worried
about). I will do a re-boot at the end of the day, but the server is also a
file server, so don't want to do a reboot now after installing MS SQL Server
2000. Is this required?
Thanks
Ryan
"Jacco Schalkwijk" <NOSPAMjaccos@.eurostop.co.uk> wrote in message
news:esUq4m0CEHA.3132@.TK2MSFTNGP11.phx.gbl...
> See the SP3a readme, section 3.4 (but I always reboot the computer after
> installing a service pack. You need to take down SQL Server anyway if you
> install an SP, so what's another 2 minutes for a server reboot?):
> 3.4 Stop Services and Applications Before Running SP3a Setup
> The following information applies to all components.
> You can apply SP3a without shutting down services. If you do not shut down
> services, you are prompted to reboot the computer when Setup is complete.
> Without rebooting, the following services fail to start:
> a.. Microsoft Distributed Transaction Coordinator (MS DTC) and the
> Microsoft Search and MSSQLServerOLAPService services.
>
> b.. The MSSQLServer and SQLServerAgent services for the instance being
> upgraded (for example, MSSQL$NamedInstance).
>
> c.. Microsoft Component Services, Microsoft Message Queuing, and
Microsoft
> COM Transaction Integrator.
>
> d.. All applications, including Control Panel. (optional)
> You can apply SP3a without restarting your computer by stopping these
> services and applications before applying the SP3a.
> You cannot stop the services in a clustered environment. For more
> information, see Section 3.10 Installing on a Failover Cluster.
>
> --
> Jacco Schalkwijk
> SQL Server MVP
>
> "Ryan Breakspear" <r.breakspear@.removespamfdsltd.co.uk> wrote in message
> news:%23WDWxN0CEHA.688@.tk2msftngp13.phx.gbl...
these
>|||You have to reboot your server after installing SQL Server 2000. You can
install it now though, and only do the reboot at the end of the day, before
you install the service pack.
Jacco Schalkwijk
SQL Server MVP
"Ryan Breakspear" <r.breakspear@.removespamfdsltd.co.uk> wrote in message
news:%23DlS7t0CEHA.1588@.tk2msftngp13.phx.gbl...
> Sorry, maybe I didn't make it clear. I'm installing SQL Server 2000
> developer as well as the 3a service pack. I've since read that the
service
> pack requires a restart of the SQL Server services (which I'm not worried
> about). I will do a re-boot at the end of the day, but the server is also
a
> file server, so don't want to do a reboot now after installing MS SQL
Server
> 2000. Is this required?
> Thanks
> Ryan
> "Jacco Schalkwijk" <NOSPAMjaccos@.eurostop.co.uk> wrote in message
> news:esUq4m0CEHA.3132@.TK2MSFTNGP11.phx.gbl...
you
down
complete.
> Microsoft
> these
>|||OK, thanks
"Jacco Schalkwijk" <NOSPAMjaccos@.eurostop.co.uk> wrote in message
news:ueIl8y0CEHA.464@.TK2MSFTNGP11.phx.gbl...
> You have to reboot your server after installing SQL Server 2000. You can
> install it now though, and only do the reboot at the end of the day,
before
> you install the service pack.
> --
> Jacco Schalkwijk
> SQL Server MVP
>
> "Ryan Breakspear" <r.breakspear@.removespamfdsltd.co.uk> wrote in message
> news:%23DlS7t0CEHA.1588@.tk2msftngp13.phx.gbl...
> service
worried
also
> a
> Server
after
> you
> down
> complete.
being
message
>

No comments:

Post a Comment