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?
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?
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.
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?
Just to clear: If I truncate PreviewXML, will that crash the website and the back-end?
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
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.
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
is working on a reply...