Several databases are going into Recovery mode, when I view them in SSMS. Only for a few seconds at a time, then the go back to normal...
The problems with this are some client app's are trying to connect and cant do so when required.
I was running on Express edition, but just recently migrated to SQL Server 2012 standard.
The issue is still occuring regardless of this upgrade.
What should I be looking at,.. the servers memory and CPU usage are fine when this occurs.
Sometimes you expand Tables in SSMS and it takes forever, then it will go into Recovery mode, sometimes on 3 databases at once, somethimes just 1.
Where do I start ?