February 21, 2005 at 2:20 am
Hi,
I just set up testing log shipping between two SQL servers, i want to know if I change a record in TableA in Primary server A, will the change reflect to TableA in Secondary B immediately? Do I need to wait 15 minutes if I complete the log shipping as the default setting? Thanks.
Jason
February 21, 2005 at 3:11 am
With log shipping, you won't have anything replicated on your 'B' server until the logs have been shipped to it, and imported.
However, you probably won't be able to see the changes as the 'B' server should be in standby mode if you're going to keep the log shipping on the go.
Sometimes, if you make the change just before you ship the logs, the change may be replicated rapidly (as the Transaction Logs get backed up, and shipped just after you complete the transaction).
At other times, you may have to wait up to the 15 minutes.
All depends when you do the transactions, and when the log ships (and then how closely the remote server is synced to your export. Usually allow a couple of minutes for log backup and network transfer).
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply