Move SQL Database from Primary Site to Remote Server

All replies

• 

  

  0

  Sign in to vote

  It's not difficult necessarily, but it adds complexity to the environment as well as possible network latency and also subjects the DB to DBA "tampering". DBAs can be great, but they can also be terrible as they in general, love tinkering and optimizing the DBs which more often than not will cause issues with ConfigMgr.

  Also, keep in mind that the primary site server's computer account must have local admin permissions on the system hosting the SQL instance. This is often a deal-breaker for many DBAs or SQL farms.

  And, if the motivation for this is licensing, then that's not valid as ConfigMgr includes SQL use rights without additional cost.

  If this is still the direction, see https://blogs.technet.microsoft.com/configurationmgr/2013/04/02/how-to-move-the-configmgr-2012-site-database-to-a-new-sql-server/. Note that it references ConfigMgr 2012 but is still valid (process wise) for CB.

  ---

  Jason | https://home.configmgrftw.com | @jasonsandys

  • Marked as answer by Araimondi Thursday, May 7, 2020 11:54 AM

  Wednesday, May 6, 2020 5:00 PM
• 

  

  0

  Sign in to vote

  Thank you for the reply Jason

  Sadly its not up to me as this is coming down for upper management which confuses me as this environment has been rock solid with the SQL Server local.

  Also last question how is the SUSBD handled for the migration? I cant seem to find anything on that

  Wednesday, May 6, 2020 7:24 PM
• 

  

  0

  Sign in to vote

  Hi,
  
  Here is the article based on the blog provides by Jason, but added in workarounds/configurations for some real world issues you are likely to run into.
  https://deploymentresearch.com/moving-the-configmgr-current-branch-database-to-another-server-as-in-back-to-the-primary-site-server/
  
  And the guidance to move the WSUS Database:
  https://enterinit.com/migrate-wsus-database-between-two-sql/
  https://docs.microsoft.com/en-us/archive/blogs/mwiles/how-to-move-the-wsus-database
  
  Regards,
  Allen

  ---

  Please remember to mark the replies as answers if they help.

  If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.

  • Marked as answer by Araimondi Thursday, May 7, 2020 11:54 AM

  Thursday, May 7, 2020 7:15 AM
• 

  

  0

  Sign in to vote

  Thank you

  Thursday, May 7, 2020 11:54 AM
• 

  

  0

  Sign in to vote

  Hi,
  
  Thanks for your feedback, have a nice day!
  
  Regards,
  Allen

  ---

  Please remember to mark the replies as answers if they help.

  If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.

  Friday, May 8, 2020 8:14 AM