Web Wiz - Green Windows Web Hosting

  New Posts New Posts RSS Feed - database size ?
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

database size ?

 Post Reply Post Reply
Author
Flyman30 View Drop Down
Groupie
Groupie
Avatar

Joined: 09 December 2004
Location: France
Status: Offline
Points: 99
Post Options Post Options   Thanks (0) Thanks(0)   Quote Flyman30 Quote  Post ReplyReply Direct Link To This Post Topic: database size ?
    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?
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post 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
Back to Top
Flyman30 View Drop Down
Groupie
Groupie
Avatar

Joined: 09 December 2004
Location: France
Status: Offline
Points: 99
Post Options Post Options   Thanks (0) Thanks(0)   Quote Flyman30 Quote  Post ReplyReply Direct Link To This Post Posted: 23 October 2006 at 11:36am
Thank Smile
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.


Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.