I did restore the secondary database with the WITH NORECOVERY option yesterday which is why (now I realise) it is always in recovering mode since then. I have tried...
Ok thanks for replying. Looks like I need to choose another option to have the database in Standby / Read Only mode which is what the other secondary databases are...