More in this section
Forums / Bugs & Issues / Database maintenance Sitefinity 6.2

Database maintenance Sitefinity 6.2

The forums are in read-only mode. In case that you want to directly contact the Progress Sitefinity team use the support center. In our Google Plus group you can find more than one thousand Sitefinity developers discussing different topics. For the Stack Overflow threads don’t forget to use the “Sitefinity” tag.
5 posts, 0 answered
  1. City of Coconut Creek
    City of Coconut Creek avatar
    2 posts
    25 Mar 2015
    25 Mar 2015
    Link to this post


    I recently inherited a Sitefinity 6.2 web site.  One of the concerns is that the Sitefinity MSSQL website is 2GB.  Assets are stored in FileSystem.  In reviewing the tables, I noticed these are pretty large:

    Is there any documentation on how to clean up old data? 

    If we have to manually delete, can we delete based on last_modified, and if so, what are the related tables we should delete rows from as well (what's the PK/FK?)? 



  2. Victor
    Victor avatar
    94 posts
    15 Jun 2011
    25 Mar 2015
    Link to this post

    I'd try to stay away from making direct database changes, it's too easy to miss something.

    If you are going to delete, I'd stick to the API:


    But I think a better solution, is to change the storage provider of the images.


    You can use either the file system or some kind of CDN host like Amazon.  This will free up space in the database, and if you store the images remotely, you'll lessen your server burden a bit.

  3. City of Coconut Creek
    City of Coconut Creek avatar
    2 posts
    25 Mar 2015
    25 Mar 2015
    Link to this post

    I am already using the FileSystem to store files/documents/images.

    With files/documents/images already in the FileSystem, the database is still very large.  I narrowed it down to the above-mentioned tables.  How do I shrink those down?  Is there an admin function I can use?

  4. Markus
    Markus avatar
    2763 posts
    25 Nov 2005
    01 Apr 2015 in reply to Victor
    Link to this post

    Dear Victor 

    This might be totaly unrelated but I had some SQL Database that had a lot of free space reserved.

    After I BACKUP my database I run this script 


    EXEC sp_MSforeachtable @command1="print '?' DBCC DBREINDEX ('?', ' ', 80)"

    Will fill the transaction protocol so you need space and be able to delete the transaction protocol but it helps me to free unused space.

     Not sure if this is for older SQL Servers or working in current ones as well.





  5. Svetoslav Manchev
    Svetoslav Manchev avatar
    735 posts
    06 Sep 2017
    06 Apr 2015
    Link to this post
    Hello Markus,

    Thank you for the shared solution.

    @Keat, you can also take a look on that article.

    Svetoslav Manchev
    Do you want to have your say in the Sitefinity development roadmap? Do you want to know when a feature you requested is added or when a bug fixed? Explore the Telerik Sitefinity CMS Ideas&Feedback Portal and vote to affect the priority of the items
5 posts, 0 answered