• Thanks for the replies guys.

    So,If there has been no modification in the source database, then no pages will be copied to SS and hence the data is read from Source Database. In that case, how can the DB SnapShot can be used to Generate reports without blocking or being blocked by production operations.

    This is considered to the best feature of SS. Please explain how the blocking in the production database is avoided by simply creating the SS. Ultimately the data has to be read from the production database, if no update has been done.

    Thanks

    Manoj

    John