Move SCCM DB and SUSDB to Different instance

Question

Hi,

We’ve SCCM Primary Site CB 1902 and its databases hosted on a clustered SQL server, we are planning to move SUSDB and CM DB from default instance (MSSQLSERVER) to new Instance on the same cluster.

so please I need the sequence should I follow to perform this task

 

Thanks in advance

solved 0
Ahmed.Essam 2 months 3 Answers 53 views Beginner 0

Answers ( 3 )

  1. There are specific articles for reporting and WSUS services by Sudhessh inside the first link?

  2. Thanks, Anoop

    Does the steps provided in the above articles are same for reporting service and wsus Database?

  3. I think the process of this DB migration is same as the normal DB migration even though you are not changing the cluster

    I had gone through this experience long back with SCCM 2007. However, I don’t think nothing much changed in the core process of DB migration in SCCM Current Branch 1902

    I will let you go through https://www.anoopcnair.com/sccm-sql-2005-2008-database-migration-clustered-single-instance/

    Deep dive process is explained by #Rajul https://www.anoopcnair.com/sccm-sql-server-database-migration-part-2/

    Also more up to date information of SCCM SQL DB migration process is explained

    https://docs.microsoft.com/en-us/mem/configmgr/core/support/azure-migration-tool#site-database

    Backup and restore the database
    Configure SQL Always On and allow the data to replicate
    Migrate a SQL database to an Azure SQL Server VM

    Best answer

Leave an answer

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