We have a m-files vault that is MSSQL based and on that sql server we have multiple databases. Since, I believe, the load order of MSSQL database cannot be set (and viewing the event log) the vault in question does not start quick enough and m-files server times out and keeps the vault offline, where it just needs more time to start.
There are a few solutions that come to mind, listed from easiest to hardest. So, I am wondering if there is an easy way to do the first one.
1) Adding a timeout to the loading(bringing online) of SQL based vaults (or vaults in general)
2) Adding a dependency on the M-Files, knowing that there is a sql dependency in a vault, according to http://support.microsoft.com/kb/193888.
3) I could turn m-files service startup to manual, write a service that waits for the specific database to respond to a login, then start the m-files service
Any other solutions you already have implemented would be appreciated.
-Doug
