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 )
There are specific articles for reporting and WSUS services by Sudhessh inside the first link?
Thanks, Anoop
Does the steps provided in the above articles are same for reporting service and wsus Database?
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