|
Sounds like an idea. Only problem that might occur is file locking. Doesnt MS SQL lock the data and log files? If it does, how do the other machines connect to those data/log files? I did a bit of research and they say that multiple machines can not read/write to the same mdf file, however, reading would be fine. This wont work for us as we need to load balance primarily writing/updating of data.
|