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

Answer 1

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