I am trying to setup a transactional replication (which was done successfully in two earlier attempts but had to redo this time for some specific reasons on the remote distributor database server)
When I click on the NEW Publication wizard and select the database needed to be published (SQL Server 2008 -
.mdf is 800GB)
It didn't ask for the Distributor Database information yet. I was wondering is that normal process to take such a long time?
We do not want to set up replication from backups as these are clients who will receive very specific tables.
Would appreciate if anyone let me know about the time involved using this method.