SQL Server Performance

Logshipping Status

Discussion in 'SQL Server 2005 General DBA Questions' started by california6, Sep 25, 2007.

  1. california6 New Member

    I just configured Logshipping on my primary database. Everything seem's to be working fine. Is there a way, i make sure all the txn from my primary are loaded to secondary?
    Appreciated some input.
    Thanks,
    cali
    california6, Sep 25, 2007
    #2

  2. Akthar New Member

    hi ,
    you can run RESTORE DATABASE WITH RECOVERY on the mirror server, but this will put your mirror database online. You can check to see if all datas are there
    Akthar, Sep 25, 2007
    #3

  3. ghemant Moderator

    You may configure xp_sendmail notification on your secondary server when it completes the job/failure of the job; this way you will be notified if the job fails or job completes.
    ghemant, Sep 25, 2007
    #4

  4. satya Moderator

    CHeck the SQL error log on primary & Secondary server to see whether log backup and restored on other side, if not you can use Log Shipping Monitor to view the status.
    satya, Sep 26, 2007
    #5

  5. california6 New Member

    Thank you for all the input.
    california6, Sep 26, 2007
    #6

Share This Page