• its not good for us to loose the 15mts worth of data because once's the Dallas DB server becomes the primary, it starts its record from where the last replication finished so now we have duplicates

    Duplicates?

    Replication is object level and you cannot trasfer etire database at a time.

    How many databases running on it and what is the size of each database?