Have you tried this?
Database stuck in "Restoring" state
Probably the answer to the problem,
stuck in recovery state
is...
You need to use the WITH RECOVERY option, with your database RESTORE command, to bring your database online as part of the restore process.