SQL Server Performance

Replication Publication issue

Discussion in 'SQL Server 2008 Replication' started by anitadba2010, Jan 13, 2011.

  1. anitadba2010 New Member

    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
  2. satya Moderator

    See the error message 'there is not enough space on disk', it looks like where the distribution & publication server is located may have space issues. Check the SQL Server error log for more information.

Share This Page