|
amirs
Posting Yak Master
India
244 Posts |
 Posted - 04/12/2012 : 05:10:39
|
Dear Member
I have zip backup file to use following command
DECLARE @SERVER VARCHAR(100), @COMMAND VARCHAR(100), @FILE VARCHAR(100),@PATH VARCHAR(30)
SET @SERVER = @@SERVERNAME
SET @COMMAND = '"C:\Program Files\WinRAR\RAR.exe" A "D:\SQLBACKUPS\FILE_BACKUP.BK"'
EXEC XP_CMDSHELL @COMMAND
but i got a following error
'C:\Program' is not recognized as an internal or external command,
operable program or batch file.
i think it is not read a program file path so how to execute this command |
|
zip backup file in sql command
