Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Replication Publication issue

Author  Topic 

AnitaDBA2010
Starting Member

18 Posts

Posted - 2011-01-13 : 16:08:15
Hi All-

We are seeing some issue with publication

When i launch replicaiton monitor, i see that status of pulications is 'Retrying failed command'

And when i look under the Agent Tab, and open the job snapshot agent which has a status 'Retrying failed command', the last action message is below. Can anyone guide how to fix this issue?


Message: There is not enough space on the disk.
Stack: at Microsoft.SqlServer.Replication.Snapshot.SqlServer.NativeBcpOutProvider.ThrowNativeBcpOutException(CConnection* pNativeConnectionWrapper)
at Microsoft.SqlServer.Replication.Snapshot.SqlServer.NativeBcpOutProvider.BcpOut(String strBcpObjectName, String strBcpObjectOwner, String strBaseBcpObjectName, Boolean fUnicodeConversion, String strDataFile, String strLoadOrderingHint, String strWhereClause, Boolean useTableLockHint, Int32 bcpFileFormatVersion)
at Microsoft.SqlServer.Replication.Snapshot.SqlServer.BcpOutThreadProvider.DoWork(WorkItem workItem)
at Microsoft.SqlServer.Replication.WorkerThread.NonExceptionBasedAgentThreadProc()
at Microsoft.SqlServer.Replication.AgentCore.BaseAgentThread.AgentThreadProcWrapper() (Source: MSSQLServer, Error number: 0)

Publication Type: Transactional

Thanks
Anita

Anita
   

- Advertisement -