boyjaew2 Posted October 29, 2014 Report post Posted October 29, 2014 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! Quote Share this post Link to post Share on other sites More sharing options...
GarthMJ Posted October 30, 2014 Report post Posted October 30, 2014 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. Quote Share this post Link to post Share on other sites More sharing options...
boyjaew2 Posted October 30, 2014 Report post Posted October 30, 2014 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. Quote Share this post Link to post Share on other sites More sharing options...
GarthMJ Posted October 30, 2014 Report post Posted October 30, 2014 Ok did you know that CM12 comes with it own license for SQL Standard, but it can only be used for CM12 and directly related tasks like WSUS. Quote Share this post Link to post Share on other sites More sharing options...
boyjaew2 Posted November 11, 2014 Report post Posted November 11, 2014 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). Quote Share this post Link to post Share on other sites More sharing options...
GarthMJ Posted November 12, 2014 Report post Posted November 12, 2014 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. Quote Share this post Link to post Share on other sites More sharing options...
