Warwick rudd (6/20/2011)
How did you come to the decision that you need a full backup taken on a Monday , with differential backups taken on every other day , with 5 minute Tlog backups ?How large is your database ? How much data changes and how frequently ? A 5 minute Tlog backup could be a huge overkill but not knowing your system I can not say for certain.
Do you have some sort of backup retention plan ?
What is the reasoning behind the frequency of your Tlog backups ? Are you performing log shipping ?
I am assuming that you can not afford to loose more than 5 minutes worth of transactions.
Depending on your Recovery Point Objectives (RPO) & Recovery Time Objectives (RTO) will play a part on your backup and recovery strategy.
If you do not know the answers to these it makes it difficult to implement an appropriate strategy.
This is just my own recommendation. Below are my scenario, the SQL Database will experience many transactions every second, hence the transaction log size will grow rather quickly. I need some suggestions of a backup plan that has backups for FULL, INCREMENTAL and LOG backups, which factors in the relationship of the 3 backups.
Currently the database data is stored a SAN storage and the backup will be backed up to a separate storage device that emulates a tape backup device. Everything is running in a 64bit environment.
Regards to the backup tapes, The transaction log might grow up to 5GB, so we are potentially looking at 5GB worth of backup daily. Is it best to reuse the same tape for the transaction log? or is rotating 2-3 tapes for the log would be good?