Transaction Log Shiping
At first i am sorry for late response. I was in vacation. Thank you for your cordial reply. After my vacation i try to use transaction log shiping. At first i apply the mechanism for two server where i try to transfer data from one database of primserver to seconserver. It successfully back up the database but in the time of restore the database the following error occurs in the log file
Error: 14421, Severity: 16, State: 1.
The log shipping secondary database GALAXY\GALAXYSQL.DataTransferTo has restore threshold of 45 minutes and is out of sync. No restore was performed for 137 minutes. Restored latency is 0 minutes. Check agent log and logshipping monitor information
Where is the problem? Can you help me to write more detail please? I just wait for your replay.
Last edited by Shimul Mahmud; December 10th, 2009 at 07:36 AM..