Can anyone tell me why a backup would fail when scheduled or run from query analyzer on the server, but will be successful when run from query analyzer on my local machine. Every other backup job run succesfully when scheduled in the same manner (i.e. user, backup options...etc).

The event description is useless as all it says is the job fails and gives the step number of the backup. When run in query analyzer on the server, it gives a network failure and a description of "connection broken

Please help
~LizardWiz()

I have no idea what this has to do with DTS but here are some things to try

UNC backup file path?
Permissions of user logging in ?
Using the same login from Server AND Workstation?

--

----------------------------

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"LizardWiz" <anonymous (AT) discussions (DOT) microsoft.com> wrote

analyzer on my local machine. Every other backup job run succesfully when
scheduled in the same manner (i.e. user, backup options...etc).
gives a network failure and a description of "connection broken"