Skip to content

Migrate local SCCM SQL DB to Remote SQL server

Featured Replies

I found this set of instructions for moving the sccm database off the primary site server to an actual (remote) SQL server in our environment and am just wondering if the instructions seem accurate to you guys before I actually attempt it.

 

http://sccm2o12.blogspot.com/2011/05/move-sccm-database-to-remote-sql-server.html

 

 

I will be working with our DBA to accomplish this, but thought it wise to double check with the experts in the forum first.

 

Thanks!

So you know that it is best practice to keep SQL local to CM12. Why would you want to move it to a remote SQL server? Moving it will add a ton of headaches.

  • Author

Ok. That's kinda what I was fishing for. I thought I remembered that being the case. We just went through some SQL license wrangling because MS has changed licensing models... again. Anyway, thanks for the input I will keep it local.

  • 2 weeks later...
  • Author

Crap! I did not know that. I've migrated from the business intelligence version of SQL to std., for the reason stated keeping it local. I don't suppose there's a way to use the included license ex post facto? Would I be able to find that through the MS licensing site for our EA stuff? I don't usually get involved with licensing at that level and it's been a while since the initial deployment. Now I just feel like a dolt...(BAD admin).

It is just a license, so sure you can "claim" the license ex post facto. It is an automatic right for everyone that run any system center product gets.

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...

Account

Navigation

Search

Search

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.