question

Dilpreet avatar image
Dilpreet asked

upgrading sql server 2000 to 2014

Do we need to stop the SQL Server Services for patching SQL Server 2000 with (SP4)and SQL Server 2008 with (SP2)to upgrading this on SQL Server 2014 ? Please also need help to find how can we stop SQL Services for SQL Server 2000 on Window 2003 if we need to ?
upgradepatching
1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

JohnM avatar image JohnM commented ·
The patching process should stop the service for you. It can't patch it while it's actively running. Note however, it's been a long time since I've had to patch a SQL 2000 box.
0 Likes 0 ·

1 Answer

·
Steve Jones - Editor avatar image
Steve Jones - Editor answered

You shouldn't need to stop the service to apply a service pack. The patch should do this for you, but it doesn't hurt.

To stop the services, open the services applet from the start menu (in control panel). Find the SQL Server service, which might have a name for named instances, select the service and click stop.

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.