SCCM-SQL upgrade

Question

Hi,

can any one provide me the best practice to upgrade SCCM-SQL servers/

my scenario is below

CAS

Primary 1

Primary 2

Secondary

Secondary site is the child site of primary 2

ServerCASSQL is the SQL Server with two SQL database instances .

CAS is using  SQL (ServerCASSQL1) database instance , Primary 1 is using  ServerSQLPrimary)  database instance on same SQL server (ServerCASSQL).

Primary 2 is using seperate SQLPrimar2 Server .

what is the best practice to be used to upgrade SQL Servers in this scenario?

can any one assist me ?

thanks in advance.

 

 

solved 0
Najimsabah 2021-07-08T21:18:45+05:30 1 Answer 26 views Beginner
0

Answer ( 1 )

  2. Anoop C Nair
    0
    2021-07-10T01:35:22+05:30
    Reply

    Well, this is a very complex scenario 🙂

    I will take the top-down approach to upgrade SQL and best practices in the following link.

    More details https://docs.microsoft.com/en-us/mem/configmgr/core/servers/manage/upgrade-on-premises-infrastructure#BKMK_SupConfigUpgradeDBSrv

    Best answer

Leave an answer

Sorry, you do not have permission to answer to this question .