Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, August 14, 2014 7:58 AM
Points: 139, Visits: 402
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: Today @ 10:19 AM
Points: 43,026, Visits: 36,192
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 2008, MVP
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: Monday, July 21, 2014 2:56 AM
Points: 2,603, Visits: 2,061
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: Today @ 10:35 AM
Points: 5,992, Visits: 12,940
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: Friday, May 30, 2014 8:15 AM
Points: 1,056, Visits: 2,687
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