January 27, 2023 at 3:58 am
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)?
January 27, 2023 at 11:02 am
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.
January 27, 2023 at 5:18 pm
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
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply