I have a question regarding log backups etc, so here goes.

I backup my database doing a complete backup and overwrite every Sunday night. I then backup the logs doing an append every day once every 30 minutes between 0700 and 1900 hours.

I understand that my log will just grow and grow, correct me if I am wrong. What I want to be able to do is to only keep say, a months worth of logs. Is this possible, if so, how do I set this up to work?

Thanks

Neil.

check out the retaindays and expiredate of the backup command in sql server books online.

I would not recommend appending backups to a backup device. Too many times I've seen backup device corruption, and when it happens, - nothing is accessible from that file.

Neil,

From Data Maintenance Plans, you can set up 'Transaction Log Backup' will be removed files older than 1 month.

VanDBA