If you want the move the whole SQL to new drives, by that I mean reconfigure the existing sql installation, then you should look for a proper guide on this from a sql blog. I used one a while back and will try to find it for you. Moving the databases to new partitions or disks is fine and not too difficult but you would really want to tidy the sql instance up as well and move the master, model and temp db and log files; that is not something you can do easily, I think it requires scripting because you cannot do it in the management studio. (at least the version of sql I moved didn’t allow it).
Make sure you have good backups, allow for a little downtime and test it in your test environment first. If the system dbs get screwed it is difficult to fix. (not impossible though) I’ll try and find that blog…. From: [email protected] [mailto:[email protected]] On Behalf Of Brian McDonald Sent: 12 March 2014 22:04 To: [email protected] Subject: Re: [mssms] Moving SCCM 2012 DB Chris, Any guides on how to do this in the scenario where I have SQL entirely installed on one drive? Thanks, Brian Sent from my iPhone On Mar 12, 2014, at 3:59 PM, "Chris Nackers" <[email protected]<mailto:[email protected]>> wrote: All other responses have been spot on, the license issue wasn’t a valid point. You should have more drives than C/E anyways for a proper CM install, but it is what it is. In a ideal configuration you would have: C: OS D: ConfigMgr Inboxes E: Data/DP F: SQL DB G: SQL TX That’s “ideal”, perfect would to be split a few more things up, but for your size, doubtful you’ll see much of a difference, the main key is to separate the OS from ConfigMgr from SQL DB from SQL TX. Hope that helps. Chris Nackers Microsoft MVP – Enterprise Client Management Email: [email protected]<mailto:[email protected]> Nackers Consulting Services, LLC From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of Brian McDonald Sent: Wednesday, March 12, 2014 11:06 AM To: [email protected]<mailto:[email protected]> Subject: RE: [mssms] Moving SCCM 2012 DB Thanks for everyone who responded. Here's my next question. In my environment, my SQL DBA installed SQL on my Primary Site Server. I know, I know....:( I have 2 drives on my Primary Site. C:\ has SCCM Installed and E:\ has SQL installed. How difficult of a task would it be to move the DB directory, logs directory, tempDB directory, tempDB files, etc. etc. to separate drives? Would I be looking at a complete reinstall of SQL? How would this impact my current SCCM 2012 environment? Is it too risky to do at this point. Trying to determine my options and best recommendations on how to move forward. Thanks! Brian ________________________________ From: [email protected]<mailto:[email protected]> To: [email protected]<mailto:[email protected]> Subject: RE: [mssms] Moving SCCM 2012 DB Date: Wed, 12 Mar 2014 14:47:24 +0000 1. It’s already installed in a Microsoft supported configuration 2. Moving it will mean generating a fair amount of network traffic between the two servers whereas it is presently all local 3. Generally speaking, your data is more secure staying put on one server than moving it from one server to another 4. IIRC, they cannot use that SQL license to collocate other application databases…it’s ONLY for ConfigMgr (need to verify that one though). So unless they have a separate SQL license for the other server, they’re either dedicating another whole server just for ConfigMgr or they’re wasting the license IMO, they’re the ones with the burden of proof in this situation. They would need to demonstrate how moving data across a network between servers is less secure than having it all local. -Phil _________________________________________________________________ Phil Schwan | Technical Architect, Enterprise Windows Services Project Leadership Associates | 2000 Town Center, Suite 1900, Southfield, MI 48075 Lync: 312.756.1626 Mobile: 419.262.5133 www.projectleadership.net<http://www.projectleadership.net/> <image001.jpg>Lead with Strategy. Leverage Technology. Deliver Results. <image002.jpg><http://www.linkedin.com/in/philschwan><image003.jpg><https://twitter.com/philschwan> <image004.jpg><http://myitforum.com/myitforumwp/author/philschwan> From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of Brian McDonald Sent: Wednesday, March 12, 2014 10:34 AM To: [email protected]<mailto:[email protected]> Subject: [mssms] Moving SCCM 2012 DB Hi everyone, My DBA has asked me to move my local SQL install remote. I have a single primary site with 64 GB of memory and service only 1200 clients total. I see no reason to move the SQL to a remote location. They basically told me there reasoning was from a security standpoint. First reason was because local install required a local SQL instance (licensing), which we explained to them we are using STD edition and licensing is included. I need a strong business case to keep my SQL install local. I see no reason to move it off-box. Any suggestions? Thanks, Brian ________________________________ PRIVILEGED AND CONFIDENTIAL. This email and any files transmitted with it are privileged and confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the sender. If you are not the named addressee you should not disseminate, distribute or copy this e-mail or any of its attachments.
