Web Wiz Forums - Huge DB and Log files

Print Page | Close Window

Huge DB and Log files

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

Topic: Huge DB and Log files

Posted By: pvillaca
Subject: Huge DB and Log files
Date Posted: 28 June 2004 at 2:42pm

Dear friends,

I've installed the SQL Server Forum on June 13th. Today, 15 days later, the SQL Server DB is 254,13Mb and the Log file is 235,56 Mb. The Database file size is 18,56Mb. We have a total of 415 members and about 20,000 messages.

Is that correct? Aren't the files too big? Am I going to experience instability on the forum's performance?

Replies:

Posted By: michael
Date Posted: 30 June 2004 at 10:33pm

That is way to big unless you got some mod to upload files or images as OLE object into the db... If that is a db from you host, they may want to check the fill factor. Do a dbcc Shrinkdatabase and eventually a backup log with truncate only to get the filesize down and see if it keeps happening.

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

Posted By: pvillaca
Date Posted: 03 July 2004 at 12:36pm

How do I do the shrinkdatabase thing? I mean: I logged into my server, right-clicked on the forum database and there was this All Tasks - Shrink DB. Is that it? What options should I use?

It says:

Space allocated: 368Mb
Space free: 33,16Mb (9%)

Shrink action
Maximum free space in files after shrinking: (I have to choose a %)

There's a option of Moving pages to beginning of file before shrinking. Should I check it?

It also gives me the option of shrinking individual files from the DB. What about this?

Thank you!