Mark,
my answers inline:
I could write a lot more so please post back if any issue requires more
detail...
Regards,
Paul Ibison
[quoted text, click to view] > Does MSFT provide access to debug libraries to help decipher error and
system messages?
You can look at
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/trblsql/tr_syserrors1_6m5z.asp
but there aren't any really detailed message lists that I have heard of.
Most are self explanatory though and some that are not are now fairly well
known (eg
www.replicationanswers.com)
[quoted text, click to view] > Are there any distance restrictions on replication?
No, although agent timeouts and other parameters may need to be optimised
for this method.
[quoted text, click to view] > In a merge (or master to master) scenario can you set up one instance as
the primary and
> one as a secondary as far as conflict resolution?
By default, the publisher wins conflicts with subscribers. The first
subscriber takes the priority of the publisher if it is a conflict between
subscribers. Priority numbers can be assigned to subscribers as an
alternative resolution method.
[quoted text, click to view] > Performance issues/system resources? OK or resource hog?
This depends on the type of replication, the number of changes/transactions,
push or pull, remote distributor or combined publisher/subscriber etc.
[quoted text, click to view] > How does the product intialize? flat files or database tables?
BCP text files or FTP text files, although you can initialize with the
option that the subscriber already has the data, in which case the textfiles
don't contain table data.
[quoted text, click to view] > How robust is is as far as recovery situations? does it come back or do
you have to spend a lot of time
> manually reconfiguring?
In my experience it is robust. You may have configuration issues if you set
up a more 'exotic' configuration eg VPN replication across non-trusted
domains, but these are familiarization issues.
[quoted text, click to view] >
> I am looking at this product for a high availablilty and high security
situation so I'm sorry for all the questions but I do appreciate the help.
>
> TIA
> Mark Ellis