A lot of times depending on how large the files are its might be better to use Remote Storage instead of storing stuff in SQL blobs.
Z Edward E. Ziots CISSP, Network +, Security + Security Engineer Lifespan Organization Email:[email protected] Cell:401-639-3505 -----Original Message----- From: Sam Cayze [mailto:[email protected]] Sent: Friday, August 05, 2011 2:08 PM To: NT System Admin Issues Subject: RE: SQL for File Storage? Yes, I think there were problems though, and iirc MS is trying to move away from that. To 'BLOBS' or something. Some sort of external SQL storage mechanism. -----Original Message----- From: Tigran K [mailto:[email protected]] Sent: Friday, August 05, 2011 1:01 PM To: NT System Admin Issues Subject: Re: SQL for File Storage? Sharepoint stores files in SQL with no problem. --T On Fri, Aug 5, 2011 at 10:37 AM, Roger Wright <[email protected]> wrote: > > We have a company pitching a project management solution that stores > all project data, including photos, docs, etc. in SQL. I'm leary > because most of our projects have about 200 MB of related files and > I'm envisioning huge databases. > Should I be, or is SQL more ideal for this type of application than I > suspect? > > Roger Wright > ___ > > Bozone (n.): The substance surrounding stupid people that stops bright > ideas from penetrating. > > > ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ > <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~ > > --- > To manage subscriptions click here: > http://lyris.sunbelt-software.com/read/my_forums/ > or send an email to [email protected] > with the body: unsubscribe ntsysadmin ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~ --- To manage subscriptions click here: http://lyris.sunbelt-software.com/read/my_forums/ or send an email to [email protected] with the body: unsubscribe ntsysadmin ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~ --- To manage subscriptions click here: http://lyris.sunbelt-software.com/read/my_forums/ or send an email to [email protected] with the body: unsubscribe ntsysadmin ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~ --- To manage subscriptions click here: http://lyris.sunbelt-software.com/read/my_forums/ or send an email to [email protected] with the body: unsubscribe ntsysadmin
