To enable log backup in SQL the database must be set to recovery model "Full" or "bulk-logged". The key in NetWorker is having a backup group starting in interval of one hour instead of the default 24 hours. Also important is to keep the setting "force incremental: Yes" which will ensure the hourly backup being of level incremental, meaning a log file backup only. Depending on the level set to the client or this group once a day a differential or full backup may be done and then log file backup in hourly interval. Besides this way starting the backup it may be a good idea to store the hourly backup to NetWorker file device first and do a staging to tape device later to avoid numerous mount and positioning operation to tape devices.
"Besides this way starting the backup it may be a good idea to store the hourly backup to NetWorker file device first and do a staging to tape device later to avoid numerous mount and positioning operation to tape devices."
I would suggest using advance file if your licenses permit - this allows the stage operation to continue to operate during your backup operations.
guenterH1
117 Posts
1
July 2nd, 2007 05:00
The key in NetWorker is having a backup group starting in interval of one hour instead of the default 24 hours. Also important is to keep the setting "force incremental: Yes" which will ensure the hourly backup being of level incremental, meaning a log file backup only.
Depending on the level set to the client or this group once a day a differential or full backup may be done and then log file backup in hourly interval.
Besides this way starting the backup it may be a good idea to store the hourly backup to NetWorker file device first and do a staging to tape device later to avoid numerous mount and positioning operation to tape devices.
IKP1
198 Posts
1
July 2nd, 2007 07:00
"Besides this way starting the backup it may be a good idea to store the hourly backup to NetWorker file device first and do a staging to tape device later to avoid numerous mount and positioning operation to tape devices."
I would suggest using advance file if your licenses permit - this allows the stage operation to continue to operate during your backup operations.
IKP
Message was edited by:
IKP