all groups > sql server replication > march 2005 >
You're in the

sql server replication

group:

Replication Snapshot CAB Access Rights


Replication Snapshot CAB Access Rights Doug H
3/7/2005 1:19:03 PM
sql server replication: Running SQL2K as pub/dist and MSDE 2K as subscribers. Using VB / SQL-DMO to
run pull subscriptions: 1 merge, 1 snapshot and 1 transactional.
When I create a snapshot and flag the snapshot as compressed, it appears
that the user needs write access to the snapshot folder. When the snapshot
is uncompressed, it seems to work just fine. My ideal world would see the
CAB file copied to the users' boxes and the scripts run from there (as
happens with FTP), but when accessing a file share directly replication seems
to want to decompress on the network share. Is this true?
I've tried setting the Working Folder to no avail.
Since my users connect via dial-up VPN, I would like to see throughput
maximized and running compressed seems to do that quite well. However, I no
Replication Snapshot CAB Access Rights Raymond Mak [MSFT]
3/8/2005 10:30:21 AM
Hi Doug, this is a known issue and the fix is included in
SP4 (in beta now). I would strongly encourage you to try
out the beta.

-Raymond Mak
[quoted text, click to view]
RE: Replication Snapshot CAB Access Rights Doug H
3/8/2005 11:19:03 AM
Any idea where I can get that beta. I didn't see it on MSDN subscriber
downloads or microsoft.com/sql?

Thanks,

Doug.

[quoted text, click to view]
RE: Replication Snapshot CAB Access Rights Raymond Mak [MSFT]
3/9/2005 11:44:44 AM
Hi Doug, you can sign yourself up for the SQL2000SP4 beta
program by following the instructions at
http://www.microsoft.com/sql/evaluation/betanominations.asp
.. I believe you will need a passport account and to fill
out a survey for that.

HTH

-Raymond

[quoted text, click to view]
AddThis Social Bookmark Button