hi,

one of my coworker setup a bunch of pull transactional replication.  The snaps for this publication is compressed and is stored on the publisher+distributor.  There are 30GBs of disk space atm. all the publication are working fine except for one.  I keep getting the following error

Replication-Replication Distribution Subsystem: agent ABCDE39-pubname-subscribername-104 failed. The process encountered operating system error ''.

When i look at the replication, I see:

Command attempted:

if @@trancount > 0 rollback tran (Transaction sequence number: 0x0001A1AD000337A201D700000000, Command ID: 3275)

Error messages:

• The process encountered operating system error ''. (Source: MSSQL_REPL, Error number: MSSQL_REPL20034) Get help: http://help/MSSQL_REPL20034
• There is not enough disk space on the disk.  (Source: MSSQL_REPL, Error number: MSSQL_REPL112) Get help: http://help/MSSQL_REPL112
• The process encountered operating system error ''. (Source: MSSQL_REPL, Error number: MSSQL_REPL1779) Get help: http://help/MSSQL_REPL1779

at first I thought that the compressed cab file would be stored in the temp directory on the subscriber and that doesn't have a lot of space so I changed the system environment variable from c:\windows\temp to v:\temp.  This shut it up for a while but then the message started to show up again.

I have been monitoring the drive where repldata is stored but i don't see it reducing in size.  Does replication not even bother with using the disk space if the size isn't big enough, like the restore function?

if this has to do with the amount of free space where repldata reside, if I change its location, do i need to stop replication first or will it pick up that info automatically?

any help would be greatly appreciated.

thx

• Moved by Naomi N Thursday, March 28, 2013 10:07 PM Better answer can be here

Thanks for the move Naomi.

Update: I went ahead and changed the location of the repldata to another drive, setup the share w/ all the necessary permission and still got the above error.

• Edited by Red8Rain Thursday, March 28, 2013 10:38 PM

 Cab files are decompressed on the publisher unless you download them via ftp. Are you using push or pull?