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, July 23, 2015 8:34 AM
Points: 83, Visits: 226
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, May 1, 2015 7:40 PM
Points: 6,033, Visits: 5,290
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: Yesterday @ 6:59 AM
Points: 5,978, Visits: 13,225
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, July 23, 2015 8:34 AM
Points: 83, Visits: 226
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, July 29, 2015 8:23 AM
Points: 1,332, Visits: 15,304
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: 2 days ago @ 8:45 AM
Points: 220, Visits: 864
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: Yesterday @ 6:59 AM
Points: 5,978, Visits: 13,225
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: Yesterday @ 7:06 AM
Points: 326, Visits: 1,417
Nope!
Post #1525632
Posted Sunday, December 29, 2013 1:37 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 6:57 AM
Points: 7,478, Visits: 15,491
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