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 2008 Forums  SQL Server Administration (2008)  xp_cmdshell and file copy

Author  Topic  PeterBee Starting Member 1 Post Posted - 2011-02-23 : 10:57:21 Hi Why, if this works on SERVER1: EXEC xp_cmdshell N'copy E:\backups\ReadMe.txt, \\SERVER2\backups\ReadMe.txt'; should this not work on SERVER2 - Access denied? EXEC xp_cmdshell 'copy \\SERVER1\backups\ReadMe.txt, E:\backups\ReadMe.txt'; Background: I am a member of sysadmin and the SQL Server service account has the same rights on both servers. The only difference I can find between the two instances is that SERVER1 is 32bit Windows Server 2008 while SERVER2 is 64bit. Can I do anything about this? Regards, PeterBee