SQL Server Performance

How to know log shipping is working ?

Discussion in 'SQL Server Log Shipping' started by viral, Oct 26, 2004.

  1. viral New Member

    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
  2. walidha New Member

    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-
  3. viral New Member

    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
  4. satya Moderator

    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
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

Share This Page