July 26, 2011 at 11:57 pm
If I set up the backup retention period of 10 days.Does it mean that no body can delete that backup file for 10 days except administrator,or Pls clear my confusion.
Thanks
July 27, 2011 at 12:46 am
forsqlserver (7/26/2011)
If I set up the backup retention period of 10 days.Does it mean that no body can delete that backup file for 10 days except administrator,or Pls clear my confusion.
I would like you to explain the question more clearly. By retention period I may deduce two things:
- The organizational retention policy
- the retention policy of the maintenance plan which has a place where you ask it 'to delete files earlier than xx days'
Administrators can delete a backup file if it is not currently used anytime they wish but that should be done as per the policies. I always let my maintenance plan clean up the backup files but in a situation if there is a dire need to delete some recent file, I may do so but I make sure that I have taken a copy elsewhere or my Infrastructure team friends copy the files to tape.
Did you get any hints from my explanation. Let me know if you need to know something specific.
Chandan
July 27, 2011 at 6:06 am
Something else to ponder.
I have a rather low traffic system. Meaning it takes almost 1 month of transactions to get the tlog to grow as big as 1 full DB backup.
In that perspective I started keeping all the logs + 1 full at the begining of this month. I'm currently testing how far back I can keep this history going. Hopefully I can go 1 year with full PIT recovery anytime in the past without going to tape or DVD.
YMWV but you can certainly consider this option too.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply