Thread resurrection time 😎
Great article... this has been an issue at every place I have worked!
Anyone got experience with the larger DB side of things? Our PROD server is 700GBs. Requirements would be very little (if any) "lag" between the PROD and REPORTING. What would the ideal solution be (no real budget constraints)?
My thoughts are pretty much leaning towards transactional replication. Are there other options I should be considering?