Did you restore with the norecovery option?

If you did, just do this :

restore dbname with recovery

That is the full lenght of my knowledge on the subject... hoping it works for you.