dbTalk Databases Forums  

Error running backup from SQLAgent

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Error running backup from SQLAgent in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
john burgess
 
Posts: n/a

Default Error running backup from SQLAgent - 06-19-2004 , 01:02 PM






Error message when backing up database from SQLAgent job :
ConnectionRead (WrapperRead()). [SQLSTATE 01000] (Message
258) General network error. Check your network
documentation.

Anyone seen this before ? Know how to fix it ?

Reply With Quote
  #2  
Old   
Partha Mandayam
 
Posts: n/a

Default Re: Error running backup from SQLAgent - 06-20-2004 , 03:10 PM






Perhaps there really was a network problem at that time. Did you try
again? Have you tried using regular backup command?

Regards

Partha Mandayam
Software Consultant
Home page: http://partha.tripod.com


*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!

Reply With Quote
  #3  
Old   
 
Posts: n/a

Default Re: Error running backup from SQLAgent - 06-22-2004 , 05:59 AM



Thanks...
I found the problem in :
http://support.microsoft.com/default.aspx?scid=kb;en-
us;827452
Even though this is the wrong operating system and
SQLServer version, it is exactly the same problem, and the
workaround works.

Basically, the backup / restore is actually successful but
the client thinks it is not. Changing the client protocol
on the server (not the server protocol) to TCP/IP resolved
it.

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.