locked
delete unused data from SharePoint 2007 site to reduce DB size? RRS feed

  • Question

  • Hi, I have SharePoint 2007 farm and one site collection having DB size is approx 500 GB.

    In this site collection very old data are there which are not in use but it is in million in count so it not possible to delete from Library one by one and also it will hit recycle bin.

    So is there any way to delete these unused million data form SharePoint site?

    Monday, September 19, 2016 1:58 PM

Answers

  • Hi Prakash

    You can use PowerShell to write script to delete unused sites/lists/document libraries. Check below articles for same:

    http://www.sharepointdiary.com/2011/05/how-to-use-powershell-with-sharepoint-2007.html

    http://get-spscripts.com/2011/03/using-powershell-scripts-with-wss-30.html


    Thanks
    Mohit

    • Marked as answer by Prakash KSingh Wednesday, October 26, 2016 11:25 AM
    Monday, September 19, 2016 4:48 PM