Question: If you run this command
RESTORE DATABASE databasename WITH RECOVERY
after a RESTORE WITH NORECOVERY as shown in GilaMonster's post, the database will change to a normal state and you're ready to go.
What happens if you run this command while a database is actually in the process of restoring? Is this a safe thing for the OP to try?