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 Shipping, daily backup's on primary Expand / Collapse
Author
Message
Posted Thursday, December 12, 2013 7:35 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, April 17, 2014 10:05 PM
Points: 83, Visits: 201
I have log shipping configured to send logs from primary to secondary every 20 mins, all day long.
I also have a daily backup (full backup)job that runs on the primary database. How does this effect log shipping transaction logs that get shipped to secondary. Do I need to refresh the database on the secondary?Should I have any concerns?
Post #1522313
Posted Thursday, December 12, 2013 8:32 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Friday, January 03, 2014 3:52 PM
Points: 6,066, Visits: 5,277
The full backups should not affect the log shipped databases.

CEWII
Post #1522343
Posted Thursday, December 12, 2013 9:47 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 5:25 PM
Points: 5,849, Visits: 12,586
as elliot said, no.

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

Post #1522385
Posted Thursday, December 12, 2013 10:53 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, April 17, 2014 10:05 PM
Points: 83, Visits: 201
Thanks!
Post #1522416
Posted Monday, December 16, 2013 7:27 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, April 16, 2014 2:08 AM
Points: 1,350, Visits: 15,200
The only backup which could adversely affect logshipping is a log backup from another source, such as a manual transaction log backup. This would break the LSN chain.
Post #1523219
Posted Monday, December 23, 2013 1:44 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: 2 days ago @ 10:50 AM
Points: 28, Visits: 120
how about diff. backups? will this break LSN?
Post #1525626
Posted Monday, December 23, 2013 1:52 PM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 5:25 PM
Points: 5,849, Visits: 12,586
smtzac (12/23/2013)
how about diff. backups? will this break LSN?


No


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

Post #1525631
Posted Monday, December 23, 2013 1:53 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Friday, April 04, 2014 3:32 PM
Points: 205, Visits: 830
Nope!
Post #1525632
Posted Sunday, December 29, 2013 1:37 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 1:26 PM
Points: 5,961, Visits: 12,847
Elliott Whitlow (12/12/2013)
The full backups should not affect the log shipped databases.

CEWII

Directly, no. Indirectly for the reason listed below


george sibbald (12/23/2013)
smtzac (12/23/2013)
how about diff. backups? will this break LSN?


No

It will break the differential base LSN between the primary and secondary until the databases are in synch.


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

"Ya can't make an omelette without breaking just a few eggs"
Post #1526365
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse