Just to update and close this thread for any others reading:

This was solved simply by bringing the database online with alter database!

Pretty annoyed that I did't try that first before posting... But oh well, lesson learned!

Cheers