I'm setting up two devices to handle the backup of my database: one for the database itself and one for it's transaction log.
The database will be backed up once a day, and the device will be overwritten (INIT) so there is only one copy of the database at any given time within that device.
For the transaction log device, I'd like to backup the t-log once an hour between a given time period (say 6AM to 9PM, then DB Backup at 10PM). I only want to have one day's worth of transaction logs in the t-log device. The command at this time is has WITH NOINIT, RETAINDAYS=1. However, doing this just grows the device even if the t-logs are beyond their retention dates.
Is there no way to cycle the backups without including a prior job in the morning to INIT the entire backup device? Or is there no way to just have a job backup the logs to overwrite an existing log in the device that is past its retention date?
Thanks for the insight!
WDFog
The database will be backed up once a day, and the device will be overwritten (INIT) so there is only one copy of the database at any given time within that device.
For the transaction log device, I'd like to backup the t-log once an hour between a given time period (say 6AM to 9PM, then DB Backup at 10PM). I only want to have one day's worth of transaction logs in the t-log device. The command at this time is has WITH NOINIT, RETAINDAYS=1. However, doing this just grows the device even if the t-logs are beyond their retention dates.
Is there no way to cycle the backups without including a prior job in the morning to INIT the entire backup device? Or is there no way to just have a job backup the logs to overwrite an existing log in the device that is past its retention date?
Thanks for the insight!
WDFog