Web Wiz Support and Community Forums : Compacting DB https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Thu, 09 Apr 2026 03:05:20 +0000 Tue, 21 Sep 2004 23:29:17 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=11859 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[Compacting DB : Thanks everyone. will try again!...]]> https://forums.webwiz.net/compacting-db_topic11859_post66009.html#66009 Author: Muskan
Subject: 11859
Posted: 21 September 2004 at 11:29pm

Thanks everyone. will try again!]]> Tue, 21 Sep 2004 23:29:17 +0000 https://forums.webwiz.net/compacting-db_topic11859_post66009.html#66009 <![CDATA[Compacting DB : Also, check with your isp. Some...]]> https://forums.webwiz.net/compacting-db_topic11859_post65971.html#65971 Author: dpyers
Subject: 11859
Posted: 21 September 2004 at 1:49pm

Also, check with your isp. Some have disabled the ability to alster the script timeout value in code. IIRC, you won't see any message indicating that your script timeout value is to high.]]> Tue, 21 Sep 2004 13:49:26 +0000 https://forums.webwiz.net/compacting-db_topic11859_post65971.html#65971 <![CDATA[Compacting DB : When you C/R it using the script,...]]> https://forums.webwiz.net/compacting-db_topic11859_post65923.html#65923 Author: xeerex
Subject: 11859
Posted: 21 September 2004 at 9:24am

When you C/R it using the script, it creates a xxx-bak.mdb file as tehbackup then deletes that backup after success. If you had problems thefirst time, the backup is still on the server and will give errors thenext time.

FTP into your site and delete the backup.
Lock teh forums.
Run the script again.
Unlock the forums after success.

If it fails again, lock the forums, download the database, do a C/R locally, upload the database and unlock it.

BTW, you can read some of my other posts about the number of users ANDconcurrent connections that I keep on my Access powered forum. Is MSSQLbetter? Yep. Can you run a forum on access with a decent amount oftraffic? Yep.
]]> Tue, 21 Sep 2004 09:24:54 +0000 https://forums.webwiz.net/compacting-db_topic11859_post65923.html#65923 <![CDATA[Compacting DB : Thanks everyone. We would be migrating...]]> https://forums.webwiz.net/compacting-db_topic11859_post65880.html#65880 Author: Muskan
Subject: 11859
Posted: 20 September 2004 at 11:06pm

Thanks everyone. We would be migrating to SQL Server in a couple of weeks.

For the time being, I did lock the forums before compacting it. Also raised the script timeout to 300. The standard given for the admin pages in 90.

It still does not work!

Any Ideas?

]]> Mon, 20 Sep 2004 23:06:27 +0000 https://forums.webwiz.net/compacting-db_topic11859_post65880.html#65880 <![CDATA[Compacting DB : Phat wrote: dpyers wrote: With...]]> https://forums.webwiz.net/compacting-db_topic11859_post65788.html#65788 Author: dpyers
Subject: 11859
Posted: 20 September 2004 at 8:59am

Originally posted by Phat Phat wrote:

Originally posted by dpyers dpyers wrote:

With that size of a db in particular, make sure you lock the forums before compacting.



The only problem with this is the pages need to access the db to see if the db is locked anyway. There must be a better way to do this like a text file or something.

The best way is to lock the db, download it, back it up, and compact+repair it locally. When you upload it back again, ater the c+r, delete the .ldb file then unlock it. The .ldb file tracks who (not a wwf userid - it's a generic session-based who) is currently doing what on the db.

People often report problems with the db being corrupted after doing a compact+repair and they have to do another c+r. I think the main reason that happens is that people are trying to do adds, changes, and deletes - or had an updatein progress while an unlocked db is being compacted. After you lock an access db, you need to wait a minute to let it quiesce - allow the access engine time to complete transactions in progress.

Just trying to read a db being c+r'd doesn't affect the internal indexes like updates/deletes will. I think Access is supposed to dis-allow updates while a c+r is in progress, but I don't believe that's 100% reliable and results may vary depending upon the access engine specified in the connection string and the connection method used - better off to lock the db and allow it time to quiesce if you can't download it.

]]> Mon, 20 Sep 2004 08:59:51 +0000 https://forums.webwiz.net/compacting-db_topic11859_post65788.html#65788 <![CDATA[Compacting DB : dpyers wrote:With that size...]]> https://forums.webwiz.net/compacting-db_topic11859_post65774.html#65774 Author: Phat
Subject: 11859
Posted: 20 September 2004 at 6:51am

Originally posted by dpyers dpyers wrote:

With that size of a db in particular, make sure you lock the forums before compacting.



The only problem with this is the pages need to access the db to see ifthe db is locked anyway. There must be a better way to do this like atext file or something.

]]> Mon, 20 Sep 2004 06:51:16 +0000 https://forums.webwiz.net/compacting-db_topic11859_post65774.html#65774 <![CDATA[Compacting DB : with that many users i wouldnt...]]> https://forums.webwiz.net/compacting-db_topic11859_post65769.html#65769 Author: typhoon
Subject: 11859
Posted: 20 September 2004 at 5:14am

with that many users i wouldnt go with an Access DB as backend :-)]]> Mon, 20 Sep 2004 05:14:41 +0000 https://forums.webwiz.net/compacting-db_topic11859_post65769.html#65769 <![CDATA[Compacting DB : With that size of a db in particular,...]]> https://forums.webwiz.net/compacting-db_topic11859_post65749.html#65749 Author: dpyers
Subject: 11859
Posted: 19 September 2004 at 4:43pm

With that size of a db in particular, make sure you lock the forums before compacting.

]]> Sun, 19 Sep 2004 16:43:39 +0000 https://forums.webwiz.net/compacting-db_topic11859_post65749.html#65749 <![CDATA[Compacting DB : Any idea what would be the ideal...]]> https://forums.webwiz.net/compacting-db_topic11859_post65735.html#65735 Author: Muskan
Subject: 11859
Posted: 19 September 2004 at 8:58am

Any idea what would be the ideal time for compating that db

 

]]> Sun, 19 Sep 2004 08:58:18 +0000 https://forums.webwiz.net/compacting-db_topic11859_post65735.html#65735 <![CDATA[Compacting DB : you can over ride the script time...]]> https://forums.webwiz.net/compacting-db_topic11859_post65733.html#65733 Author: dj air
Subject: 11859
Posted: 19 September 2004 at 6:21am

you can over ride the script time out by adding the following to the top of the asp page

server.ScriptTimeout = x

(x = secounds)

]]> Sun, 19 Sep 2004 06:21:25 +0000 https://forums.webwiz.net/compacting-db_topic11859_post65733.html#65733