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.
| Author |
Topic |
|
amirs
Constraint Violating Yak Guru
260 Posts |
 Posted - 2012-04-12 : 05:10:39
|
| Dear MemberI have zip backup file to use following commandDECLARE @SERVER VARCHAR(100), @COMMAND VARCHAR(100), @FILE VARCHAR(100),@PATH VARCHAR(30)SET @SERVER = @@SERVERNAMESET @COMMAND = '"C:\Program Files\WinRAR\RAR.exe" A "D:\SQLBACKUPS\FILE_BACKUP.BK"'EXEC XP_CMDSHELL @COMMANDbut 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 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
zip backup file in sql command