Solved

How much info is it practical to keep within a single *.mdf file?

Posted on 2009-05-04
1
208 Views
Last Modified: 2012-05-06
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.
0
Comment
Question by:DailyDilemma
1 Comment
 
LVL 31

Accepted Solution

by:
RiteshShah earned 500 total points
Comment Utility
well, as you know your workgroup edition supports unlimited database size and that is true but the way you are going to grow with your database, I recommend you to create more filegroups and split your database into few more file group to decrease IO load.
0

Featured Post

Complete Microsoft Windows PC® & Mac Backup

Backup and recovery solutions to protect all your PCs & Mac– on-premises or in remote locations. Acronis backs up entire PC or Mac with patented reliable disk imaging technology and you will be able to restore workstations to a new, dissimilar hardware in minutes.

Join & Write a Comment

After restoring a Microsoft SQL Server database (.bak) from backup or attaching .mdf file, you may run into "Error '15023' User or role already exists in the current database" when you use the "User Mapping" SQL Management Studio functionality to al…
If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

728 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now