Moving sharepoint database from one drive to other
I am having the sharepoint installed on c drive which doesn't have much space. Is it possible to move the content database to some other drive on the machine. If yes, then what is the procedure and do i have to make changes anywhere related to these changes? Also is there any possibility of something going wrong somewhere during this process? thanks in advance!
February 18th, 2008 9:50am

Are you having SQL Server on the same box as that of the SharePoint ?? Are you having the SQL DB living in C:\ ?? Generally SQL DBs can be moved from one drive to another DBs http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=1446360&SiteID=17 However with respect to sharepoint you need to pay extra attention. If the DB instance gets corrupted during the DB move, you need to re-configure your sharepoint farm once again. Index is also a good canditate to move to a seperate drive. Indexes occupy rought 30% of you content DB size in your drives. It's better to think of moving indexes also from C:\ to other location http://sharepointnotes.wordpress.com/2008/02/12/quick-tip-move-index-file-location/http://www.experts-exchange.com/OS/Microsoft_Operating_Systems/Server/MS-SharePoint/Q_22851732.html The other option to think of is to scale-up the capacity of your servers, aniticipating the growth of your data
Free Windows Admin Tool Kit Click here and download it now
February 18th, 2008 10:34am

Sundar doesn't seem to have covered the case where you have a basic installation of WSS 3.0 and are using "Windows Internal Database" rather than the full SQL Server. In that case this WSS FAQ item says how to move that from C: to (say) D:. http://wss.asaris.de/sites/walsh/Lists/WSSv3%20FAQ/DispForm.aspx?ID=939 Mike Walsh
February 18th, 2008 12:11pm

Hi Mike, thanks for your post... but the link you have provided is not working anymore. Should you know anything which can help me in moving sharepoint database and SQL database related to intranet sharepoint i have created and from c drive to d drive. any feedback will be appreciated. many thanks. om.om
Free Windows Admin Tool Kit Click here and download it now
September 7th, 2010 4:34pm

This can be done safely but do it when the site is not in use. 1) Quiesce the farm 2) Back it up 3) Detach the databases using SQL Management studio 4) Move them 5) Attach the databases using SQL Management studio 6) Restart the farm and few blogs will help you. http://technet.microsoft.com/en-us/library/cc287899(office.12).aspx http://sharepointsherpa.com/2008/04/18/sharepoint-2007-move-content-and-configuration-databases/ http://www.keirgordon.com/post/Moving-SharePoint-Content-Database-Files-To-New-Location.aspxi am at SharePoint administrator
September 7th, 2010 5:07pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics