September 21, 2011 at 12:45 am
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,
September 21, 2011 at 6:08 am
You are correct LS is ont timezone aware and it based on LSN.
What you can do here is you need to set up LS manually or write step of restore tlog on secondary server. You can apply SQL Server 7.0 techniques for LS. You can also use third party tool if it works. Refer following link for further detail:
http://www.sqlmag.com/article/sql-server-70/log-shipping-with-sql-server-7-0
HTH
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
September 21, 2011 at 7:09 am
what exactly is not working?
---------------------------------------------------------------------
September 21, 2011 at 11:55 am
i log ship from a server in the UK to a server in USA with a time difference of 8 hours. As George says, what exactly is not working?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply