Trunc log in sql 6.5

[uncLez]

Hi all,

I am having trouble finding a solution for the following.
In SQL 6.5 we would like to schedule a log trunc right after we have a scheduled backup of our database, since this particular database has vast amounts of transfers and sometimes exceeds the log size.

Is there a way in SQL Server 6.5 that we can schedule this? I have been looking for quite some time, but all I seem to be able to find is is the addjob and schedulejob thingies for sql server 2000.

Any help appreciated,
thanx in advance,
Anton de Wit.

 

[uncLez]

Sorry, just to prevent any misunderstanding, I am talking about the transaction log here...

 

[MikeTom]

In enterprise manager select the database then go server -> scheduled task . their you can create a scheduled task usind tsql or run a stored procedure. the way i do it is i backup the transaction logs to a backup device then truncate them.the code shown below.
DUMP TRANSACTION <Database> TO <Backup Device> WITH NOUNLOAD , STATS = 10, NOINIT , NOSKIP

 

[uncLez]

I'll look into it and test some scripts,
thanx very much so far!