Sql-server – Migrated SQL Server database suddenly in “Restoring” state

sql serversql-server-2008

Edit: This is still a live prob, less than an hour after trying RESTORE … WITH RECOVERY.

I backed up a SQL Server 2005 database and restored it to a new SQL 2008 instance. The restore was quick and successful. Everything was fine for an hour or so.

Suddenly, the database is now stuck in "(Restoring…)" state in Management Studio and has a green arrow icon, and my application login is failing!

Any advice? 🙂

Edit: This is a live application. If I delete and try again, the hour or so's data will be lost.

Best Answer

This can be due to a number of reasons, but there are some things you can try. Try running the following command:

RESTORE DATABASE <database name> WITH RECOVERY

If that doesn't do it, you can try deleting the database and restore it again.

Related Topic