none
SharePoint 2013 - Deleting a subsite is not reducing the DB size RRS feed

  • Question

    Dear All,

    Below is the issue we face with one of our customer

    1.     We have a site collection  say (SiteCollection A) – which has 3 subsites (Subsite A, Subsite B and Subsite C) – all together when taking SharePoint backup(Powershell) it comes around 160 GB. Here the most data is in 2 subsite (Subsite A and Subsite B) almost 3 lacs document in this. Subsite c has only 500 documents.
    2.        Our objective is to move the Subsite A and Subsite B to separate site collections. To do so we need to reduce the site collection size less than 100 GB.
    3.        So, what we have done is we have exported Subsite A Subsite B, and we have the same in another .cmp files in another drive
    4.        Now, we have deleted Subsite A and Subsite B from the SiteCollection A, and took the backup again . Even now the site collection A, backup size is still 160GB L
    5.        Note – we have emptied all site collection recycle bins, restarted servers, manually run the site collection gradual delete timer job and nothing worked for us.

    can anyone  help us on this? Or any other alternate method to achieve our functionality?

    Regards,

    Karthikanandh

    Monday, April 11, 2016 10:28 AM

Answers

All replies

  • By design, the SQL database size does not reduce after deleting files/sites.

    Did you try to shrink the SharePoint database data file? If not, try to shrink and re-index before taking a backup.


    Cheers,

    Visual Studio Developer Tools Download

    Monday, April 11, 2016 10:50 AM
  • Dear ,

    Yes i have done both. But still the same :(

    Is there any other workaround?

    regards,

    Karthikanandh

    Monday, April 11, 2016 10:52 AM
  • Agree with Prasath.

    Database shrinking increases fragmentation ratio in database. So its recommended to rebuild index after it.


    Thanks
    Mohit

    Monday, April 11, 2016 10:53 AM
  • Hi Karthikanandh

    How large is tempdb on sql server and how long ago you have deleted sites?


    Thanks
    Mohit

    Monday, April 11, 2016 11:07 AM
  • Hi Karthikanandh,

    According to your description, deleting site cannot reduce the database size.

    Removing documents from SharePoint does not change the size of the content database. It´s simply how SQL works. You can shrink the database, but it’s apparently like swearing in church for the database mafia.

    Here are the steps:
    1. Removed all the documents from the website.
    2. Did a sharepoint backup of the site
    3. Created a new web application
    4. Performed a sharepoint restore to the new web application
    (5. you can detach and attach the databases to get the smaler database back on the first web application if you like to).

    Please refer to the link for details:
    https://sharepointkaos.wordpress.com/2013/08/15/reduce-the-size-of-the-sharepoint-content-database-without-shrinking-it/

    Best Regards,

    CY


    TechNet Community Support
    Please remember to mark the replies as answers if they help, and unmark the answers if they provide no help. If you have feedback for TechNet Support, contact tnmff@microsoft.com.

    Tuesday, April 12, 2016 7:47 AM
    Moderator
  • Hi Karthikanandh,

    Any update?

    Best Regards,

    CY


    TechNet Community Support
    Please remember to mark the replies as answers if they help, and unmark the answers if they provide no help. If you have feedback for TechNet Support, contact tnmff@microsoft.com.

    Friday, April 22, 2016 1:44 AM
    Moderator