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

第八个猴子

于 2008-10-24 23:04:00 发布

阅读量70

点赞数

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/laputa-sky/archive/2008/10/24/1319096.html

本文介绍了一种解决C盘空间不足的方法，通过将SharePoint站点的内容数据库迁移到D盘来释放C盘空间。具体步骤包括：使数据库离线、分离数据库、移动数据库文件到D盘的新位置以及重新附加数据库。

From: http://www.sharepointkings.com/2008/05/how-to-transfer-site-content-db-from-c.html

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

转载于:https://www.cnblogs.com/laputa-sky/archive/2008/10/24/1319096.html