did you also alter the physical servers name ?

which version of sqlserver is this ?

use UNC-naming :

XCOPY C:\MSSQL\BACKUP\*.* \\myserver.mydomain.com\bu2tapeDay$\mysqlservername\Database\ /c /s /k /h /v /y

------ yourfileserver -----\-- share --\-subfolder-\--subfolder--

This is the same stuff you enter when mapping the drive in explorer !

first of all : don't mess with master unless you know what you are doing

master keeps the inventory of databases, locations, users,....

It is...

Can you check these settings using REGEDIT

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\[yourinstancename]\SuperSocketNetLib\Tcp]

and

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\[yourinstancename]]

can you post you job's DDL ? (full)

btw don't use a domainadmin account to run your sqlserver !

    Keep the guideline...

first check that your sqlserver agent service account has the needed rights to you networkdrive.

I use this doscmd to do the job (without problems)

XCOPY C:\MSSQL\BACKUP\*.* \\myserver.mydomain.com\bu2tapeDay$\mysqlservername\Database\ /c /s /k...

just my 2ct

how about ...

Select inv.*

FROM dbo.Inventory inv

where not exists ( select *

                         FROM dbo.InvHist IH

                         where IH.InvID = inv.InvID)

These are some items I've added to the great doc :

(formatting is not what it should be in html )

1.1   ...

just my 2ct to add to Daniel's reply :

another downside with DTS it when there are schema-changes !

IMO for this prod to...

in sql2000 that would not be needed because your image col is just a pointer in your table. That pointer points to a blob address which is like a varchar...