I am assigned to create a transactional replication with a SQL Server clustered instance for reporting purposes. I'm planning to use the Distributor and the Subscriber on the same box.

Regarding the snapshot folder, is it ok to place it on the same box where the Distributor\Subscriber resides? Will there by any problems?


As long as you can access that folder from all the nodes of the cluster there shouldn't be any issue.

Just make sure you have a decent nw connection between the cluster nodes and the replication box, otherwise the generation of the snapshots will take a long time.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.