July 13, 2010 at 2:57 am
in log shipping and mirrioing, when network is down and transactions get skiped of being transferred from one server to another, will the both server will come in sync automatically after network come up again
pls help
July 13, 2010 at 3:32 am
a backlog will start on your host, and as soon as the destination is available you need to ensure it starts again, the log shipping job under the agent will fail if it cant copy the tlog files across.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
July 13, 2010 at 3:38 am
Henrico described log shipping pretty well.
For mirroring, have a look at the mirroring states: http://msdn.microsoft.com/en-us/library/ms189284.aspx Essentially, if the mirror goes down, then the mirroring state will be SUSPENDED. Once the mirror reconnects, it will switch into SYNCHRONIZING, and when it has caught up, it will be SYNCHRONIZED. Until it is SYNCHRONIZED, your mirroring will be running in a mode similar to "high performance" - "high safety" mode is unavailable until the databases are re-synched.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply