Urgent question re: replication

at our organization we are replicating 3 instances cross country using HADR recently whill adding some tables and making some schematic changes to the database the replication failed. What sort of changes can you make to a primary server, or better yet what sort of changes can't you make without causing replication to fail? My boss is expecteing me to have some info on this matter asap so i thank all respondents in advance. -----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own

In article <76tuaj$pr4$1@nnrp1.dejanews.com>, mdevlin8648@my-dejanews.com wrote: > at our organization we are replicating 3 instances cross country using HADR > recently whill adding some tables and making some schematic changes to the I don't think that changes in schema like new table, index or constraint can lead to replication fail. > database the replication failed. What sort of changes can you make to a > primary server, or better yet what sort of changes can't you make without Be careful if you're adding new chunks/dbspaces. In that case on the secondary you should prepare device/file with the same name before you will add chunk on primary. Then your transaction will be replicated through logical log to the secondary successfully. > causing replication to fail? My boss is expecteing me to have some info on > this matter asap so i thank all respondents in advance. > > -----------== Posted via Deja News, The Discussion Network ==---------- > http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own > -- Vardan Aroustamian vaar@geocities.com -----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own