Hi Friends,
I am getting output of above query when i change the path like
DECLARE @MyFileName varchar(50), @COMMAND VARCHAR(100)
SELECT @MyFileName = (SELECT 'C:\DBBACKUP\Full\Store\' + convert(varchar(50),GetDate(),112) + '.bak')
-- BACKUP
BACKUP DATABASE store TO DISK = @MyFileName
-- COMPAC ZIP
SET @COMMAND = 'C:\7-Zip\7z.exe A ' + @MyFileName + '.ZIP ' + @MyFileName
EXEC XP_CMDSHELL @COMMAND
in last query path was long now i reduce the path. Please advice me if i want to use longer path what shall i change...
Thanks
Satish