If you're using SQL 2008 you can enable FILESTREAM for BLOB storage to the filesystem. This is a system property so all Attachment fields, both existing and ones created in the future, will use this storage mechanism.
-----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]]on Behalf Of LJ Longwing Sent: Monday, February 09, 2009 9:53 AM To: [email protected] Subject: Re: Attachments getting out of contol I'm curious. How will storing them outside the DB decrease the amount of space used? Remedy does do some form of compression on the file when it's stored in the DB, and if you store it outside of the DB you still have the same file, yet not compressed sitting on a fileserver....where you need to now manage a process of how to get it to the filesystem, and back to the user when they need it. -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Shyam Attavar Sent: Monday, February 09, 2009 9:44 AM To: [email protected] Subject: Re: Attachments getting out of contol I am positive one can use the file system plug-in and some custom workflow to do this. However, I have not done this myself. Not sure if anyone else on the list has done this at all? -- Shyam ----- Original Message ----- From: "Timothy Rondeau" <[email protected]> Newsgroups: gmane.comp.crm.arsystem.general To: <[email protected]> Sent: Monday, February 09, 2009 7:26 AM Subject: Attachments getting out of contol Hi, Hi, We are running ITSM 7 ar 7.0.1 patch 2 on SQL DB. Looking to see if it is possible to store attachments outside of the database? Attachments are just getting to big. Thanks Tim ____________________________________________________________________________ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" ____________________________________________________________________________ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"
