"Restoring..."  Stuck on it

/*"RESTORING"

By default, a DB is not ready to use. It stays "restoring" ready to receive log restores.

Simply run this to bring the DB on-line*/

RESTORE DATABASE [dbname] WITH RECOVERY


Take a Database OFFLINE immediately

-- Take the Database Offline
ALTER DATABASE [myDB] SET OFFLINE WITH
ROLLBACK
IMMEDIATE
GO

Bring a database back ONLINE immediately

-- Take the Database Online
ALTER DATABASE [myDB] SET ONLINE
GO