backup log to int run every hour. If a log init backup is run at midnight, and then at 3:00 am it is run again by mistake manually. Can an error occur later (for example when restoring the database)?
It can cause issues restoring depending on how you are doing your backups.
If each log backup is run to its own individual timestamped file (as per best practice) then you should be OK as the INIT will only ever reinitialise that particular backup file before writing the new backup data to it.
However if you're backing up to a singular file, then yes you have broken your backup chain.
Recommended practice, back up each time to a new file.
If this feels complex use Ola's script: https://www.sqlservercentral.com/scripts/sql-server-backup-integrity-check-index-and-statistics-maintenance
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Viewing 3 posts - 1 through 2 (of 2 total)