Jump to content


farisnt

How to move SCCM Database to another SQL Server

Recommended Posts

Good Day

I have Server1 that is hosting:

  • SCCM 2012
  • SQL 2008
  • WSUS
  • Reporting
  • DP
  • ....

now I got my new SQL Server and looking for :

  • How can I move the SQL database to the new location (Do I also need to move the reporting DB ) ?
  • Is Moving the database named as (CM_"SiteID") will be enough and dose it include all the config like WSUS Database ...etc
  • Incase the reporting service is not installed on the new SQL Server, will the SCCM reports work ???

 

Thanks alot

Share this post


Link to post
Share on other sites

If I remember right there are instruction within the docs that will tell you how to move the db from server to another server.

No it will not include the WSUS db.

No the CM12 reports will not work until you fix the SSRS site, if you had SSRS before you can adjust the old SSRS site to use the the new database.

Share this post


Link to post
Share on other sites

Thanks for your reply

but will there be any problem if I move the CM12 DB and leave the WSUS DB on the local server, will all work OK ???

Share this post


Link to post
Share on other sites

It should work fine, if you only move the CM db. Remember you will need to do a site reset. There are details instruction within the docs on how to move the db.

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...

×
×
  • Create New...