SQL server databases are stucked in restoring state

Question

I have a single server in my SharePoint 2010 server farm. Today some of users complained about that some of Infopath forms can not be opened. When I checked the SOL Server Management Studio I saw that some of my databases are in Restoring state as you see in the image below!!! enter image description here

Do you know any reason why this has happened and how can I resolve this issue?

score 1 · Answer 1 · answered Jan 05 '14 at 11:59

1

Did you run a restore database ? I think you did because it cannot happen on its own. Or maybe there is a scheduled task somewhere ?

But nevermind, it seems that your databases have not been brought up online after the restore process.

You can bring them online manually using ALTER DATABASE mydatabase SET ONLINE;

To bring them up online automatically as part of the restore process, just use WITH RECOVERY option within your database RESTORE command.

answered Jan 05 '14 at 11:59

krisFR

12,830
3
31
40

Actually I haven't run ant script. I guess the backup tool that the network admin uses is the reason of this problem! – Pooya Yazdani Jan 05 '14 at 13:03

score 0 · Answer 2 · edited Mar 10 '17 at 11:21

0

Check the option in Backup job under maintenance plan
Take the tail log backup and keep the database in Restoring state.
To Over Come,disable the above said option and run the following query for each affected Database
Restore database DB_NAME with recovery;

edited Mar 10 '17 at 11:21

bgtvfr

1,224
10
19

answered Mar 09 '17 at 20:33

Chandan Gupta

11
1

SQL server databases are stucked in restoring state

2 Answers2