Expected SQL Server 2005 / 2008 size

[SuperMindConsulting]

Can someone please tell me the average size that the database grows to?

Basically, we are trying to get some quotes for a shared or virtual server hosting, but need to know an accurate range for the DB size (including the log file). We don't under/over buy.

Expected store size in 1st year:
- 3000-5000 products (importing from old system)
- 20-50 sales per day (online and offline)
- average 2-3 items per ticket
- # visitors unknown - new website for furniture store

Thanks for any/all help.

[frankenstein897]

I am curious what the expected database size is too. Mine is currently 16GB with 1200 products, 8000 rows in the user table, and only 600 orders. Seems kind of large for such a small amount of orders.

[AbleMods]

Mine is currently 16GB with 1200 products, 8000 rows in the user table, and only 600 orders

Something else is wrong. 16Gb is an insane size for those record counts.

One of my sites has been up 5 years. Over 7,000 orders. 49,000+ user records. 20,000+ products. Database is less than 1Gb in size.

check your record counts in ac_PageViews, ac_Baskets, ac_BasketItems.

Something is not purging like it should, or your db is pre-configured to be 16Gb in size. Or a SQL Admin hasn't configured your database for regular maintenance.

[jmestep]

I think he found out the problem from another one of his posts- full recovery log and transaction log
viewtopic.php?f=65&t=16819

[frankenstein897]

Yep, moving to simple recovery reduced it down to 50MB.

[AbleMods]

Wow!