Deleting large site collections - How long to wait before deleting the content DB from SQL?


  • I have full backups of this site collection and content DB and now I am deleting a large (1 TB+) site collection from Central Admin and saw a note about: "When you delete a large site, SharePoint removes data gradually for performance reasons."

    I also know that deleting the site collection this way does not remove the actual content DB from SQL. So, my questions are:

    How can I monitor the site collection deletion progress? 

    When is it safe to delete the content database?


    Thursday, March 02, 2017 3:28 PM


  • Hi,

    You can access CA > Application Management > Manage content databases, check for the number of site collection under a content database.

    If it’s zero, which means you can remove the content database from SQL.

    Best Regards,

    Dean Wang

    Please remember to mark the replies as answers if they help.
    If you have feedback for TechNet Subscriber Support, contact

    • Marked as answer by ZachSaltzman Friday, March 03, 2017 2:39 PM
    Friday, March 03, 2017 7:26 AM