3

Database dropping into recovery mode

view full story
linux-howto

http://serverfault.com – I have a SQL Server 2008 R2 Express instance that runs 3 databases. Two of the databases are for a program I wrote, the third one is for an Oracle program. My databases are approximately 100mb, and the Oracle database fluctuates in size between 2-3 GB. Within the last day or so, the Oracle database intermittently drops into recovery mode, while the other databases on the server continue running perfectly fine. Could it be that the program has some faulty logic and is asking the server to go into recovery mode because it didn't get the response it expected from a query? I really don't know (HowTos)