December 12, 2013 at 7:35 am
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?
December 12, 2013 at 8:32 am
The full backups should not affect the log shipped databases.
CEWII
December 12, 2013 at 9:47 am
as elliot said, no.
---------------------------------------------------------------------
December 12, 2013 at 10:53 am
Thanks!
December 16, 2013 at 7:27 am
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.
December 23, 2013 at 1:44 pm
how about diff. backups? will this break LSN?
December 23, 2013 at 1:52 pm
smtzac (12/23/2013)
how about diff. backups? will this break LSN?
No
---------------------------------------------------------------------
December 23, 2013 at 1:53 pm
Nope!
December 29, 2013 at 1:37 pm
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" 😉
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply