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?