Problem with 7zip unzip using exec master..xp_cmdshell

[JinxT]

Hi,

I am trying to implement custom log shipping but only have Standard Edition to am unable to use compressed backups..so have resorted to a customised version. As our transaction log files can reach several gb I need them zipped.

I have managed to zip a file using xp_cmdshell as follows:

exec master..xp_cmdshell 'C:\Progra~1\7-Zip\7z.exe a -t7z "D:\Microsoft SQL Server\MSSQL\Backup\archive_data.7z" "D:\Microsoft SQL Server\MSSQL\Backup\data.bak"'  

But I cannot get the syntax correct for unzipping the file.
I've tried using similar code to above by replacing the 'a' with an 'e' or 'x' but get the following error:

Cannot use absolute pathnames for this command.

I've tried different pathnames but all generate similar errors, or simply do not recognise the path at all.

Can any one point me in the right direction?

Thanks,

Jinx.

[tonk]

I've done a quick test and the following seems to work for me...

exec master..xp_cmdshell 'C:\Progra~1\7-Zip\7z.exe e "D:\Microsoft SQL Server\MSSQL\Backup\archive_data.7z" -o"D:\Microsoft SQL Server\MSSQL\Backup\"'

The ‘e’ option tells 7Zip to do the extraction, the ‘–o’ option tells 7Zip where to put the extracted files, putting in an absolute path in seems to work for me, lemme know if you have any problems ^^

[JinxT]

Thanks Tonk, including the '-o' in the "" solved it for me!