InstantForum.NET v4.1.4Calyx Software Message Boardhttp://messageboard.calyxsupport.com/support@calyxsoftware.comWed, 07 Jan 2009 17:06:52 GMT20http://messageboard.calyxsupport.com/Topic7207-19-1.aspxThanks. The trans log is now a respectable 100MB.Tue, 30 Sep 2008 16:50:06 GMTm00sehttp://messageboard.calyxsupport.com/Topic7207-19-1.aspxYou can also truncate your SQL log - first make a backup of your data then truncate it. Here's an article from Microsoft with info on SQL transaction logs in SQL Server 2005:<br><br> [url=http://support.microsoft.com/kb/873235]http://support.microsoft.com/kb/873235[/url]<br><br>Good times!<br><br>Tue, 30 Sep 2008 09:23:42 GMTEmmanuel Hunahttp://messageboard.calyxsupport.com/Topic7207-19-1.aspxIt will depend on how far back you want the log to stretch. My recommendation is to pick a week or a month time period measure the delta of file change and set that plus some padding to your size limit.Tue, 30 Sep 2008 06:35:57 GMTBetaFischhttp://messageboard.calyxsupport.com/Topic7207-19-1.aspxSomebody? Anybody?Mon, 29 Sep 2008 14:05:48 GMTm00sehttp://messageboard.calyxsupport.com/Topic7207-19-1.aspxHow large should be PDS transaction log be? My PDS database is 473MB. My trans log is 13.3 GB.Tue, 23 Sep 2008 10:08:42 GMTm00se