June 13, 2012 at 7:22 pm
Hi all,
We have one database in China mirrored with another database in US.
We found that the mirror suspended sometimes.
Because the database is very large, and it will take about 3 days to transfer the full backup file from China to US if we reconfigure the mirror.
So,anybody can help me ?
June 13, 2012 at 7:35 pm
It is SQLServer 2008 R2 RTM, Enterprise Edition(X64) on both sides of the mirror
June 15, 2012 at 7:44 am
What relevant error messages appear in the error log? Look in the log on both partners.
I suspect that there is too much network latency between China and the US and your connection is often timing out. You can increase the timeout value for mirroring using the command ALTER DATABASE <DB Name> SET PARTNER TIMEOUT <integer value>;. You would run this on the principal. The default timeout is 10 seconds.
We ended up implementing Riverbed WAN accelerator between the US and China for our datacenters.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply