title: Whether snapshot database has instant records same as the source database in SQL?
body: <p>Whether snapshot database has instant records same as the source database in SQL?</p>
  
  <p>This is a small production database.</p>
  
  <p>We are considering to have snapshot database in the same server only for reporting purpose. I wonder, whether snapshot database will have instant records or time lag in the records.</p>
  
  <p>I have  worked on replication databases which takes about 5 or 10 mins to get the fresh data records. </p>