none
SharePoint/Project Server 2013 -- Data files on a different drive RRS feed

  • Question

  • I've just done a full, new install of SharePoint and Project Server 2013 and nowhere along the way did I see an option to put the content data files on a separate drive from the program files (i.e. D: instead of C:). Did I miss something or is that a subsequent step? Any help would be much appreciated...

    Langhorne

    Friday, November 13, 2015 3:16 PM

Answers

  • The data file are on your SQL Server data directories

    If your SQL database states C:\program files.....\data\contentdb.bak they will be there

    you can change the directory of the location later but setting the directory initially would be best ... and since you are setting this up for the first time you can change this easily by starting over..

    Also if you eventually add an E drive for example thats 1TB in size you can also move the .bak file to the E: drive.. if you need additional help please ask..

    If this answers your question please mark as answer

    • Edited by kbwrecker Saturday, November 14, 2015 12:36 AM more info provided
    • Marked as answer by Langhorne Monday, November 16, 2015 12:45 PM
    Saturday, November 14, 2015 12:33 AM

All replies

  • The data file are on your SQL Server data directories

    If your SQL database states C:\program files.....\data\contentdb.bak they will be there

    you can change the directory of the location later but setting the directory initially would be best ... and since you are setting this up for the first time you can change this easily by starting over..

    Also if you eventually add an E drive for example thats 1TB in size you can also move the .bak file to the E: drive.. if you need additional help please ask..

    If this answers your question please mark as answer

    • Edited by kbwrecker Saturday, November 14, 2015 12:36 AM more info provided
    • Marked as answer by Langhorne Monday, November 16, 2015 12:45 PM
    Saturday, November 14, 2015 12:33 AM
  • Thanks, kbwrecker. I thought I was being clever by using an existing SQL Server installation and that it would be as simple as changing "C:" to "D:" somewhere, but in the end I did just what you suggest - I started over and now all is well.

    Langhorne

    Monday, November 16, 2015 12:45 PM
  • For future reference ... and that you can "simply" change C: to D:  (while entails a little bit of leg work it is pretty straight forward) 

    http://blog.sqlauthority.com/2012/10/28/sql-server-move-database-files-mdf-and-ldf-to-another-location/

    http://hsphere.parallels.com/docs/3.2/sysadmin/html/mssqlchangehome.html

    https://msdn.microsoft.com/en-us/library/ms189133.aspx

    http://www.thewindowsclub.com/move-microsoft-sql-server-database

    Monday, November 16, 2015 2:39 PM