HI I have microsoft sql server 2008 r2 every day my hard disk expanding 2-3gb in data base properties recovery model is simple,I shrink log file but data base expanding every day how can I stop this process?if I shrink data base it will be normal?

You need to look inside the database and determine what causes it to grow. Is it data, if so, what tables. Or is it log? Etc. I never recommend doing shrink on regular basis, instead you should allow the database be the size it need to be.

More info: http://www.karaszi.com/SQLServer/info_dont_shrink.asp

I looked up using Windirstat it shows that most of the space on my hard drive  files  .jpg

I looked up using Windirstat it shows that most of the space on my hard drive  files  .jpg

And the .MDF Database files takes just a small part; instead of shrink database better delete/move the JPG's

That means that shrinking the database files won't give you any benefits (but still all disadvantages). Instead you need to work on that it is that uses all that disk space! Apparently jpegs.

thank you I find directory this attachments previews i find older image here

thank you I find directory this attachments previews i find older image here

I cannot tell you whether to delete or not, you have to consult your team members and find out and take necessary action. I would never shrink DB for 2G space

I consulted with application firm they answered me I can delete this images thanks to all