SQL Server Performance

LOG shipping issue

Discussion in 'SQL Server 2005 Log Shipping' started by 5QL53rv3r, Jul 23, 2009.

  1. 5QL53rv3r New Member

    Hi,
    Log shipping is no longer working. My log shipped database has been applying a log for almost 3 hours. One thing I have noticed is that the .tuf file is missing??
    Any ideas on what I should do next???
  2. Luis Martin Moderator

    Did you try to recreate all the log shipping from the beginning?.
    If .tuf is missing, then log shipping does not work.
  3. 5QL53rv3r New Member

    I haven't tried this...
    Does this mean removing all configurartion from the primary database and then reapplying it?
    I didn't set this up and I don't have much experience with traditional log shipping in 2005, I used my own scripts in a SQL 2000 environ.
    Is this a common issue?
    Do I need to restore a full backup before I reconfig log shipping?
    Thanks
  4. Luis Martin Moderator

    "Does this mean removing all configurartion from the primary database and then reapplying it?"
    Yes.
    "Is this a common issue?"
    No with the last sp.
    Check:
    http://www.sql-server-performance.com/articles/clustering/log_shipping_70_p1.aspx

Share This Page