database stucked at restoring code example
Example 1: database stuck on restoring
RESTORE DATABASE [databasename] WITH RECOVERY
Example 2: database stuck on restoring
USE master;
GO
ALTER DATABASE Database_name
SET SINGLE_USER
WITH ROLLBACK IMMEDIATE;