SQL db size will not decrease after ...
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=10755
Printed Date: 08 April 2026 at 12:46pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: SQL db size will not decrease after ...
Posted By: FARSHAD
Subject: SQL db size will not decrease after ...
Date Posted: 06 June 2004 at 5:24am
|
Hi I have this forum on my site My db size is now 3.4 MB but when i delete posts on my forum and users the db size don`t decrease and it`s still remain on 3.4 MB
what happened? Thanks |
Replies:
Posted By: Semikolon
Date Posted: 06 June 2004 at 12:47pm
|
are you sure you are using MS SQL Server? if you have access you must do a compact and repair. If you have SQL Server it will decrease by itself I think.. but 3.4 MB is not much when you use SQL Server.. you can also ask your host to do a maintenace operation once a month or week or whatever, I think that will clean up all unnecessary sh*t in the database |
Posted By: dpyers
Date Posted: 06 June 2004 at 5:32pm
|
MS SQL server has options that control things like autoshrinking, logfile size, etc. Usually managed through something like Enterprise Manager. Deleted stuff is often written to the logfile, which is part of your space allocation. MS SQL Server 2000 BooksOnline does a pretty good job on covering the topic. Strongly suggest you read it before playing with the DB as some of the settings don't do what you would think they do. ------------- 
Lead me not into temptation... I know the short cut, follow me. |