It must have been restored with "NORECOVERY". See: https://www.mssqltips.com/sqlservertip/5460/sql-server-database-stuck-in-restoring-state/
Run
RESTORE DATABASE [databasename] WITH RECOVERY
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
I have a big problem
The main database of my site is not accessible.
Can anyone guide me? What should I do?
Displays the following error when opening (expanding) this database in SSMS:
===================================
The database XXXDb is not accessible. (ObjectExplorer)
------------------------------
Program Location:
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.DatabaseNavigableItem.get_CanGetChildren()
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItem.RequestChildren(IGetChildrenRequest request)
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ExplorerHierarchyNode.BuildChildren(WaitHandle quitEvent)
Sqlserver 2019
SSMS 18
Windows Server 2019
It must have been restored with "NORECOVERY". See: https://www.mssqltips.com/sqlservertip/5460/sql-server-database-stuck-in-restoring-state/
Run
RESTORE DATABASE [databasename] WITH RECOVERY
The database is in "Restoring" state. Someone is restoring the database.
I'm the only one who has access to the database.
He has been in this State for 2 days. How do I get out of this State?