Web Wiz Support and Community Forums : Huge DB and Log files https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Wed, 08 Apr 2026 16:13:59 +0000 Sat, 03 Jul 2004 12: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=11026 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[Huge DB and Log files : How do I do the shrinkdatabase...]]> https://forums.webwiz.net/huge-db-and-log-files_topic11026_post61015.html#61015 Author: pvillaca
Subject: 11026
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!

]]> Sat, 03 Jul 2004 12:36:41 +0000 https://forums.webwiz.net/huge-db-and-log-files_topic11026_post61015.html#61015 <![CDATA[Huge DB and Log files : That is way to big unless you...]]> https://forums.webwiz.net/huge-db-and-log-files_topic11026_post60837.html#60837 Author: michael
Subject: 11026
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.]]> Wed, 30 Jun 2004 22:33:11 +0000 https://forums.webwiz.net/huge-db-and-log-files_topic11026_post60837.html#60837 <![CDATA[Huge DB and Log files : Dear friends, I&#039;ve installed...]]> https://forums.webwiz.net/huge-db-and-log-files_topic11026_post60622.html#60622 Author: pvillaca
Subject: 11026
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?

]]> Mon, 28 Jun 2004 14:42:43 +0000 https://forums.webwiz.net/huge-db-and-log-files_topic11026_post60622.html#60622