+1-888-365-2779
Try Now
More in this section

Forums / Developing with Sitefinity / sf_VrsTxtData is too huge

sf_VrsTxtData is too huge

3 posts, 1 answered
  1. Bruno Michels
    Bruno Michels avatar
    125 posts
    Registered:
    16 Apr 2010
    12 Aug 2010
    Link to this post
    Could not allocate space for object 'dbo.sf_VrsTxtData'.'PK_sf_VrsTxtData' in database 'redimob' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.

    How can I delete old versions to get some space on my database?

    And also, the table sf_VrsBinData is also very big, for what is this table used for? (I've set to store the libraries images on files, so I guess it is not related to libraries)
  2. Radoslav Georgiev
    Radoslav Georgiev avatar
    3370 posts
    Registered:
    01 Feb 2016
    12 Aug 2010
    Link to this post
    Hi Bruno Michels,

    Thank you for using our services.

    The version tables store data for different versions of your content items. The sf_VrsBinData stores binary information for versions of content items. The binary data is library items' content -  images, documents, videos, etc. You can reduce the sizes of those tables by deleting items you can run scripts against the db which will delete content from those tables. You can find samples on how to achieve this in the following KB article.

    Also if for some module you do not use versioning you can disable this feature. The KB article has a sample on how to disable this for News.

    Regards,
    Radoslav Georgiev
    the Telerik team
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
    Answered
  3. Bruno Michels
    Bruno Michels avatar
    125 posts
    Registered:
    16 Apr 2010
    12 Aug 2010
    Link to this post
    Thank you!

    From 100MB now it's 47MB.
Register for webinar
3 posts, 1 answered