Move SCCM Database to another SAL server
Hello,
I'd like to move the SCCM database from the current server to another SQL server. The server currently has the database and the services on the same server using SQL 2005 exoress edition, and I'd like to move it to our DB server working on SQL 2005 Enterprise.
How do I accomplish this? Any help would be appreciated.
Thanks.
Ampletrix
I'd like to move the SCCM database from the current server to another SQL server. The server currently has the database and the services on the same server using SQL 2005 exoress edition, and I'd like to move it to our DB server working on SQL 2005 Enterprise.
How do I accomplish this? Any help would be appreciated.
Thanks.
Ampletrix
Last Comment
ASKER
Hello,
Thank you Ulf M.
I worked throught the steps on the site you provided, and it went ok. It displayed all the right information and reported successfuly.
However, now when I open the SCCM console, it hangs at "Connecting to Site Database (CA1 - PRDMGT01...) This server name is the server where I moved the database from to the new one - PRDMDB01.
It still doesn't recognise the new server.
I had a look at another article that mentiones a incorrect SPN.
Do you know if this is fixed or registered on the MDB server or PRDMGT01 server?
Thanks.
Ampletrix.
Thank you Ulf M.
I worked throught the steps on the site you provided, and it went ok. It displayed all the right information and reported successfuly.
However, now when I open the SCCM console, it hangs at "Connecting to Site Database (CA1 - PRDMGT01...) This server name is the server where I moved the database from to the new one - PRDMDB01.
It still doesn't recognise the new server.
I had a look at another article that mentiones a incorrect SPN.
Do you know if this is fixed or registered on the MDB server or PRDMGT01 server?
Thanks.
Ampletrix.
Ampletrix,
have you tried just to reconfigure the console to connect to the new SQL server? You do that by right click on System center Configuration Manager on top left side in the console. Then choose Connect to Site Database. In the wizard change to the new database server.
Regards
Ulf M.
have you tried just to reconfigure the console to connect to the new SQL server? You do that by right click on System center Configuration Manager on top left side in the console. Then choose Connect to Site Database. In the wizard change to the new database server.
Regards
Ulf M.
ASKER
Hello Ulf,
The console will not open. It hangs before it opens. The dialog box where it tries to connect to the site server keeps displaying where it tries to connect to the database.
Can I fix this without opening the console?
Thanks
Ampletrix
The console will not open. It hangs before it opens. The dialog box where it tries to connect to the site server keeps displaying where it tries to connect to the database.
Can I fix this without opening the console?
Thanks
Ampletrix
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Thanks Ulf,
The /norestore switch did the trick for me.
Also - I moved the SMS Provider to the server with SQL on it, and that worked too.
Thanks for your help.
The /norestore switch did the trick for me.
Also - I moved the SMS Provider to the server with SQL on it, and that worked too.
Thanks for your help.
Microsoft Server OS
The Microsoft Server topic includes all of the legacy versions of the operating system, including the Windows NT 3.1, NT 3.5, NT 4.0 and Windows 2000 and Windows Home Server versions.
59K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
You di this by backing up your database and restore it to the new SQL server. Then you run the SCCM2007 setup.exe and modify the SQL Server configuration. You find a step by step guide here,
http://technet.microsoft.c
kind regards
Ulf M.