Attachments...server load....HELP!

[voclain]

First let me say thanks for a place like this where we can ask questions!!!

I have a board that is used by profesional photographers.

They are requesting that I UP the limit on "Attachments"...you see....images, stuff from Photoshop, etc...all take mega space.

Currently, I have my attachements stored in the "FILE SYSTEM"....not in the Database.

So...here is my question.......

Can the attachments be stored OFF SITE....meaning....now they are in and on the same server as the files.....IF I were to purchase another SERVER.....and had ONE server JUST for attachements (I have probably 50 gigs...and now they want me to increase the size limits...so...I'm going to need 200 gigs).....that way....as they are used and downloaded....it would not put a strain on the server running the file system.

So...there you have my delema......CAN I DO THAT SOME HOW?????

Any suggestion would be greatly appreciated.

Just thought of something.....didn't I read some where that the DATABASE can be on another server????? and the FILES SYSTEM on another????

OK....so....if I did that....and kept the attachments IN the DATABASE....would that work????

AGAIN...thank you for your support.

Yours,

Kirk