Hello Experts,
Iu2019m setting up a disuster recovery for our BPC 5.1 and I need a 2sn opinion on my approachu2026
We have a production multi-server environment running SQL Server 2005 and WEB/App server (2 servers). Our DR environment is multi-server as well: database and WEB/App.
I am going to setup SQL Server Database mirroring for all BPC database, have OLAP database backed up on production and restored on DR and have robocopy of BPC folders between production and DR.
So, generally speaking, if I failover BPC database to DR and re-point end-users to DR application server it should work. Am I right or I am missing something?
Thanks in advance,
Akim