https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Wed, 08 Apr 2026 19:11:06 +0000 Mon, 23 Oct 2006 11:36:41 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=21685 https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ https://forums.webwiz.net/database-size_topic21685_post116010.html#116010 Author: Flyman30
Subject: 21685
Posted: 23 October 2006 at 11:36am

Thank ]]> Mon, 23 Oct 2006 11:36:41 +0000 https://forums.webwiz.net/database-size_topic21685_post116010.html#116010 https://forums.webwiz.net/database-size_topic21685_post116007.html#116007 Author: WebWiz-Bruce
Subject: 21685
Posted: 23 October 2006 at 10:29am

In SQL Server you need to set the recovery model to simple and set the database to auto-shrink.

You may need to get your web host to do this if you find you don't have permission to do this yourself.

With SQL express, this forum currently uses a SQL Express database of 110Mb in size with over 9,000 members and over 90,000 posts.


Edited by -boRg- - 23 October 2006 at 10:30am]]> Mon, 23 Oct 2006 10:29:18 +0000 https://forums.webwiz.net/database-size_topic21685_post116007.html#116007 https://forums.webwiz.net/database-size_topic21685_post116006.html#116006 Author: Flyman30
Subject: 21685
Posted: 23 October 2006 at 9:15am

Hello,

I've updated a forum version base 7.9 access and towards the version 8.04 base sql
server. Everything works with no problems but the base has become enormous. It is a
private forum for a fishing association with 59 members, 11701 messages in 37 subjects
with 6 forums. Altogether the base is 40 mo and the transaction log of the same size.
Questions
Is this a normal size for a small forum?

How can I slim down the base?

    
My host gives me a maximum of 50MO for the base including the transaction log . How do you manage a forum of this size with sqlexpress?
]]> Mon, 23 Oct 2006 09:15:30 +0000 https://forums.webwiz.net/database-size_topic21685_post116006.html#116006