Sharepoint - size of content database does not decrease after deleting content

The only reason is that your contents are still residing in SP Content database. Just verify following URL once and check whether you skipped deleting items from this locations.

SiteUrl/_layouts/15/AdminRecycleBin.aspx
SiteUrl/_layouts/15/AdminRecycleBin.aspx?view=2
SiteUrl/_layouts/15/RecycleBin.aspx

SiteUrl/_layouts/15/AdminRecycleBin.aspx?view=2 is the second stage of recycle bin. In order to navigate to this.

  • Go to site Setting
  • Click on Recycle Bin

There you will find an option with second-stage recycle bin

enter image description here


Make sure that you have deleted the items in Site Collection Recycle Bin

enter image description here

Note:

  • Once the document is deleted it moved to 1st stage recycle bin. It stays there based on the web application recycle bin setting that (default is 30 days). after this period finished (30 days) it moved to 2nd stage recycle bin it also called Site Collection Recycle Bin.

  • In 2nd stage recycle bin, the document can be restored only by Site Collection Administrator.

Tags:

Database