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 where to start looking as this is the first time I've had a database behave this way.