Process to move sccm DB?

Question

So we have installed sccm and it's DB onto a single VM. But now we would like to move it's DB onto our dedicated clustered sql server.
Is it as simple as just re-running the MS Endpoint config manager setup wizard and pointing it to our dedicated sql server? Will it recreate the db on the dedicated server or do I need to move the DB prior?
I found this snippet below on another thread, is this still the jist? any other tips?

**You will want to shutdown SCCM services (so nothing is writing to the DB). Backup the database (or simply detach it, i prefer backup, just so it's easier to fall back). Create a "blank" database on the new SQL server (with the same name as the SCCM database, or copy the database files to the new SQL server and attach if you detached), and restore the the SCCM database to the new SQL server.

Run the setup wizard for SCCM and point to the new SQL database server.**

Answer

@chris6.4

Your snippet is correct. These are the general steps to do.

There is a very good writeup from Johan Arvidmark, which is adding some extra hints. It is from 2017, but it still can be considered to be valid. It shows how you properly "shutdown" the configuration manager services and how you can verify that old and new sql server are configured equally and that the re-configuration via configuration manager setup runs smoothly.

Also, note that the blog post is describing the very other direction of what you plan to do. Which brings me to my last point: If you haven't done so far, discuss with your colleagues again, if you really want to do it. Things to take into consideration: licensing, performance overhead, security, manageability (sql ops vs. configmgr ops team) in daily business.

Here you go to Johans blog post: https://deploymentresearch.com/moving-the-configmgr-current-branch-database-to-another-server-as-in-back-to-the-primary-site-server/

Hope it helps!

Answer

Hi,

Thanks for posting in Microsoft MECM Q&A forum.

Agree with above reply. Here are some helpful articles for your reference:

Moving a ConfigMgr 2012 database to a SQL cluster
Moving the ConfigMgr Current Branch database to another server (as in back to the primary site server)
Move SCCM Database to a SQL Cluster
Please note: The links are not from Microsoft, just for your reference. Thanks for your time.

Best regards,
Simon

If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Share via

Process to move sccm DB?

2 answers

Your answer