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

Answers ( 3 )

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

    0
    2020-08-24T14:11:39+05:30

    Thanks, Anoop

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

  2. 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 permission to answer to this question .