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?
will there be any problem if the production db acts both as Distributor and Subscribor
aswill there be any problem if the production db acts both as Distributor and Publisher
? It depends on how busy is the publisher publishing data e.g. amount of transactions on publisher. If its low volume then should be fine.