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 ?