Take a look in Activity Monitor (Mngm Studio, under Management node) to see if your db is still restoring; if not then run

RESTORE your_db WITH RECOVERY