Reducing Image File Size in SQL Server 2005

I have a table for file attachments, and the majority of them are images.  They are stored in image field iin SQL server, with a corresponding "mimetype" varchar field indicating the file type (if that matters). There are a few hundred TIFF and BMP files, but the majority (15,000) of them are listed as PJPEG file types

I would like to run something to reduce the size of these images, I know many are 5-10MB and they don't need to be anywhere that big.  The backup filesizes are getting out of hand and it's all due to these pictures.

What are my options to reduce the size of these images or the table as a whole?
synapse88Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
pinaldaveConnect With a Mentor Commented:
Unfortunately answer to your question is that it is not possible using any solution of SQL.

You may have to programmatically reduce this in your application

Regards,
Pinal Dave
0
 
cdaly33Connect With a Mentor Commented:
I can't think of a way to do it in sql but I use the techniques described in this post on a daily basis and it works great for me.  You could make a process that runs every so often to look for files over a certain size and run the thumbnail routine on them.
http://forums.asp.net/t/521072.aspx
0
 
Anthony PerkinsCommented:
It is not possible.
0
 
synapse88Author Commented:
Well is there some program (.net or otherwise) that will process the images to reduce the filesize?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.