This post was formerly published at my beloved old blog "On the quest of a DBA's adventure......"
Just find out that the snapshot replication dropped all the index in the subscription database for some reason. I don't think this is intended, though it would make sense that if index is in place, it will slow down the bulk insert.
Update
Yes, snapshot replication will do that. Still trying to find out where Microsoft did document this information. It is making sense in every way excepts if it is documented somewhere, it will feel much better.
No comments:
Post a Comment