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???
Did you try to recreate all the log shipping from the beginning?. If .tuf is missing, then log shipping does not work.
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
"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