Web Wiz Forums - Db just get bigger and bigger and bigger

Print Page | Close Window

Db just get bigger and bigger and bigger

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=11397
Printed Date: 08 April 2026 at 9:29pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Db just get bigger and bigger and bigger

Posted By: pvillaca
Subject: Db just get bigger and bigger and bigger
Date Posted: 02 August 2004 at 1:09pm

Dear friends,

I'm very worried about my forum and I'm desperate for any help you guys can offer me (just don't tell me I'll have to reinstall the forum and lose all msgs, because the users would kill me - I lost everything when I changed from Access to SQL Server and they were pretty pissed).

The thing is: I have 782 members, 44418 messages, 1377 topics. But my SQL Server DB size is 1493.19 MB; my Log file size is 1441.31 Mb and my Database file size is 51,88 Mb. It's nos proportional.

And the worst thing is: I've batch delected topics a few times now, but the db sizes never decreases. It keeps growing, growing, growing.

Help!!!!!!!!!!!!!!

Replies:

Posted By: WebWiz-Bruce
Date Posted: 02 August 2004 at 2:25pm

SQL server if setup wrong will store every change ever made for recovery purposes this makes your log file get stupidly large as it will grow each time someone even looks at the forum.

Set the recovery model to 'simple' for the database and sellect 'auto shrink'. These can be found under the options tab for the database.

-------------
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: pvillaca
Date Posted: 02 August 2004 at 4:30pm

Ok, Borg, thanks.

I did just as you said, but the DB remained huge, it didn't shrink. AND after that I deleted 175 topics (older than a month without any new post) and it didn't decrease a single byte.

What can I do?????

Posted By: michael
Date Posted: 02 August 2004 at 4:49pm

You don't need to delete Topics, they don't really take a lot of space. After you did what Borg said, run the following 2 commands to first truncate the log file as you should not need it provided you got a backup...
backup log yourdbnamehere with truncate_only
and then run optionally the shrink command to get it to the default growth:
dbcc shrinkdatabase (yourdbnamehere)

-------------
http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker

Posted By: pvillaca
Date Posted: 02 August 2004 at 5:01pm

Yes! It worked!

SQL Server db: BEFORE: 1493.19 MB
AFTER 43.56 MB (wow!)

Log file size: BEFORE: 1441.31 Mb
AFTER: 1 MB (woooow!!!!)

DB file size: BEFORE: 51,88 Mb
AFTER: 42.56 MB

Last question? Could those old settings and huge DB size be responsible for slowing the forum (and, consequently, my whole server) down?

Thanks, you guys!