Migrated SQL Server database suddenly in "Restoring" state
- by Pete Montgomery
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.