Project Server 2007 database file location on SQL Server 2005
Posted on 2008-06-10
I have installed a named instance of SQL Server 2005 for use with Project Server 2007. Per company policy, I have installed the server instance and system databases on the smaller C: drive of the machine, where the operating system also resides. I set the default location for new database files (.mdf and .log files) to the larger D: drive.
After this, I installed Project Server 2007 on a separate machine, and configured it to use the SQL Server 2005 named instance I described above for content databases. I expected the content database files to be created on the D: drive, but instead it automatically plops Project content databases in the root directory, on the C: drive. There is just not enough space to handle Project content on C:!
Is there a way to change Project Server's configuration to put database files on the D: drive? Or, do I have to uninstall the entire instance of SQL Server, just to install it again with the root directory on the D: drive?
If I detach Project Server databases, move them, and reattach them, it might work, if I can successfully stop the Project services so they will disconnect from the databases. However, I will have to do this manual process again and again for every new Project Server database!
What do I do?