How to move SharePoint files to a different drive?

[TheBugSlayer]

Hello all,

I wrote a long post a few minutes earlier and posted it but now I cannot find it. This is a short version of it. Please forgive me if it turns out to be a duplicate.

In short, I am not a SP guy but a SQL Server DBA/programmer. SQL Server is showing that the SP databases are pointing to separate data and log drives, not C:\. However, C:\Program Files\Microsoft SQL Server\MSSQL10_50.SHAREPOINT\MSSQL\DATA contains the files below which I am unable to delete because they are being used:

AppMng_Service_DB_47cf1da280e54aaf9ce448beef7d248d.mdf
AppMng_Service_DB_47cf1da280e54aaf9ce448beef7d248d_log.LDF
Bdc_Service_DB_fabf3dc8db144f8d86ce939dba8734fd.mdf
Bdc_Service_DB_fabf3dc8db144f8d86ce939dba8734fd_log.LDF
master.mdf
mastlog.ldf
model.mdf
modellog.ldf
MSDBData.mdf
MSDBLog.ldf
MS_AgentSigningCertificate.cer
Search_Service_Application_AnalyticsReportingStoreDB_9d8033be09974228b3fc33d2eaf23987.mdf
Search_Service_Application_AnalyticsReportingStoreDB_9d8033be09974228b3fc33d2eaf23987_log.LDF
Search_Service_Application_CrawlStoreDB_9e0cfbce9c324154ace29abbc618c659.mdf
Search_Service_Application_CrawlStoreDB_9e0cfbce9c324154ace29abbc618c659_log.LDF
Search_Service_Application_DB_7feb3845c35f463f896029b4daa3df26.mdf
Search_Service_Application_DB_7feb3845c35f463f896029b4daa3df26_log.LDF
Search_Service_Application_LinksStoreDB_fef53b0ab00947638173c09697378810.mdf
Search_Service_Application_LinksStoreDB_fef53b0ab00947638173c09697378810_log.LDF
Secure_Store_Service_DB_ab824737e12446d996c119287c75c935.mdf
Secure_Store_Service_DB_ab824737e12446d996c119287c75c935_log.LDF
SharePoint_AdminContent_fe5c2972-b71e-41d9-a34c-a9ee6c69a859.mdf
SharePoint_AdminContent_fe5c2972-b71e-41d9-a34c-a9ee6c69a859_log.LDF
SharePoint_Config_403193fc-f417-49b3-8f1d-4d067dc9b15c.mdf
SharePoint_Config_403193fc-f417-49b3-8f1d-4d067dc9b15c_log.LDF
StateService_8a90d08459b44afc926a808c400a307c.mdf
StateService_8a90d08459b44afc926a808c400a307c_log.LDF
tempdb.mdf
templog.ldf
WSS_Content.mdf
WSS_Content_b2d42fd147fe401d9858a24a35f9e207.mdf
WSS_Content_b2d42fd147fe401d9858a24a35f9e207_log.LDF
WSS_Content_log.LDF
WSS_Logging.mdf
WSS_Logging_log.LDF

SQL Server shows that these databases are not on the C:\ drive. My question is, how do I move these files to a separate folder to free up the C:\ drive, which only has a GB of space available? I will provide more detail upon request.

Thank you for your help.

MCP SQL Server 2000, MCTS SQL Server 2005, MCTS SQL Server 2008 (DBD, DBA), Training HOTT cert SQL Server 2012 Business Intelligence (SSIS, SSAS).

 

[TheBugSlayer]

Is this forum alive? If not, where can I post a SharePoint question? Thank you.

MCP SQL Server 2000, MCTS SQL Server 2005, MCTS SQL Server 2008 (DBD, DBA), Training HOTT cert SQL Server 2012 Business Intelligence (SSIS, SSAS).

 

[kjv1611]

Have you tried just killing off all related Windows processes, and then manually moving the files where you want them? Then see if reopening the application will prompt you for the new file location. I would think worse case scenario would be you'd have to then move the files back if that didn't work until you can try something else.

As far as SharePoint, I've done a lot of work in SharePoint, but not on the server side, just setting up sites, administrating sites, designing, all that.

As for this forum, I don't think it's ever had a lot of activity (to date). There are probably better SharePoint resources on other sites, for the time being.

"But thanks be to God, which giveth us the victory through our Lord Jesus Christ." 1 Corinthians 15:57