Web Wiz Support and Community Forums : Db just get bigger and bigger and bigger https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Wed, 08 Apr 2026 21:36:58 +0000 Mon, 02 Aug 2004 17:01:32 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=11397 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[Db just get bigger and bigger and bigger : Yes! It worked! SQL Server db:...]]> https://forums.webwiz.net/db-just-get-bigger-and-bigger-and-bigger_topic11397_post62984.html#62984 Author: pvillaca
Subject: 11397
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!

]]> Mon, 02 Aug 2004 17:01:32 +0000 https://forums.webwiz.net/db-just-get-bigger-and-bigger-and-bigger_topic11397_post62984.html#62984 <![CDATA[Db just get bigger and bigger and bigger : You don&#039;t need to delete...]]> https://forums.webwiz.net/db-just-get-bigger-and-bigger-and-bigger_topic11397_post62980.html#62980 Author: michael
Subject: 11397
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)

]]> Mon, 02 Aug 2004 16:49:44 +0000 https://forums.webwiz.net/db-just-get-bigger-and-bigger-and-bigger_topic11397_post62980.html#62980 <![CDATA[Db just get bigger and bigger and bigger : Ok, Borg, thanks. I did just...]]> https://forums.webwiz.net/db-just-get-bigger-and-bigger-and-bigger_topic11397_post62978.html#62978 Author: pvillaca
Subject: 11397
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?????

]]> Mon, 02 Aug 2004 16:30:48 +0000 https://forums.webwiz.net/db-just-get-bigger-and-bigger-and-bigger_topic11397_post62978.html#62978 <![CDATA[Db just get bigger and bigger and bigger : SQL server if setup wrong will...]]> https://forums.webwiz.net/db-just-get-bigger-and-bigger-and-bigger_topic11397_post62961.html#62961 Author: WebWiz-Bruce
Subject: 11397
Posted: 02 August 2004 at 2:25pm

SQL server if setup wrong will store every change ever made forrecovery purposes this makes your log file get stupidly large as itwill groweach time someone even looks at the forum.

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


Edited by -boRg-]]> Mon, 02 Aug 2004 14:25:10 +0000 https://forums.webwiz.net/db-just-get-bigger-and-bigger-and-bigger_topic11397_post62961.html#62961 <![CDATA[Db just get bigger and bigger and bigger : Dear friends, I&#039;m very worried...]]> https://forums.webwiz.net/db-just-get-bigger-and-bigger-and-bigger_topic11397_post62943.html#62943 Author: pvillaca
Subject: 11397
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!!!!!!!!!!!!!!

]]> Mon, 02 Aug 2004 13:09:26 +0000 https://forums.webwiz.net/db-just-get-bigger-and-bigger-and-bigger_topic11397_post62943.html#62943