The database is transactional and I don't mind truncating the older transactions as we have it all backed up but I don't want to truncate recent transactions in the log.

So can you delete lets say transactions in the log that are older than 3 months?

Thanks,
Ninel

Aren't you doing any form of backup? Backups truncate the transaction log and there shouldn't be a need to do this if you are doing backups... and to NOT do backups is death by SQL...

--Jeff Moden