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 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: Friday, September 4, 2015 8:59 AM
Points: 83, Visits: 231
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: Thursday, December 17, 2015 11:50 AM
Points: 6,050, Visits: 5,314
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 @ 2:55 PM
Points: 6,073, Visits: 13,425
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: Friday, September 4, 2015 8:59 AM
Points: 83, Visits: 231
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: Monday, September 14, 2015 2:42 AM
Points: 1,332, Visits: 15,308
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 Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, January 14, 2016 7:15 AM
Points: 241, Visits: 944
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 @ 2:55 PM
Points: 6,073, Visits: 13,425
smtzac (12/23/2013)
how about diff. backups? will this break LSN?


No


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

Post #1525631
Posted Monday, December 23, 2013 1:53 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, February 3, 2016 3:31 PM
Points: 340, Visits: 1,546
Nope!
Post #1525632
Posted Sunday, December 29, 2013 1:37 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 11:10 AM
Points: 7,964, Visits: 15,989
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