I have an application build on SharePoint 2007 platform, and currently I encounter a common issue where the Database Log file growth rapidly and fill up the hard disk space.
In my situation, I wanted to remain the recovery model as FULL because in future might need for point-in-time recovery and database mirroring.
My question is, how can I perform an automated backup of transaction log regularly? please advice and this is open for any comment.
Thank you in advanced.