Move SharePoint Foundation 2010 databases to a different path after WSS 3.0 upgrade

Julian123
Julian123 used Ask the Experts™
on
I had been running WSS 3.0 with my database located on the D:

D:\SharePoint Data\Databases\STS_Config.mdf
D:\SharePoint Data\Databases\STS_Config_log.LDF
D:\SharePoint Companyweb Data\Companyweb Content DB\STS_SERVERNAME_1.mdf

 I did an in-place upgrade to SharePoint foundation 2010 and found that I now have a large amount of data on my c: too (was not aware that would happen):

C:\Windows\SYSMSI\SSEE\MSSQL.2005\MSSQL\Data\SharePoint_AdminContent_c4642960-77d5-4a17-ac49-fe27d3af18da_log.LDF
C:\Windows\SYSMSI\SSEE\MSSQL.2005\MSSQL\Data\SharePoint_AdminContent_c4642960-77d5-4a17-ac49-fe27d3af18da.mdf
C:\Windows\SYSMSI\SSEE\MSSQL.2005\MSSQL\Data\SharePoint_Config_2d76f328-936d-4b16-8bcd-0ce6115dd8c0_log.LDF
C:\Windows\SYSMSI\SSEE\MSSQL.2005\MSSQL\Data\SharePoint_Config_2d76f328-936d-4b16-8bcd-0ce6115dd8c0.mdf
C:\Windows\SYSMSI\SSEE\MSSQL.2005\MSSQL\Data\WSS_Content_e6e2e57dfc494c2e811690b88c4028a9.mdf
C:\Windows\SYSMSI\SSEE\MSSQL.2005\MSSQL\Data\WSS_Content_e6e2e57dfc494c2e811690b88c4028a9_log.LDF

There are a number of other files in this directory as well that look related.


My questions are threefold:

1.How do I move the data from the C: to the D:? I don't need to change any configuration settings other than moving the data from one drive to another. Some step-by-step instructions would be wonderful.

2. What do I do with the old WSS 3.0 files currently on the D: (the two I listed at the beginning of this post)? The .LDF and .mdf files I listed above both have modified dates of today, indicating that something is still using them.

3. Why are the .ldf files on my C: so big and is there any way to make them smaller? The ones I mentioned above are as large as 7GB.

Thanks so much!
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Cloud Expert
Most Valuable Expert 2013
Top Expert 2014
Commented:

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial