Does database Snapshot applied to subscriber during replication read only ?

  • If I configure my replication using the apply snapshot ( Start Snapshot agent immediately ) , I cannot make any changes in the database at subscriber side.

    I was wondering if this snapshot during replication is same as Database snapshots , which is read only !

  • No, a replication snapshot is totally different from a database snapshot. Basically what applying the snapshot means is that all objects which are part of your publication are (re)created in the subscriber database and when the data is bcp'd into the tables. Depending on the size of your database and the network connection between the two servers, applying the snapshot can take some time. Until the snapshot is applied you can not change the data on the subscriber. Once the process is finished it should work, though if you're using transactional replication it's usually not a good idea to make changes on the subscriber.

    Hope this helps

    [font="Verdana"]Markus Bohse[/font]

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

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