database in restore state database in restore state database database

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