question

BojanZivkovic-7448 avatar image
0 Votes"
BojanZivkovic-7448 asked Amandayou-MSFT commented

Installing Service Pack 3 for SQL Server 2014 on primary site server/secondary sites servers

Hi,

I have primary site server with its DB hosted on local SQL Server Standard 2014 SP2 and two secondary sites on servers with their DBs hosted on SQL Server Express 2014 SP2 respectively. I would like to install SP3 for SQL Server 2014 on all of them so do I have to stop CM services while doing so on primary site server and secondary sites servers and is order of installing SP3 important because SQL Server upgrade for instance must be done first on secondary sites servers and only then on primary site server if I am not mistaken.

Thank you very much in advance!!!

mem-cm-general
5 |1600 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Visible to all users

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

3 Answers

Amandayou-MSFT avatar image
0 Votes"
Amandayou-MSFT answered

Hi @BojanZivkovic-7448，

To upgrade SQL Server on the site database server, we should do these steps:

1.Stop all Configuration Manager services at the site

2.Upgrade SQL Server to a supported version

3.Restart the Configuration Manager services

Here is the article about SQL upgrading, please refer to it:
https://docs.microsoft.com/en-us/mem/configmgr/core/servers/manage/upgrade-on-premises-infrastructure#to-upgrade-sql-server-on-the-site-database-server

And there is no issue about the order, if we would like to upgrade secondary sites first, just operate it.


If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


5 |1600 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Visible to all users

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

BojanZivkovic-7448 avatar image
0 Votes"
BojanZivkovic-7448 answered Amandayou-MSFT commented

Hi, this is not actual upgrade of SQL Server 2014 but installation of SP3 - procedure is the same?

· 1
5 |1600 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Visible to all users

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Amandayou-MSFT avatar image Amandayou-MSFT ·

Yes, it is. If possible, we could backup the SQL to prevent data loss.

Best regards,
Amanda

0 Votes 0 ·
BojanZivkovic-7448 avatar image
0 Votes"
BojanZivkovic-7448 answered Amandayou-MSFT commented

And finally what about patching SQL Servers with their updates (security updates, cumulative updates ...) - again same procedure? :-)

· 2
5 |1600 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Visible to all users

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Amandayou-MSFT avatar image Amandayou-MSFT ·

Hi,

The procedure could be finished once some updates are restarted, it is recommended to do these steps to prevent the operation fails.

Best regards,
Amanda

0 Votes 0 ·
Amandayou-MSFT avatar image Amandayou-MSFT Amandayou-MSFT ·

Hi,

Just checking in to see if there is any update. We haven't heard from you for a few days and would like to know the current status of the problem. Is the problem solved? Do you need any further assistance? Look forward to hearing from you.

Thanks for your time.

Best regards,
Amanda

0 Votes 0 ·