How much info is it practical to keep within a single *.mdf file?
Posted on 2009-05-04
I'm using SQL Server 2008 Workgroup w/ Microsoft Access to run an internal company database. I have about 100 users with no more than 50 on at any one time.
I'm going to be integrating their collection of scanned documents (about 16GB) into the database and I'd expect that to grow to 100GB+ over the next few years. I'm curious... although Microsoft says workgroup can have unlimited database size are there any concerns with having 100GB+ in one mdf?
I can't use filestream at this point because from what I've seen it requires Windows Authentication which would be complicated for me to implement due to most of the company being linux based and my app would require an overhaul to make it work.
So, considering how light the usage is on this server (no more than 50 active users) does storing all this content inside the database seem viable from a performance/stability perspective?
Any input would be appreciated.