Groups | Blog | Home
all groups > sql server replication > february 2006 >

sql server replication : Blocking while getting Snapshot



billy_karnes
2/13/2006 5:48:57 AM
We have a production database that is replicated(transactional).
Whenever we have to take a snapshot, it creates blocking on the
production tables and causes timeouts within the production
application. This is creating big problems and I am wondering if there
is away to avoid the blocking which causes the timeouts.
billy_karnes
2/13/2006 10:31:39 AM
That works very well for us. Thanks for the information.
Fas
2/13/2006 12:39:40 PM
I have the same problem and tried to use the 'Do Not Lock Table Option'.
However, the snapshot loading failed. Please help if you could post your
Paul Ibison
2/13/2006 2:40:00 PM
Please have a look at the option to allow concurrent snapshot generation
(snapshot tab - 'do not lock tables....').
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

Paul Ibison
2/13/2006 9:07:17 PM
Please can you post up your complete error message.
Rgds,
Paul Ibison

AddThis Social Bookmark Button