PROBLEM:
When running the following SQL using xp_cmdshell you get an error “xp_cmdshell WinRAR.exe is not recognized as an internal or external command”
exec xp_cmdshell 'C:\Program Files\WinRAR\WinRAR.exe a C:\db_Backup\backup.rar C:\db_Backup\BackupFolder'
SOLUTION:
Put the WinRar application path in " "
exec xp_cmdshell '"C:\Program
Files\WinRAR\WinRAR.exe" a C:\db_Backup\backup.rar
C:\db_Backup\BackupFolder'
If you find this solution useful, you are welcome to press one of the ads in this page.. Thanks!
If you find this solution useful, you are welcome to press one of the ads in this page.. Thanks!
thanks dude
ReplyDelete