Julian123
asked on
Move SharePoint Foundation 2010 databases to a different path after WSS 3.0 upgrade
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\MSS QL.2005\MS SQL\Data\S harePoint_ AdminConte nt_c464296 0-77d5-4a1 7-ac49-fe2 7d3af18da_ log.LDF
C:\Windows\SYSMSI\SSEE\MSS QL.2005\MS SQL\Data\S harePoint_ AdminConte nt_c464296 0-77d5-4a1 7-ac49-fe2 7d3af18da. mdf
C:\Windows\SYSMSI\SSEE\MSS QL.2005\MS SQL\Data\S harePoint_ Config_2d7 6f328-936d -4b16-8bcd -0ce6115dd 8c0_log.LD F
C:\Windows\SYSMSI\SSEE\MSS QL.2005\MS SQL\Data\S harePoint_ Config_2d7 6f328-936d -4b16-8bcd -0ce6115dd 8c0.mdf
C:\Windows\SYSMSI\SSEE\MSS QL.2005\MS SQL\Data\W SS_Content _e6e2e57df c494c2e811 690b88c402 8a9.mdf
C:\Windows\SYSMSI\SSEE\MSS QL.2005\MS SQL\Data\W SS_Content _e6e2e57df c494c2e811 690b88c402 8a9_log.LD F
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!
D:\SharePoint Data\Databases\STS_Config.
D:\SharePoint Data\Databases\STS_Config_
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\MSS
C:\Windows\SYSMSI\SSEE\MSS
C:\Windows\SYSMSI\SSEE\MSS
C:\Windows\SYSMSI\SSEE\MSS
C:\Windows\SYSMSI\SSEE\MSS
C:\Windows\SYSMSI\SSEE\MSS
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!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.