Replication error: There is not enough space on the disk
I have added a new table in the replication article. and reinitialized the subscription and ticked to create a new snapshot. however, I am getting error 'There is not enough space on the disk'. further analysis i have noticed in the error log the below: Replication-Replication Snapshot Subsystem: agent * scheduled for retry. The replication agent had encountered an exception. Source: Replication Exception Type: Microsoft.SqlServer.Replication.NativeSqlConnectionException Exception Message: There is not enough space on the disk. Message Code: 0 I have experienced this issue before several times. I have resolved this type of issue by simply deleting the snapshot from \\\\Relpdata\\unc\\. But this time this trick is not working. Can any explain the reason of this error and the solution of this. I thought it is a connection error. So I tried to setup the security parameters and rerun the snapshot creation. but it did not help me.
Thank you all for your help. I have resolved this issue. It was really a disk space issue. I checked the compressed option in the snapshot location. there is a limit the compress cabinet, which is something around 2.7 GB. My compressed snapshot was exceeding that limit. Though i had enough space available in the disk. When I unticked that it created the snapshot and replication work normally. One thing is still unknown to me is why the Backward_comp_level = 40. i thought it should be 100 as i am using SQL 2008r2. If anyone can answer, please.
It seems that snapshot generated from addition of article with old snapshot ate all space and deletion of old snapshot depends on distribution retention period that is configured on distribution properties. Also, it's better to generate the snapshot of only added articles despite of generation of complete database snapshot by disabling publication properties(immediate_sync , allow_anonymous). Please check the below link.