Chris SkorlinskiSQL Server Escalation Services
Here are some thoughts on using Transactional (or Peer-2-Peer) Replication Subscriber to support both REPORTING and DISATER RECOVERY.
Normally "subscriber" target server would have different set of non-clustered indexes to support REPORTING capabilities. The Publisher's indexes, check-constraints, triggers, etc, would only be added when Publisher goes down and the Subscriber comes online as the new Publisher. These Publisher objects would normally already have "Not for Replication" enabled.