Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 xp_cmdshell

Author  Topic 

OMB
Yak Posting Veteran

88 Posts

Posted - 2001-11-06 : 09:16:24
I have the following SQL statement:

exec xp_cmdshell 'xcopy f:\data\backup\test1.bak \\server2\backup\ /c'

It does not work it keeps on saying invalid drive specification, I can run this command from the command prompt no problem

any ideas!

Thanxs


   

- Advertisement -