First of all, which version of SQL are you using.
If your version is SQL 6.5 or 7.0 (Microsoft), in the porperties of Bata
Base you have the option to check Truncate Transaction Log in check point,
this property allows you in a certain time to truncate the history of
Transaction. I only propouse you if you don't have enough disk space,
because in a critic situation this can be helpfull.
Cheers,
Rafael R. V.
I.T. Manager
----- Original Message -----
From: Crawford Winter <
[email protected]>
To: <
[email protected]>
Sent: Tuesday, January 30, 2001 3:47 PM
Subject: Truncating SQL Transaction Log ~~0:4791
> Problem - SQL transaction log is defined at 19GB of total defined space.
> Actual size of log is 2.2gb.
>
> There was a discussion a while back of how to truncate an SQL transaction
> log and to also reduce the defined size of the log. Can someone please
> remind me on the solution to this problem?
>
> Thanks,
>
> Crawford Winter
> Technical Analyst
> Transamerica Life Canada
>
>
>
>
>
>
>
>
> --------------------------
> To view this thread, visit the JDEList forum at:
>
http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=0&Board=OW&Number=
4791
> *************************************************************
> This is the JDEList One World / XE Mailing List.
> Archives and information on how to SUBSCRIBE, and
> UNSUBSCRIBE can be found at
http://www.JDELIST.com
> *************************************************************