---
title: "SQL server databases stuck in restoring state"  
description: "SQL server databases stuck in restoring state"  
author: "Anonymous User"  
published: 2015-09-09  
updated: 2015-09-09  
canonical: https://www.mindstick.com/forum/33452/sql-server-databases-stuck-in-restoring-state  
category: "mssql server"  
tags: ["database", "mssql server"]  
reading_time: 1 minute  

---

# SQL server databases stuck in restoring state

I have a [Sharepoint server](https://www.mindstick.com/forum/320/sharepoint-server-displays-a-blank-page-after-installing-sharepoint). I guess our [network administrator](https://www.mindstick.com/blog/303725/ditching-the-degree-data-and-computer-careers-that-might-not-require-a-college-education) has [miss](https://answers.mindstick.com/qa/62163/who-won-the-femina-miss-grand-india-2019-title) configured his back up [tool](https://www.mindstick.com/articles/12857/customization-software-a-perfect-tool-for-e-store-owners-to-make-big-bucks) (I guess he uses Symantec [backup](https://www.mindstick.com/interview/1205/what-is-the-command-to-take-backup-and-restore-for-sharepoint-site) exec) and now some of my [databases](https://www.mindstick.com/startup/34/airbyte-the-open-source-platform-simplifying-data-integration-for-warehouses-lakes-and-databases) are [stuck in restoring](https://www.mindstick.com/forum/33454/database-stuck-in-restoring-and-snapshot-are-not-available) state!![SQL server databases stuck in restoring state](https://www.mindstick.com/mindstickforums/619516d6-312d-4f3a-911d-207052ca9c44/images/37f538e5-fdad-4b0b-9899-12a2d63cad66.png)\
How can I stop restoring process and also, is it possible to have these databases back working right?

## Replies

### Reply by Anonymous User

This is likely caused by the restore script adding the WITH NO RECOVERY parameter to make the database ready for a transaction log apply after the restore. The database is now waiting for the latest transaction log file.\
You can either:\
Apply the latest transaction log (Using RESTORE LOG... WITH RECOVERY)... orRestore the database again, but this time using WITH RECOVERY ... orForce the database out of restoring mode by executing: RESTORE DATABASE YourDb WITH RECOVERYBefore you do this, please make sure you understand the implications of these options. You may cause data loss if you are not careful.


---

Original Source: https://www.mindstick.com/forum/33452/sql-server-databases-stuck-in-restoring-state

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.