FIX - SQL Server Database Stuck In 'Restoring' State
[SQL Server, FIX]
Recently, I noticed one of my SQL Server databases had been stuck in a ‘Restoring’ state for quite some time.
Which was strange, because I had not done anything to the database in question.
It looked like this:
And it was stuck in that state for hours.
While in this state, you naturally cannot connect to the database.
The solution is to run the following command:
RESTORE DATABASE InnovaSuite WITH RECOVERY
This will restore the database and make it accessible.
TLDR
You can recover databases stuck in the Restoring state using the RESTORE DATABASE command.
Happy hacking!