database in restore state
Try using the following query to return your database online
RESTORE DATABASE MyDatabaseWITH RECOVERY
If it throws an exception so you need to restore from a latest backup
RESTORE DATABASE MyDatabaseFROM DISK = 'C:\MyDatabase.bak'WITH REPLACE,RECOVERY