Hi all,
Long time no post..... Anyway we're having some bizarre issue here. We have thousands of Win7 workstations that have SQL2012 express installed. They each have 2 instances with 4 databases each. The problem we're seeing is that the instances are coming up, most databases are starting but one particular database fails to start in some cases.
The database in question (if it makes any difference) is the last alphabetically, and if we do a windows logoff/logon it starts (although I suspect this is more to do with the client app trying to re-connect).
Anyone seen this before? I have a feeling it's application related but can't prove it, and there's nothing else in the SQL Logs that looks like it's related....
Cheers,
Tim