Hi all,

I've done POC/testing on log shipping using SQL Server 2005, at first, it worked, but sometimes it failed in the recovery job

I just wanna know, what are the matters that caused log shipping failed ?

As far as I know from this topic, these case can caused log shipping failed to restore :

- If any user connect to secondary database (log shipping DB)

- If doing truncate log file on primary database

- If doing backup transaction log on primary database

- any others... ??

And if it failed to restore the transaction log, what should I do ?