Hi Ton,

There is no 'normal' size for this table. That depends on the number of visitors who place products in their cart.

You can purge the Cart tables by using two SQL orders. Because these tables are used by the customers when they are on line, you must define which are the obsolete carts. Login as host and go to Host > SQL, for delete cart items older than 3 days, enter this SQL order in the text box:

DELETE FROM {databaseOwner}{objectQualifier}Store_CartItems WHERE DateCreated < DATEADD(day, -3, GETDATE())

check 'Run As Script' and click on 'Update'. Then, enter this other order for delete carts older than 3 days:

DELETE FROM {databaseOwner}{objectQualifier}Store_Cart WHERE DateCreated < DATEADD(day, -3, GETDATE())

check 'Run As Script' and click on 'Update'.

I think your database size problem is about the SQLServer log file instead the data file. Could you tell me which is the size of the log file?

Gilles

---

We (team members) are Humans offering their knowledge, their work and their spare time FOR FREE to benefit the community. It would be so particularly appreciated that your messages begin with "Hello" and end with "Thank you" or any other form of politeness. Ask yourself what your reaction would be, if you were approached by me (a total stranger) on the street to ask you something without saying "Hello" nor "Thank you"? After several years of services dedicated to the community, I begin to be tired to read requests without any form of politeness.

Hi Ton,

You misunderstood my comment about the log file. I don't talk about DNN log tables, but about the SQL Server log file. When you create a database with SQL Server, two files are created: dbname_Data.mdf and dbname_Log.ldf. By default, those files are located inside: ..\Program Files\Microsoft SQL Server\MSSQL\Data.

Could you give me the size of both files? Can you access to your database with a tool like Enterprise Manager? I think that your problem is related to the database log file!

Gilles

---

We (team members) are Humans offering their knowledge, their work and their spare time FOR FREE to benefit the community. It would be so particularly appreciated that your messages begin with "Hello" and end with "Thank you" or any other form of politeness. Ask yourself what your reaction would be, if you were approached by me (a total stranger) on the street to ask you something without saying "Hello" nor "Thank you"? After several years of services dedicated to the community, I begin to be tired to read requests without any form of politeness.