In our environment we are using Log Shipping as DR. Our primary database is a clustered instance. My requirement is to set up a snapshot replication for reporting purposes.
My plan is as follows:
- Make the production database as the distributor and publisher.
- The subscriber will be a read only for reporting.
My question is:
Will there be any problem if the production database acts both as distributor and subscriber?
Best Answer
It depends on your hardware. I've seen a table in the 70GB range take approximately 20 minutes to create a snapshot. Longer on older hardware. If anything else is being done, it can result in blocking.
If you write the snapshot files to the same drives as your database files then it will create I/O contention and can impact performance. And saturate your network bandwidth.
But the same can happen if you have a separate distributor as well.