Search code examples
sqlsql-serverdatabaset-sqlrestore

database in restore state

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

Solution

  • 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