I'm pretty new to sql and have a few questions. If I schedule a full backup to run on a database every-night, why do I also need to backup the transaction logs.
What is a transaction log? and why is it important that it also gets backup-ed with the database.
I read on a forum that a transaction log should be backed up every 10 mins or so, is that true?
also, my backups go into a "backup folder" on my c drive. They are not overwritten just added to that folder. Is it safe for me to manually delete database and transaction-log backups that are older then a week or so, or is there a more proper way of doing this then just hitting delete?
I'm using sql2008