November 4, 2012 at 1:07 pm
I have full backup job on 5.10 and log backup at every 15 minutes
If I restore the full backup from 5.10 and the log backups performed after 5.15 there is any possibility to miss or duplicate any transaction?
November 4, 2012 at 5:20 pm
No.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 6, 2012 at 1:13 pm
GilaMonster (11/4/2012)
No.
not even if I restore same log twice?
November 6, 2012 at 1:51 pm
SQL won't let you restore the same log backup twice.
There is absolutely no chance whatsoever of ever being able to miss transactions in the middle or restore transactions twice when restoring full, diff and log backup sequence.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply