• 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