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)

1- stop all services on sccm server by running preinst.exe /stopsite. You find the preinst.exe file in the ConfigMgr installation directory

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

SELECT * FROM sys.configurations
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 :)


7- move sccm data base on sccm , navigate to the ConfigMgr installation directory, and in the cd.latest/smssetup/bin/x64 folder, run setup.exe.

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

[email protected]