Data Mirroring is also an option. But...
You broke replication for an upgrade. Why did you not upgrade the other server? If you did, why did you not rebuild / reinitialize replication?
You shouldn't have to keep doing this manually. Broken replication can be fixed.
Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.