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

  • 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

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

| 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.