"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

Database in Suspect Mode

Database in Suspect mode Grr
https://www.stellarinfo.com/support/kb/index.php/article/procedure-to-recover-sql-database-from-suspect-mode

ALTER DATABASE  Ascend_Prod  SET  EMERGENCY
DBCC CHECKDB ('Ascend_Prod')
ALTER DATABASE Ascend_Prod SET SINGLE_USER WITH ROLLBACK IMMEDIATE
--I did not have to do this, it just came back with the last
--two stepsDBCC CHECKDB (dbName, REPAIR_ALLOW_DATA_LOSS)

ALTER DATABASE Ascend_Prod SET MULTI_USER

ALTER DATABASE Ascend_Prod SET ONLINE

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