December 31, 2008 at 2:07 am
Hi,
I have getting the following error while compressing a file with rar32.exe in a stored procedure with 'exec xp_cmdshell';
Virtual Memory exceed in 'new'
and aborts compressing. Is it an error about SQL Server memory or relates with OS Memory strategies?
December 31, 2008 at 6:17 am
What is the file size and what error do you get if you try compressing it by using rar32.exe directly without using sql cmdshell SP?
MJ
January 1, 2009 at 10:01 pm
What version SQL is this for, and is it x86 or x64? I would suspect that you are getting multi-page allocations from the VAS/MTL and that you are on x86 which is going to run out of the VAS/MTL reservation. You would probasbly be best served creating a SSIS package to do the RAR operation and calling it in a SQL Agent Job using sp_start_job from TSQL.
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
January 2, 2009 at 5:08 am
You can use robocopy in .bat file
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply