October 29, 2013 at 3:51 am
if any of the log backup file is deleted ,,,, is it possible to resume logshipping without reconfiguring/full backup and how ??
October 29, 2013 at 4:55 am
No. Deleted log file breaks the log chain (among the nasty things if can do), so you need a full or diff backup (probably full) applied to the secondary to restart log shipping.
Don't delete the log. It's not an optional file.
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
October 30, 2013 at 7:26 am
Just to clarify further...
Only if you didn't apply any Tlog backup your diff backup will work. Differential backup can't be apply on secondary server if subsequent tlog backups have successfully applied on secondary server and missing a tlog backup.
HTH
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
October 30, 2013 at 10:03 am
to clarify free_mascots point, you can restore from a differential if a full backup has not been taken of the primary at a point after the last successful log restore.
---------------------------------------------------------------------
October 31, 2013 at 12:53 am
free_mascot (10/30/2013)
Just to clarify further...Only if you didn't apply any Tlog backup your diff backup will work. Differential backup can't be apply on secondary server if subsequent tlog backups have successfully applied on secondary server and missing a tlog backup.
HTH
Correct
Regards
Durai Nagarajan
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply