xp_cmdshell ''xcopy'' worked for weeks and is now failing

Question

Post reply

xp_cmdshell ''xcopy'' worked for weeks and is now failing

Barbara-167570

SSCrazy

Points: 2352
More actions
June 22, 2005 at 8:18 am

#164692

I’ve got a job with two steps that deletes old files and then copies backups from my SQL Server to a different server where taped backups are preformed. This job has been working as expected since the beginning of the month. Now all of a sudden I’m getting an error message and the files are not making it over to the Tape Backup machine. Step one of the process is working and is deleting the older files. Step 2 however is giving me the following error:

output
-----------------------------------------------------------------------------------
Invalid drive specification
0 File(s) copied
(null)

As far as I know, no changes have been made to the \\TAPEMACHINE.
The account running SQL has not changed in years and has the proper permissions.
The \\TAPEMACHINE \TAPE_ProductionBackups directory is shared.

I’ve mapped drives to both servers’ directories and it still does not work. Again this has been working for 3 weeks and now all of a sudden says it is an ‘Invalid drive specification’

Does anyone have any idea why this may be happening, I’m stumped.

STEP 1
USE master
EXEC xp_cmdshell 'del \\TAPEMACHINE \TAPE_ProductionBackups\*.BAK'

STEP 2
USE master
EXEC xp_cmdshell 'xcopy \\MYSQL2K\TAPE\*.BAK \\TAPEMACHINE\TAPE_ProductionBackups\ /Y'

Any suggestions or comments are greatly appreciated.

Thanks,

Barbara

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply

Barbara-167570 SSCrazy Points: 2352 More actions · Answer 1

OK, I’ve done a little more probing into this and I think I’ve figured it out.

I was mistaken in my first post. Ends up the specified directory on MYSQL2K were no longer shared as it had been.

Network Admin installed Hotfixes and Security Updates yesterday; I am going to make the assumption that for some reason this removed the shares that had previously been created.

So I re-shared the directory and the job worked successfully.

I also removed the mapped drives from both servers, as this is not necessary for the job to work.

So the issue is no longer an issue, but now I’m curious to know if anyone else run has run into shares being removed when Hotfixes and Security Updates are installed?

Always something…..