SQL Backup 7 - Looking at buying but
I have installed and i can do a backup but i want it to copy it over our network to the server i have installed.
So to be complicated we have a hosted platform in the US with a VPN connection. On a way trust domain, linking to our office in england.
The software is in the office in England. If i install the client on the sql servers in hosting at local service its runs and a backup can be done locally. the compression rate is awesome. But then i if want to copy over network from hosting to england office it complains saying folder cannot be created.
So i reinstalled the backup agent with a service account on our hosting platform and now it says
Backup could not access [HKEY_LOCAL_MACHINE\SOFTWARE\Red Gate\SQL Backup\BackupSettingsGlobalEST] running as user [1495823-S12EST1].
and now no backups.
This software does not seem to work well in a multi domain environment. I have tried enabling SQL browsing doesn't work even after a refresh. Added domain account into registry and the service stops working. If i have no trust in place i.e. using SQL accounts only how does this software work?