How to recover database when database in Restoring state for a long time.


There are three different ways to recover the database.

1) Recover the database manually with following command.

RESTORE DATABASE DataBaseName WITH RECOVERY

2) Recover the database with the log file.

RESTORE LOG DataBaseName FROM LogFilePathWithName WITH RECOVERY

3) Recover the database with the bak file.

RESTORE DATABASE DataBaseName FROM BakFilePathWithName WITH RECOVERY