Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
frank.svs
Constraint Violating Yak Guru
368 Posts |
 Posted - 2011-09-21 : 02:47:43
|
| Hi All,I have serious problems in log shipping configuration and it is not working properly.The Primary Server is in EST timezone and Secondary Server is in PST timezone.The log shipping is configured for every 15 minutes.When i try run the LSbackup and LSCopy and then LSRestore jobs manually it is working fine.But as per scchedule , the SQL Agent is getting messed up. I found there is a time difference of 3 hours.Primary Server is 3 hrs ahead of the Secondary Server.Is there any quick fix to resolve this issue adjusting the time ? Am not sure where to modify log shipping configuration and what values to set in order to get the jobs working fine? As per my knowledge the logshipping is based on LSN chain and not much on time zone but not sure here the time's are messed up.Can anyone help me out to make this work??Thanks in Advance, |
|
|
Cindyaz
Yak Posting Veteran
73 Posts |
Posted - 2011-09-26 : 18:11:29
|
| Can you let us know where is the latency? copy job or restore job? |
 |
|
|
|
|
|
log shipping problem !!! urgent pl !!!