I'm trying to find a consistent recommendation on disk assignments for data folders when installing SQL Server 2012 for use with SCCM 2012 R2. The search hits I'm getting seem to vary a lot. Here's what I've compiled so far, but please let me know if I'm missing something or need to correct it somewhere? (note: This is for a relatively small standalone primary site, but with option to accommodate future growth)
- Windows Server (OS) on C:
- D: is assigned to DVD/CD
- E: for SCCM 2012 R2 install root, and SQL Server install target
- F: for SQL database files
- G: for SQL LOGs and TempDB logs
- H: for SQL TempDB
- I: for SCCM content (apps, packages, etc.)
Is this overkill? Where should the default backup directory be pointed? TIA!
(EDIT) I also wanted to ask about using AD (domain) user accounts for mapping to the SQL services. Article https://technet.microsoft.com/en-us/library/hh427336.aspx#BKMK_ManageSPNforDBSrv says an SPN has to be assigned manually for this. If there's only one standalone primary site, I assume I can use local (server) accounts, but if later I need to add this to a CAS to build out a hierarchy, it will likely need domain accounts to allow for replication traffic. Is this correct?
- Edited by David M. Stein 12 hours 34 minutes ago Added to question