Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

I'm trying to figure out how to point the database of my existing Sharepoint foundation install to the D: on my server. It was installed on the C: We just upgraded the D: to hold a lot more and need that space to be used. Is this

share|improve this question

closed as off topic by Kit Menke Aug 24 '11 at 15:53

Questions on SharePoint Stack Exchange are expected to relate to SharePoint within the scope defined by the community. Consider editing the question or leaving comments for improvement if you believe the question can be reworded to fit within the scope. Read more about reopening questions here.If this question can be reworded to fit the rules in the help center, please edit the question.

    
As @Tim mentions, this is more of a SQL Server question. You could try also asking/searching on dba.stackexchange.com –  Kit Menke Aug 24 '11 at 15:55

1 Answer 1

up vote 2 down vote accepted

This isn't as much of a SharePoint thing as it is a SQL Server thing. SharePoint is only pointing to a server that has it's database. It has no knowledge, and probably doesn't care which drive the database lives on. You would need to move the database from SQL Server Management Studio. See here

share|improve this answer
    
If you notice a question is off topic, please vote to close it. You can always add a comment as well. –  Kit Menke Aug 24 '11 at 15:57
    
The only reason I did not vote to close it was because not everyone may be familiar with the way SharePoint is interacting with the database, especially since SharePoint is very 'hands-off' when it comes to SQL Server. –  Tim Gabrhel Aug 24 '11 at 18:24
    
@Tim Gabrhel, I was wondering if you knew what database the documents were held? I have downloaded what you suggested and see a bunch of databases. Also, does the documents get stored in the database or just a string location? –  Phil Aug 24 '11 at 20:06
    
You're looking for something called 'WSS_Content', or similar. Using this link, you can determine which content database your site collection resides in. The physical files live somewhere similar to the following: C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA. There is an MDF (database) and an LDF (log) for each database. –  Tim Gabrhel Aug 24 '11 at 20:30
    
I didn't see this answer before asking the next question... chill. go away. –  Phil Aug 24 '11 at 23:21

Not the answer you're looking for? Browse other questions tagged or ask your own question.