Error: ExecuteNonQuery requires an open and available Connection. The connection's current state is closed.(System.Data)

10-11  Source: Network gathering  Views:4 

Advertisement
Dear all,
Can any one explain about this error,
2014-11-02 19:19:29.58    *** Error: Could not log history/error message.(Microsoft.SqlServer.Management.LogShipping) ***
2014-11-02 19:19:29.58    *** Error: ExecuteNonQuery requires an open and available Connection. The connection's current state is closed.(System.Data) ***
2014-11-02 19:19:29.58    Deleting log backup file. File: '\\Jdccb-mis\logshipping\JDCCBPROD_20141030134512.trn', Last Write Time (UTC): '10/30/2014 1:45:13 PM'
2014-11-02 19:19:29.60    *** Error: Could not log history/error message.(Microsoft.SqlServer.Management.LogShipping) *****
This errors comes on My Secondary server during log shipping and database goes to restore mode.
satish Kumar
Hi Krishnp,
These are the latest jobs in queue:
89 Quadro de Horários 28/6/2014 1:45  N/D Arquivar Configurações do Sistema Aguardando Processamento 0%  
 88 Quadro de Horários 28/6/2014 1:30  N/D Arquivar Modos de Exibição do Project Web App Aguardando Processamento 0%  
 87 Quadro de Horários 28/6/2014 1:00  N/D Arquivar Campos Personalizados Aguardando Processamento 0%  
When I delete the last work automatically related are excluded.
Currently the queue is 406 jobs.
David Soares MCTS:MBS - MCTS - MCITP
Related articles