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