I have a situation where I have a siteA and a siteB with a SQLServer 2005 Standard Edition on both site. I want that siteA has the primary database and site B the secondary database but when the VPN between both sites is DOWN I would like that siteA will
become secondary serving only the siteA and siteB become primary serving the siteB and every others sites.
I have tried Replication scenarios and log shipping. In final I would use log shipping but I have a problem when siteA become secondary I can serve siteA with database on siteA but when the VPN becomes UP I can't keep changes done on databse A.
What's the best approach in this kind of situation?
PS : My databse is used for Dynamics AX
View Complete Post