SQL Server Performance Forum – Threads Archive
Replication Questions!Hi,<br /><br />I am new to replication and have a few questions i hope someone can help me with:<br /><br />1) can an SQL Server distribute publications to itself as the subscriber?<br /><br />2) if i have seperate publisher, distributor and subscriber, what happens if one of them is offline at a given time?? eg. distributor is offline- does it still receive the transactions when it comes back online?? <br /><br />Im sure i will have more questions soon! hope someone can help <img src=’/community/emoticons/emotion-1.gif’ alt=’‘ /><br /><br />Ben
Hi ya, yes a single SQLServer instance can be a publisher subscriber and distributor each database can be down for a period of time, the exact period depends on settings in the publications and subscriptions. when the database is available again, then replication carries on where it stopped and catches itself back up Cheers
I would suggest to refer to latest sQL server books online for immediate reference on replication topic. Satya SKJ
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.