Hi My requirement is as follows: We have clustered Servers and want to replicate data for reporting purposes. We would like to use the subscriber as the distributor and use PULL subscription.Clustered Servers currently being used are using SQL Server 2000 whereas we have SQL 2005 as the distributor & subscriber both being the same machine/instance. Can someone provide me with best practices & pros and cons if any. thanks Sunil
http://technet.microsoft.com/en-us/library/ms146934.aspx http://technet.microsoft.com/en-us/library/ms143470.aspx Also refer to the General DBA section in SQL 2005 for relevant posts.
