How to manage SQL Server Log file?

Question

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.

Answer 1

Try to write corresponding job, which will back the log up, or create the simple Maintenance Task for this. The command is quite simple:

BACKUP LOG YourDb TO YourBackupDevice;