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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy