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: Tuesday, February 17, 2015 12:06 PM
Points: 83, Visits: 223
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, February 20, 2015 9:41 AM
Points: 6,032, Visits: 5,288
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 @ 3:50 AM
Points: 5,916, Visits: 13,119
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: Tuesday, February 17, 2015 12:06 PM
Points: 83, Visits: 223
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: Tuesday, February 24, 2015 6:42 AM
Points: 1,332, Visits: 15,287
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-Enthusiastic

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

Group: General Forum Members
Last Login: Yesterday @ 8:25 AM
Points: 173, Visits: 631
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 @ 3:50 AM
Points: 5,916, Visits: 13,119
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 @ 3:40 PM
Points: 318, Visits: 1,320
Nope!
Post #1525632
Posted Sunday, December 29, 2013 1:37 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 5:48 AM
Points: 7,020, Visits: 14,834
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