I have an NEC ExpressCluster 3.2 with mirrored disks. (2 Nodes) It is installed with Windows Server 2008 R2 and SQL Server 2008R2.
The active node of the cluster has been set up as a secondary server for log shipping, this works fine until the cluster fails over.
There are two databases in question
•DB1 (1Gb)
•DB2 (40Gb)
When it fails over DB1 starts to log ship on OK.
Although DB2 does not restore the transaction logs, in the SQL log file we get “The log shipping secondary database DB2 has restore threshold of 45 minutes and is out of sync Error 14421, Severity 16, State 1
I have run the sp_refresh_log_shipping_monitor but this also did not help
Has anyome got any other Ideas
Thanks