SQL Server Performance

how to check if the log shipping is succesful

Discussion in 'SQL Server Log Shipping' started by PatDeV, Aug 17, 2006.

  1. PatDeV New Member

    Hi all,

    How can i check that if the logshipping is working perfectly fine.

    I test on test database. all the job worked successful but i don't see the changes in the database nor i seee th file which sould be copied to destination location.

    How to check it please@@@

  2. SQL_Guess New Member

    a simple (if kludgy) way would be to run a select on the logshipped database (which should be in read only iirc), and confirm that it is accurate.
    You might be able to review the SQL Server logs on the destination server - I think the restores of the logs should be in there.
    Do you have a monitor server set-up - what does that show?

    Panic, Chaos, Disorder ... my work here is done --unknown
  3. PatDeV New Member

    it does not show anything like log restored!! nor in database selece shows anything!!


  4. satya Moderator

    Check whether this KBAhttp://support.microsoft.com/kb/292586/ is anyhelp.
    http://support.microsoft.com/kb/314515/EN-US/ fyi on faq.

    Satya SKJ
    Microsoft SQL Server MVP
    Contributing Editor & Forums Moderator
    This posting is provided AS IS with no rights for the sake of knowledge sharing.
  5. PatDeV New Member



    it works fine now but getting error for

    The log shipping source (local).test has not backed up for 325 minutes..

    this error is getting in server log!!!


    please help me to solve it plz...


Share This Page