Image files and SQL Server

Hello,
What's the best way to store files of an arbitrary size in a SQL
Server / MSDE database? Some files will be text, but most should be
binary (images, audio, and video). I'd like to be able to store all
the files directly in the database so that backing everything up is a
single operation (I can do this, right?). Data retrieval speed is not
overly critical, as the code in question will be running on the same
machine as the database and will only have a single instance of the
client application. Any advice and/or hyperlinks to whitepapers on the
subject would be appreciated.

Thanks,
Will Gant
foehammer@.hotmail.comHi

Check out:
http://www.aspfaq.com/show.asp?id=2149

http://msdn.microsoft.com/library/d...amples_2isp.asp
http://msdn.microsoft.com/library/d...asp?frame=true

John

"Foehammer" <foehammer@.hotmail.com> wrote in message
news:27d68359.0407051151.2adb94ea@.posting.google.c om...
> Hello,
> What's the best way to store files of an arbitrary size in a SQL
> Server / MSDE database? Some files will be text, but most should be
> binary (images, audio, and video). I'd like to be able to store all
> the files directly in the database so that backing everything up is a
> single operation (I can do this, right?). Data retrieval speed is not
> overly critical, as the code in question will be running on the same
> machine as the database and will only have a single instance of the
> client application. Any advice and/or hyperlinks to whitepapers on the
> subject would be appreciated.
> Thanks,
> Will Gant
> foehammer@.hotmail.com|||Well,
I guess the 2 gig limit on MSDE file size is going to be a bit of a
problem. It'll add some complications, but I think I've come up with a
slightly smarter way to do this than in my orginal design.

Thanks,
Will Gant
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message news:<VQiGc.303$UV3.4418796@.news-text.cableinet.net>...
> Hi
> Check out:
> http://www.aspfaq.com/show.asp?id=2149
> http://msdn.microsoft.com/library/d...amples_2isp.asp
> http://msdn.microsoft.com/library/d...asp?frame=true
> John
> "Foehammer" <foehammer@.hotmail.com> wrote in message
> news:27d68359.0407051151.2adb94ea@.posting.google.c om...
> > Hello,
> > What's the best way to store files of an arbitrary size in a SQL
> > Server / MSDE database? Some files will be text, but most should be
> > binary (images, audio, and video). I'd like to be able to store all
> > the files directly in the database so that backing everything up is a
> > single operation (I can do this, right?). Data retrieval speed is not
> > overly critical, as the code in question will be running on the same
> > machine as the database and will only have a single instance of the
> > client application. Any advice and/or hyperlinks to whitepapers on the
> > subject would be appreciated.
> > Thanks,
> > Will Gant
> > foehammer@.hotmail.com