Currently I have a maintenance plan running a Full backup weekly, differential backups nightly, and log backups hourly. The log backups are all going into a single backup file - but it's hard to see what's going on behind the scenes here.
Does this file get 'reset' when the full backup is performed? Will it just keep growing indefinitely and should I be creating new files for each log backup, or manually deleting the file each week during the full backup task?
Thanks
If there's only a single file then all the backups will be appended to that file, even when a full backup is taken. I would change your maintenance task so that each full backup starts a new file. This makes the backups more manageable. Don't delete the previous week's backup file straight away though - keep it around for a week or two just in case you need it.
A few other things I'd recommend if you're not already doing them:
keep the backup files on a different set of drives than the databases
add a step to periodically restore the backups to make sure they're valid - we like to say that you don't have a backup until you know you can restore it
practice doing a disaster recovery from them - point in time restores
No comments:
Post a Comment