DataBase Retention Policy – Backup Data Aging

Standard

While doing data backups, we should keep in mind the ” Backup Data Retention Policy”, as if data keeps on backing up on the file system, it will occupy lot of space and in one point in time the “Backup will Fail”, like it happened with me.

Full data backup was failed and it was giving error that media space is not sufficient, then we defined our Backup Data Retention Policy so that after 2 complete sets of data the full backup data should be deleted. Like

 

Full Backup 1 – 1 August 2014

Full Backup 2 –  8 August 2014

Full Backup 3 – 15 August 2014

Full Backup 4 –  22 August 2014

 

On 22 August 2014, the Full Backup 1 will be deleted as system is maintaining last 2 cycle OR last 2 Full Data Backups.

It is very sensitive to define Data Aging, Storage Policy and Backup Data Retention Policy as slight mistake or error could loose useful data. When you do so, keep on monitoring the data and backups on regular basis, and try to restore it frequently for testing purpose.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s