Step By Step Move SCCM Data Base To Another SQL Server

Hello :) this video about moving SCCM Data base to another sql server ( i will move it from remote sql to be local on my sccm server)

C:\Program Files\Microsoft Configuration Manager\bin\X64\00000409\

2. Using PowerShell, stop the remaining ConfigMgr services by running the following commands in an elevated PowerShell using the following commands:

Stop-Service -Name AI_UPDATE_SERVICE_POINT
Stop-Service -Name CONFIGURATION_MANAGER_UPDATE
Stop-Service -Name SMS_NOTIFICATION_SERVER

Note: The AI_UPDATE_SERVICE_POINT service is only available if you configured Asset Intelligence

3. Then use the following commands to make sure they are stopped

Get-Service -Name AI_UPDATE_SERVICE_POINT
Get-Service -Name CONFIGURATION_MANAGER_UPDATE
Get-Service -Name SMS_NOTIFICATION_SERVER

4- On SQLserver, using SQL Server Management Studio, make a full backup of the ConfigMgr database

i change the path to a new folder :)

5- check if CLR enabled or not on old master data base

WHERE name = 'clr enabled'

A run_value of 1 means its enabled , now check the CLR on the master data base on the new instance on the new sql server

on the new sql the value is 0 so enable the CLR by using the below query

sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO
sp_configure 'clr enabled', 1;
GO
RECONFIGURE;
GO

it's enabled now :)

6- now restore the backup to the new sql server

** to not be confused , i just use the sql management of the old server :)

i forgot to add domain user to run the services :( so i will do it again

Note : it will fail on the first time and if you open the log it will show the following error

SQL Server error: [08S01][233][Microsoft][SQL Server Native Client 11.0]Shared Memory Provider: No process is on the other end of the pipe.
*** [08S01][233][Microsoft][SQL Server Native Client 11.0]Communication link failure
*** Failed to connect to the SQL Server

just Simply run the setup wizard one more time, with the same settings and it will success :)

now let's check our sccm with new data base

the sccm server became site data base server

thanks ,, ahmed elsherbiny

[juliagune]

Thank you Ahmed, this video was very useful during a SCCM migration.

[redatalaat]

Thanks a lot for your effort.... it is helpful video, I think it will be more valuable if there were a voice