Our Microsoft web-application processes around 2000 orders per day. I need to support failover to a secondary data centre.
What are the options and experience of implementing a replication/mirroring solution?
I've heard it referred to as geo-replication and I read the MSDN article here: http://msdn.microsoft.com/en-us/library/dd263442(v=sql.100).aspx which describes the performance.
I'm not a DBA and have limited experience of replication/mirroring. Obviously when the time comes I will bring in the relevent expertise but I would appreciate anyone describing their experience in implementing this.