April 3, 2008 at 5:01 am
Hi,
I'm using full backup on a database every night and want to backup the logfiles every hour.
I want to backup all the logfiles from the point of the full backup to the next full backup so that there are always 1 full backup file and 24 log backup files.
I'd like to use INIT, so the log backup file doesnt grow to much.
Do I have to name each backed up file in a special way (name=backup+hour(getdate()) or something like that) or how do I ensure that the log backup does not overwrite the log former log backup file?
Or is that a bad method?
April 3, 2008 at 5:11 am
If you want to use init, then you could create 24 log backup files, and every hour you would back up to the relevant file only. You will have only one file for each backupset, but this approach is a bit "clumsy"
You could also back up only the first log backup of the day with init, and all the subsequent log backups could go to the this backup file. I.e. the first backup would clean the log entries that are no longer needed.
Regards,
Andras
April 3, 2008 at 5:28 am
just to make sure I understood that right:
I schedule the following steps
-Full Backup at lets say 00:00
-Log Backup with INIT at 00:30
-Log Backup with NOINIT every hour, starting from 01:00 using the same filename as the step above
that would result in 2 files, one with the full backup and one that contains all logbackups since 00:30 of the current day
is that correct?
April 3, 2008 at 5:57 am
Michael Niemand (4/3/2008)
just to make sure I understood that right:I schedule the following steps
-Full Backup at lets say 00:00
-Log Backup with INIT at 00:30
-Log Backup with NOINIT every hour, starting from 01:00 using the same filename as the step above
that would result in 2 files, one with the full backup and one that contains all logbackups since 00:30 of the current day
is that correct?
If you want to have only a few files, and discard previous log backups this way the above should work.
(you could also use the full backup file for the log backups (in this case make sure that only the full backup is using init). But remember, that backups may fail! do not loose your only backup file this way.
Regards,
Andras
Regards,
Andras
April 3, 2008 at 6:07 am
I think I'll go for the one log, one full backup file version.
thank you very much!
:w00t:
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply