can any one provide me the best practice to upgrade SCCM-SQL servers/
my scenario is below
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.
Answer ( 1 )
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