Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Fredrik Esseen 610 posts 906 karma points
    Jun 16, 2011 @ 12:43
    Fredrik Esseen
    0

    DB is filling up

    Hi!

    I have a problem with one of my 4.7 installations, MS SQL

    This is a fairly new site that starts to complain about the Primary Filegroup is full when I try to save and publish.
    When I look at the db I can see that PreviewXML and PropertyData is huge.

    I can also see that the tables has an amount of kb reserved and they are almost full.

    Is it possible to delete the records for PreviewXML?

  • Fredrik Esseen 610 posts 906 karma points
    Jun 20, 2011 @ 10:44
    Fredrik Esseen
    0

    Just to clear: If I truncate PreviewXML, will that crash the website and the back-end?

  • Steen Tøttrup 191 posts 291 karma points c-trib
    Jun 20, 2011 @ 12:01
    Steen Tøttrup
    0

    I've just truncated the cmsPreviewXml table on a demo site of mine, and the site still runs. I think the table is used when you preview a page, and the content is rebuilt (per page) when you preview it again.

    What are we talking about here? Giagbytes of data or?

    What type of database is the site running on?

    regards, Steen

     

  • Fredrik Esseen 610 posts 906 karma points
    Jun 20, 2011 @ 12:13
    Fredrik Esseen
    0

    No , not that kind of amount at all. PreviewXML is 2,5 mb but the Primary Filegroup has only 9,38mb reserved?

    Im not an expert of storage space with Sql Server but isnt that quite little space?

    This is a SQL Server Standard Edition 64Bit on a web host.

  • Steen Tøttrup 191 posts 291 karma points c-trib
    Jun 20, 2011 @ 12:38
    Steen Tøttrup
    1

    You should be able to truncate without any issues.

    10mb wont get you far at all. A lot of web hosts have limits on the amount of DB storage you get for the price you pay, but 10mb is simply not enough for anything, unless you've got a really simple site with only a few document types and content elements.

    You should look into the agreement you have with the web host.

    regards, Steen

Please Sign in or register to post replies

Write your reply to:

Draft