database in restore state

Question

I tired to restore my database but I saw that I am restoring a wrong one, so I immediately kill the process. Unfortunately the database was in restoring state and is not accessible anymore.

Can anyone help me to return back to normal state?

Thanks in advance

SQL Server: Database stuck in “Restoring” state but if you restored with overwrite your unlikely to be able to return to the state prior to the aborted restore (without another restore) — Alex K.
– Alex K., Commented Nov 17, 2017 at 18:31
Possible duplicate of SQL Server: Database stuck in "Restoring" state — Igor
– Igor, Commented Nov 17, 2017 at 19:05

Hadi · Accepted Answer · 2017-11-17 20:13:44Z

10

Try using the following query to return your database online

RESTORE DATABASE MyDatabase
WITH RECOVERY

If it throws an exception so you need to restore from a latest backup

RESTORE DATABASE MyDatabase
FROM DISK = 'C:\MyDatabase.bak'
WITH REPLACE,RECOVERY

edited Nov 17, 2017 at 20:13

answered Nov 17, 2017 at 19:04

Hadi

37.5k13 gold badges73 silver badges128 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

database in restore state

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related