BW Servers in multiple locations
Could someone provide me with information/links about setting up BW instances on SQL Servers in multiple locations? We are interested in performance improvements as well as using them for failovers.
Branch offices need global data as well as their branch data so I can’t put only branch data on their local server.
We are currently on 7.31 SP10 running SQL Server 2012 R2. We'd make the change during the upgrade to 7.4.
Thank you for your help,