I have a problem in SQL Server 2008 R2.
I was running a query that updated huge data in database, therefore it takes a lot of time to finish.
And before the query has been finished (after 1 hour processing), I got error message "Cannot open database "XXX" requested by the login. The login failed". And then I tried to connect to that database again, and the Database became XXX(In Recovery). After 5 hours, the database has recovered on its own.
Does anybody know what is the problem that might cause this issues(database became In Recovery)?
Thanks in advance