How do i delete these site collections from content db?

Question

Hi All,

I have deleted 4 site collections with total 30 subsites (approx), but still the "WSS_Content"

content db is showing the same size (160GB) Why?

How do i delete these site collections from content db?

-Thanks,

Waqas Sarwar · Answer

Deleting site collection will release the storage back to disk rather create Unused space inside Database. here are the steps you have to follow. Delete the required Site collections (you already deleted 4) Remove the site collection from Central admin recyclebin (remove-spdeletedsites /sites/name) Now manually run gradual site delete timer job Now if you check the size of database, you will see unused space inside it (which is almost close to the amount of size of deleted sites) Now you have to shrink the content database to get the space back to os

Thuyavan Ganesan · Answer

Hello Nagabhushana, As I described in my other thread please use those cmd to delete them. your deleted site collections are in SPDeleteSite Object To remove the SP site collection from this object remove Remove-SPDeletedSite Please let me know if that works Thanks, Thuyavan ------------------------------------------------------------------------------------------------------------ Your feedback is very valuable and your “likes” are energy boosters for us to keep blogging

Nagabhushana Bs · Answer

Thanks Waqas. I will try this.

How do i delete these site collections from content db?

Answers (3)