How to clean the database on the server ?
Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: General Discussion
Forum Description: General discussion and chat on any topic.
URL: https://forums.webwiz.net/forum_posts.asp?TID=10838
Printed Date: 31 March 2026 at 6:33pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: How to clean the database on the server ?
Posted By: Ivar
Subject: How to clean the database on the server ?
Date Posted: 12 June 2004 at 8:58am
|
Hello, When I go to admin, I can clean out old topics and PM's. But they stay on the server's database. Great thankxs |
Replies:
Posted By: dpyers
Date Posted: 12 June 2004 at 12:43pm
|
You can think of deleteing a record from a data base as just setting a flag saying it's no longer available. You then need an external process to remove those records and rewrite/reindex/resequence the db without them. With MS access, you have to do a compact and repair to free up the space used by deleted records. This is an item in the admin menu. With MS SQL, it's a little more mystical. You need to adjust your logging and other options. MS SQL Server BooksOnline covers this in some depth. You should read up on it before doing anything as some of the options don't do what you'd think they would. ------------- 
Lead me not into temptation... I know the short cut, follow me. |
Posted By: pmormr
Date Posted: 12 June 2004 at 8:35pm
|
[quote] ------------- Paul A Morgan http://www.pmorganphoto.com/" rel="nofollow - http://www.pmorganphoto.com/ |
a little more mystical.