I want to establish a transaction replication of a large database (200GB). But when I create the publisher and the snapshot agent starts, it takes very very long time and it sticks on the following message
The process is running and is waiting for a response from the server
but the problem is when I see the size of the snapshot folder, I can see it is growing up! But too slowly.
Do you have any Idea about this? or any different way of doing the replication? how can I find the more detailed warning or errors messages?
P.S. In my database there are two tables for Images that they make 98% of the size of my database. when I don't include them in my publication, everything goes fine. but when I Include them, I will face the problem.