Wednesday, March 7, 2012

Published tables locked

Hi,
I am using SQL 2000 standard edition. When i do a
snapshot replication, all the published tables are locked
while creating the snapshot. Result is i cannot do a
snapshot during work hours.
My understanding was that there is an improvement in SQL
Server 2000 where by tables do not get locked while
creating the snapshot.
Can someone throw some light on this.
thanks
venk
Nonblocking snapshots are only available when you use transactional. Why?
I really don't know, but that is the restriction.
Mike
Principal Mentor
Solid Quality Learning
"More than just Training"
SQL Server MVP
http://www.solidqualitylearning.com
http://www.mssqlserver.com

No comments:

Post a Comment