database size ?
Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=21685
Printed Date: 08 April 2026 at 7:07pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: database size ?
Posted By: Flyman30
Subject: database size ?
Date 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? |
Replies:
Posted By: WebWiz-Bruce
Date 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. ------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
Posted By: Flyman30
Date Posted: 23 October 2006 at 11:36am
Thank 
|