Saturday, May 31, 2008

How to transfer site content DB from C drive to Other drive

Many a times we face an issue that c drive is out of space especially b'coz our site content db is on c drive and we continue to add large size documents and media files etc. In order to get rid of this we can transfer the db to some other drive say d drive with more space. Here is how you can do it:

Go to SQL server management studio and right click on the content db.
As chances are that this db is currently in use hence first take it offline.
It will take some time to take it offline. Once done right click detach the db.
Now go to the location on the c drive program files sql server folder and find the db files. Cut the files from there and paste in a new folder on d drive.
Again go to mgmt studio and attach the db from the new location.

No comments:

Share your SharePoint Experiences with us...
As good as the SharePointKings is, we want to make it even better. One of our most valuable sources of input for our Blog Posts comes from ever enthusiastic Visitors/Readers. We welcome every Visitor/Reader to contribute their experiences with SharePoint. It may be in the form of a code stub, snippet, any tips and trick or any crazy thing you have tried with SharePoint.
Send your Articles to with your Profile Summary. We will Post them. The idea is to act as a bridge between you Readers!!!

If anyone would like to have their advertisement posted on this blog, please send us the requirement details to