---
title: "Database stuck in restoring and snapshot are not available"  
description: "Database stuck in restoring and snapshot are not available"  
author: "Anonymous User"  
published: 2015-09-10  
updated: 2015-09-10  
canonical: https://www.mindstick.com/forum/33454/database-stuck-in-restoring-and-snapshot-are-not-available  
category: "mssql server"  
tags: ["database", "mssql server"]  
reading_time: 1 minute  

---

# Database stuck in restoring and snapshot are not available

I tried to [restore](https://yourviews.mindstick.com/story/1480/ways-to-restore-ecosystems-and-heal-the-planet) my [database](https://www.mindstick.com/articles/12226/use-of-database-in-sencha-extjs-and-insert-record-from-user-form-using-ajax) from a [snapshot](https://www.mindstick.com/interview/1903/what-is-a-snapshot). This usually took around a minute to complete the last couple of times. When I did it today, it didn't complete for around 30 [minutes](https://www.mindstick.com/articles/23598/best-wedding-photographer-inspire-the-best-to-protect-your-valuable-minutes) and the [spid](https://www.mindstick.com/interview/33627/what-is-the-use-of-spid) was in a suspended state. I stopped the [query](https://www.mindstick.com/blog/202/sub-query-in-sqlserver) and [now](https://yourviews.mindstick.com/view/81402/it-s-liberals-vs-progressives-in-us-politics-now) my database is [stuck in restoring state](https://www.mindstick.com/forum/33452/sql-server-databases-stuck-in-restoring-state) and my snapshot is unavailable. Am I screwed?

```
USE master;RESTORE DATABASE QA from DATABASE_SNAPSHOT = 'QA_Snap_Testing';GO
```

## Replies

### Reply by Anonymous User

I would NOT recommend this unless you really can afford to lose the db and restore from an earlier backup. Our solution was to restart the services. Everything popped back up, but it was as if a restore were never attempted. However, it is a very low priority server and we can go back to any backup, as it is used as a staging server and the actual data in it isn't that important.\
This has actually happened to this server several times, i suspect it has to do with the fact that we're restoring over a slow network.\
One thing to check is if any other spids are connected to either the database or the snapshot.


---

Original Source: https://www.mindstick.com/forum/33454/database-stuck-in-restoring-and-snapshot-are-not-available

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