title: SQL Server full copy of database for read operations
body: <p>Please advise what suits my problem better. I have a highload web app hosted on the same server where SQL server is hosted. I also have SQL Service reporting running on the same server, generating user reports.</p>
  
  <p>So my server basically works on top of disk read/write speed. I'm going to get another server and install there another SQL server in order to host SSRS there. So my criteria is to get as fresh data as it possible.</p>
  
  <p>I've looked a couple of solution, currently I do make backup via jobs, copy it to second server and restore it there, also via jobs. But that's not the best solution.</p>
  
  <p>All replication mechanism(transaction, merge, snapshot) affect publisher database by locking it's table, what is unacceptable for me.</p>
  
  <p>So I wonder is there any possibility to create a replica with read only access, that would be synced periodically not affecting main db? I would put all report load to that replica and make my primary db be used only by web app.</p>
  
  <p>What solution might suit my problem? As I'm not a DBA, I'd start investigating that direction. Thanks.</p>