Each Article will have Pull Subscription | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Each Article will have Pull Subscription

Assuming I have 40 articles, is it advisable to have each article being published to have its own subscription (in this case 40 subscriptions)? The reason for doing this is I would like to perform my snapshot on selected articles only during production hour. Thanks,
Jon M
If you want to perform the operation selectively then go by creating a dedicated subscription for each article, otherwise no reason for it. Satya SKJ
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.