I have a sql server 2012 web database on my server that I use for my race management company. When we go out to time races I put a copy of the *.mdf and *.ldf files in dropbox and then each timer (if we have more than one crew out at a given time) pulls down those files (meaning each crew starts with the same data) and uses that to time their race on their local machine. As they time the race the data for their event is uploaded to the server programatically. Other than writing a script to download just the data each crew needs for their event, is there a better way to do this rather than sticking the *.mdf & *.ldf files in dropbox and copying them to our local machines? What sometimes happens is the local machine takes a couple of tries to access the data and sometimes it requires a re-start.
I am guessing this is a pretty low-brow approach and am looking for a more seamless approach if it is within my cerebral capabilities.
We run sql server 2012 express on our local machines. My timing program was written with vb6.