How to know log shipping is working ? | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

How to know log shipping is working ?

Hi, I have successfully configured the log shipping between two SQL server 2000 databases. The configuration was successful and the first transaction log from the host to target database was also copied successfully. However the first transaction log was of 11 GB size and the status of log shipping is same since last 4 hours. So my basic question was how to know whether the transaction log is getting applied or not ? is there any way to know.. I checked all the log shipping tables on host under MSDB database but not of any luck. So any early help is highly appreciated Rgds, Viral Shah
Did you check your log shipping monitor history? Also check the copy/load jobs created for this log shipping, see the history and make sure they successfully copied and restored the log to the host server. Also I recommend you can create some temporary objects on the primary database and wait to see if the object is created on the host database when the log is shipped. Hope this helps! Walid-
Hi, I checked the log shipping monitor and the application log and I saw the following error : Server: Msg 3201, Level 16, State 2, Line 1
Cannot open backup device ‘E:TranslogsTST_tlog_200410261115.TRN’. Device error or device off-line. See the SQL Server error log for more details.
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE LOG is terminating abnormally. The transaction log is local on the machine and not remotely and even I checked the security and there is no problem too. I appreciate if u can guide me on this issue. Rgds, Viral Shah
Ensure there are no network issues between primary and secondary SQL Servers where the Log shipping is failing while copying the log files after the backup. Satya SKJ
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.