<div>
Hi,<br>Is it big size to restore file? Is service of DB up and running well?&nbsp;
</div>


<div>
Restore with 43.5GB bak file. The database is not accessible (objectexplorer) now.
</div>


<div>
It should be working there. Can you wait for more time, like 20, 30 minutes? That Backup file is being processed there.
</div>


Programmer

litmic

<div>
<div class="content wysiwyg-content fr-view">
There is problem when restore database of microsoft SQL server 2017, the database stuck in restoring State and the database is not accessible. How to resolve? &nbsp;<br><a href="https://filedb.experts-exchange.com/incoming/2021/05_w22/1562040/Screenshot---5_26_2021---9_51_52-AM.png" rel="ugc"><img src="https://filedb.experts-exchange.com/incoming/2021/05_w22/1562040/Screenshot---5_26_2021---9_51_52-AM.png" class="fr-fic fr-dib"></a>
</div>
</div>


Screenshot---5_26_2021---9_51_52-AM.png


There is problem when restore database of microsoft SQL server 2017, the database stuck in restoring State and the database is not accessible. How to resolve?  

Microsoft SQL Server Database Stuck in Restoring State

Microsoft is best known for their Microsoft Windows line of operating systems, the Microsoft Office suite, and the Internet Explorer and Edge web browsers. Microsoft's mission is to "enable people and businesses throughout the world to realize their full potential by creating technology that transforms the way people work, play, and communicate.” Currently, the Windows operating system created by Microsoft powers over a billion devices around the world. On top of their share in the software creation market, Microsoft manufactures hardware, including laptops, phones, and attachments.

Microsoft

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.