Unsolved
This post is more than 5 years old
4 Posts
0
1446
January 30th, 2013 12:00
Networker hourly backups
Hi All,
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 ?
Thank you for feedback.
BR,
ted
No Events found!
ble1
6 Operator
•
14.4K Posts
•
56.2K Points
1
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).
Travis_Baker
3 Posts
0
February 10th, 2013 14:00
I've done this in our environment.
We use 2 different groups.
1 group does the fulls at a set time and the other runs the incrimentals hourly.
I also added a probe that checks to see if a backup is already running so the incrimentals dont try to start when the full is running.
ble1
6 Operator
•
14.4K Posts
•
56.2K Points
0
February 11th, 2013 02:00
As of 5.2.2 this is no longer needed (as they fixed the issue inside with concurrent TLOG and DB runs).
Travis_Baker
3 Posts
0
February 12th, 2013 06:00
Good to know thanks!
Sent from my iPhone