SQL server databases stuck in restoring state
This is likely caused by the restore script adding the WITH NORECOVERY parameter, to make the database ready for a transaction log apply after the restore.

The database is now waiting for the latest transaction log file.

You can either:


Apply the latest transaction log, using RESTORE LOG database_name FROM backup_device WITH RECOVERY; ... or
Restore the database again, but this time using ... WITH RECOVERY; ... or
Force the database out of restoring mode by executing: RESTORE DATABASE YourDb WITH RECOVERY;


Before you do this, please make sure you understand the implications of these options. You may cause data loss if you are not careful.

See this for details:


http://technet.microsoft.com/en-us/library/ms177446.aspx
https://stackoverflow.com/questions/520967/sql-server-database-stuck-in-restoring-state