Gerard,

I don't think there is something out of the box to do what you want, however, you do have the capablilty to do what is needed based on your needs. You will just need to do some research on the product and you should be able to accomplish what you need to have done.

Bonnie replied with your answer on how to purge (or more accurately, truncate) the log. You perform a backup of the log with the truncate option.





>Hi Bob. Thanks for your reply.
>
>If, however, you back up your transaction log, say every hour, you would then be able to recover from your previous nights back up and then apply each log backup up until the time you crashed, thereby only losing at most 1 hour of work............
>
>Thats fine, but is there a way, out of the Sql Server Box, that this can be done programtically. If there is, then my confidence is restored a little bit. if if is'nt, I wonder why Microsoft did not include this as part of SQL server in that its so intinsically a part of the whole security ?
>
>Just as an adide, how do you purge the transaction Log file ?
>
>
>Regards,
>Gerard
>
>
>
>