I was able to get the database back up and running. I see a problem with the users, is the only way to resolve this to run:

sp_dropuser 'user' and...

Thanks for the response. Hopefully all will be well shortly.