sql database stuck restoring code example

Example 1: database stuck on restoring

USE master;
GO

ALTER DATABASE Database_name
SET SINGLE_USER
WITH ROLLBACK IMMEDIATE;

Example 2: database stuck on restoring

USE master;
GO

ALTER DATABASE Database_name
SET MULTI_USER;
GO