What will be impace of doing Snap

  • Hi All,

    I have a databases A . I am doing Snapshot replication for Creating one more database B. While doing Snapshot replication what will be the impact of the tables in source database (A)? What i mean is,

    how long the tables in database A will be locked position? If all the tables in the database A is locked for some time say, 5 min, how to handle the requests comming to A while the database is in locked postion? If any one knows about this ..please help me..

    Thanks in Advance,

    Sarat.

  • Dont' do double post!

    Every reply should goes

    http://www.sqlservercentral.com/Forums/FindPost640489.aspx

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply