Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

log file deleted Expand / Collapse
Author
Message
Posted Tuesday, October 29, 2013 3:51 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, June 28, 2016 7:02 PM
Points: 217, Visits: 650
if any of the log backup file is deleted ,,,, is it possible to resume logshipping without reconfiguring/full backup and how ??
Post #1509239
Posted Tuesday, October 29, 2013 4:55 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Yesterday @ 5:18 AM
Points: 45,619, Visits: 44,147
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

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1509266
Posted Wednesday, October 30, 2013 7:26 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, March 17, 2016 5:13 AM
Points: 2,796, Visits: 2,232
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."
Post #1509763
Posted Wednesday, October 30, 2013 10:03 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Wednesday, November 16, 2016 9:57 AM
Points: 6,147, Visits: 13,680
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.

---------------------------------------------------------------------

Post #1509855
Posted Thursday, October 31, 2013 12:53 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, November 28, 2016 5:55 AM
Points: 1,075, Visits: 2,770
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
Post #1510036
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse