I have Sharepoint WSSv3 running and configured as a farm, using SQL 2008 Express on the same server and wondered what steps i would need in order to move the database from the C:\ to the E:\ (on the same server). I have been told in a previous thread to detatch the db and move the files and reattach the db, but then someone replied Don't forget to change the default paths so the subsequents DBs are created on E:?? What Default Paths?? what i was going to do is: Stop all sharepoint and sql services detach the db move all databases onto the E:\ reattach the db restart the sharepoint and sql services Is this correct??

HI, You can specify the default database file locations using SQL Server Management Studio. Right-click the server in the object explorer and select Properties-->Database Settings. then change the location of the mdf and ldf file location, as andre said it's recommended if you placed them on different disks http://sqlserverpedia.com/blog/sql-server-management/changing-default-mdb-file-location/

Hi, for the purpose of moving the mdf files you have to first deattach them from the SQL server instance and move it to drive E:\ the attach them again , you don't have to stop and start the SQL service , you can check how to attach and de-attach database http://technet.microsoft.com/en-us/library/ms190209.aspx

What about on the Sharepoint point od view, do i need to detatch and then attach the content database?

Sorry for being annoying but i need to be 100% correct on this brfore making any chages. Is the steps below correct? Detatch the Sharepoint Content Database in Sharepoint Admin Central Detatch the Sharepoint Databases using SQL Management Studio. Move all the LDF Data onto the E:\. Leaving the MDF Data on the C:\ Re-attach the Sharepoint Databases on SQL Management Studio Re-attach the Sharepoint Content Database in Sharepoint Admin Central

if you dont feel secure, can recomend pratice with Virtual Machine. or can pratice with SharePoint Site create a new Site collection and add new database, then make the change for that Database. If you dont feel safe just talk to you Sharepoint Administrator.Andr Lage Microsoft SharePoint, CRM and Sybase Consultant Blog:http://aaclage.blogspot.com Codeplex:http://spupload.codeplex.com/http://simplecamlsearch.codeplex.com/

You should move the mdf and ldf file to non system drive