I need to setup a DR/BCP environment for MSP. I have two virtual servers setup in our DR datacenter. My question is does the Production MS SQL Server have to be the same version as the DR MS SQL Server?
Has anyone setup anything like this? My plan is to copy the data from production MSP server to DR MSP server via scripts and then setup replication between the two SQL servers.