10-12-2013 12:38 PM
you can certainly put the act database files into your LOCAL dropbox directory eg c:\dropbox\act\database.
you can then share that folder on your LAN eg map to \\myserver\databases
this is just simple filesharing and dropbox should not be too worried by it hopefully (i'm sure someone will correct me)
however the dropbox user would expect the database to be backed up when he has finisehed with it. unfortunately some process of act or sql locks the file and so dropbox does not get the access it needs to back it up to the cloud
Does anyone know what process/service to stop to let dropbox work occasionally to do a backup?
it is NOT a good idea for someone else to then use a sync version as LOTS of conflicting copies will be created.
so you can only use dropbox as a backup...providing the database can be unlocked. I;ve done this sort of thing with outlook pst files and it works fine.
10-12-2013 07:23 PM
10-13-2013 01:30 AM
is that the mssql$act7 service?? - I can't access that (or sqlbrwser, sqlwriter?)
backup solution using scheduler: I'm not familiar with that but i assume it runs on win7 startup BEFORE user login - is that correct?
I appreciate the backup solution but each time it is backed up that will require a full backup by dropbox and not the changed-bit/intelligent backup that it can normally do. for large database (as per other posts) this method could take a very long time.