what is Networker best practise to run SQL Transaction-Log Backups (incr) from 09:00 to 18:00 every day and also do a full Backup of the same clients at 19:00 every day. How can i schedule hourly backups in networker?
How di i have to deal with different retention periods of the same sql clients ? We plan, that we want to keep the sql Trans-Log Backups for 3 days and the full backups for 10 days. Our backup destination is a DD640, so do i need to save to different media pols ?
I run them every 1h, but this is frequency we chose in mutual talk with DBAs. We actually backup all our database archive logs (Oracle and SAP) and transaction logs (SQL) every 1h. I believe such approach may be overkill so most likely as we implement smarter approach this may change (eg. backup tiering where production and development get 1h backups while test every 4). Frequency you control via interval (by default is 24:00 so you change it to 01:00).
As for different retentions, I'm not big fan of them nor I believe in those. Example, if there is jusified reason to have archive logs every 1h, then this means DBAs/business have to ensure PiT for any of those within backup retention. Period. No discussion. So, I use same retention for both db and tlog - which is similar and close to yours (9 days).
ble1
6 Operator
•
14354 Posts
•
56186 Points
412
1
Posted January 30th, 2013 13:00
I run them every 1h, but this is frequency we chose in mutual talk with DBAs. We actually backup all our database archive logs (Oracle and SAP) and transaction logs (SQL) every 1h. I believe such approach may be overkill so most likely as we implement smarter approach this may change (eg. backup tiering where production and development get 1h backups while test every 4). Frequency you control via interval (by default is 24:00 so you change it to 01:00).
As for different retentions, I'm not big fan of them nor I believe in those. Example, if there is jusified reason to have archive logs every 1h, then this means DBAs/business have to ensure PiT for any of those within backup retention. Period. No discussion. So, I use same retention for both db and tlog - which is similar and close to yours (9 days).