SQL Server Database recovery from corrupt database
I think you're running the restore with the NO RECOVERY option. This will restore your database, but will leave it in the RECOVERY state. 

You can easily check this by taking a look at it in the SSMS. It should say something like: yourDatabaseName (Recovering...)

If you haven't the option to take a look in your SSMS, you can simply querying your master database (if your restore doesn't aim at your master database at all. :-D).

SELECT name, state_desc
FROM sys.databases


You can filter it by name for example. Take a look at the column state_desc it should say something like RECOVERING.

If this is the case and your restore is successfully. You can simply run this:

RESTORE DATABASE yourDatabase WITH RECOVERY


This will immediately remove the RECOVERING state from your database and set it back to ONLINE.

Behind the scenes:

RECOVERING is just a transition state from (for example) RESTORING to ONLINE. In most cases a restore using WITH RECOVERY is good enough to set the database back online after the successful restore. But in some cases (e.g. Mirroring) you need to restore a copy of a database on a different machine and leave it in the RECOVERING state to define it as the mirroring partner for your PRINCIPAL database.