Sql database backup fails, Problem with Truncate.

[Guest_imported]

Hello,

I have a problem with some of my SQL 6.5 servers, I cant backup the databases with the SQL agent, this is the error
message that i recive : E8602 Failed to read from database. (DBNAME=msdb transaction, EC=Backup Agent Error - (83) "Remote pipe open failed: time-out".)

I have checked the Remote pipes on all the machines and its
OK, i have stoped the RPC service (on the selected servers)
And restarted it without effect I have also found out a bug or something in that direction that i KNOW is the
problem to this whole mess.

(1)When i chose to not Truncate the databases and i chose to Save my job it will automaticly be set back to Truncating
the next time you open up the job again, If you create a new
job with only the sql 6.5 server for example and chose no
truncating...Then you will get it to work, all the databases
will be backed up without error messages, then i thought what the heck i will just do a whole NEW job to replace my
old one, but was i fooled when i found that annoying Truncating option was checked ones more.

I hope you understand this a-bit-to-long explenation of a fairly small problem...but a BIG one for me.

Thanks.

Regards:Marcus Holmsen

 

[tractorBoy]

Yeah, I've found the same thing with SQL 6.5 dbs. I find that if I go into the SQL manager on the server and edit each db so that "truncate log on checkpoint" is not checked, it backs up perfectly. For a while I had a problem with a few of the dbs switching back from time to time. This turned out to be because one user was switching this option back. When I got him to stop, the problem went away. [sig][/sig]