May 8, 2009 at 11:16 am
Hi,
We have configured log shipping in sql server 2005.We have backup strategy like the below
1. Full backup -> Daily 10PM
2.Diffrential ->Daily evry 6hrs
3.Tlogs every 15mins ->using Log shipping.
My Question is:
If we take full back up daily, does it break the LSN chain?
and do we need to send the full backup to secondary and again configure the log shipping?
how it works if we are taking full backup daily for the databases involved in log shipping?
May 8, 2009 at 11:19 am
If we take full back up daily, does it break the LSN chain?
full & diff do not break the chain. It will continue to work as long as you don't take a manual TL backup.
and do we need to send the full backup to secondary and again configure the log shipping?
Nope, not because of full or diff backups
how it works if we are taking full backup daily for the databases involved in log shipping?
Just do it as normal.
May 8, 2009 at 11:24 am
thank you...
May 8, 2009 at 5:17 pm
Fail over in Log Shipping:
Can we have same servername and instance as the primary. Here both primary and secondary servers are in the same domain.
Primary is in NY and secondary is in CA.
If we can have same server name and instance and the secondary database also have the same name as Primary, how to fail over?
Having Same domain But DO NOT have same server name and instance name as Primary,how to fail over?
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply