One of the many tasks of anybody who works more in depth with databases is the restoring of data.

Not being completely adept at this practice myself – mostly because it is rare that we administrate production databases – it is something I’m looking into at times.
Occasionally – I’ve seen databases being stuck in “Restoring” state. Basically without getting all to technical (because that’ll be a blog piece for another time), it is mostly because the Database is restored with the “NORECOVERY” clause, so it is ready to be rolled forward with transaction log backups.

So – a method of bringing a database back from restoring state is to run the script:
RESTORE DATABASE <DATABASE_NAME> 
WITH RECOVERY

This has worked for me so far anyways... :)