I just wanted to give little bit more details on this issue.

I ran the commands on the second server where my database was in recovering state

use master;

alter database DATABASE_NAME set...