SQL Server Performance

error for back up of logshipping?? help

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

  1. PatDeV New Member

    i am getting error that source has not backed up for 180 mins!!
    why?

    Thanks!!
    PatDeV, Aug 18, 2006
    #2

  2. Luis Martin Moderator

    Can you post complete error?

    Luis Martin
    Moderator
    SQL-Server-Performance.com

    All in Love is Fair
    Stevie Wonder


    All postings are provided “AS IS” with no warranties for accuracy.



    Luis Martin, Aug 18, 2006
    #2

  3. PatDeV New Member

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

    this error is getting in server log!!!

    thanks

    Thanks!!
    PatDeV, Aug 18, 2006
    #2

  4. deepakontheweb New Member

    well, did your log shipping setup was running well before this error occured?

    or you are facing this error duing when you are trying to setup logshipping.

    http://www.sql-server-performance.com/sql_server_log_shipping.asp



    Deepak Kumar
    MVP, MCDBA - SQL Server

    Disclaimer: This post is provided as is with no rights & warranty for accuracy, for the sake of knowledge sharing only.
    deepakontheweb, Aug 18, 2006
    #2

  5. chetanjain04 Member

    Is the backup on the SQL server really happening? Are you able to see the backup files in its folder.

    If the backup is not happening then, what are the other error messages you are seeing in the errorlog. Also, check windows event viewer Application log.


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

    this error is getting in server log!!!
    chetanjain04, Aug 22, 2006
    #2

Share This Page