Home Dashboard Directory Help
Search

Increase 4GB Limit to SQL Express by Irakli Lomidze


Status: 

Closed
 as By Design Help for as By Design


6
2
Sign in
to vote
Type: Suggestion
ID: 257501
Opened: 2/11/2007 10:13:08 AM
Access Restriction: Public
0
Workaround(s)
view

Description

Dear Sirs.

Now Databases beacame larger and larger. 4GB Limitation for Deploying databases
to the desktop is not enough . For Example i have 60 000 Document Database
Each of the row has a large blob date. actual data (without blob) is 100 mb with blob is larger that 4gb. It will be very nice to increase 4GB limitation for SQL Exprees to 8GB or 12GB. or Not Calculate in SQL Server Database size Blob's sizes. (Example not calculate secondary file size that includes only blobs).

It will be very nice to see more that 4GB limit in Next Service Pack of SQL Server 2005/2008

Details
Sign in to post a comment.
Posted by Judge789 on 2/6/2010 at 7:23 AM
When was the FIRST time the file size limit was INCREASED to 4GB for a Desktop version of SQL server? How many years have passed now? Don't you think it is time to UPGRADE the limitations to keep up with CURRENT needs and current capacity of hard drives, CPU and RAM?
Posted by Irakli Lomidze on 6/13/2009 at 3:08 AM
Answer was use FileStream Type. BUT Dear sirs, I have 60 000-80 000 Documents in database. Now I deploy it as single file (mdf for database, ndf for blobs).
Do you ever try to deploy 60 000 file in your installation ?
How much time will it take.
So in Express Exidtion it will be very nice if Microsft remove limitation on ndf file size. let's keep limitation on mdf file size. but please remove limitation on ndf file size.
Thank you for undertaning
Posted by Maurice Sanders on 11/6/2007 at 5:08 AM
I also agree that 4Gb is not large enough, especially these days. The remark of storing teh documents on disk and referring to it from the database is also no option for us. Making a backup this way makes it not easy. It is too complicated that way. Just making a backup of the database itself (with the documents in it) should be enough.
Posted by Microsoft on 8/9/2007 at 12:55 PM
Thank you for your feedback. The limitations on SQL Express are suited to the primary target users of the product, who typically don't need to store significant amounts of data. At this point we are planning to continue the 4 GB database size limit for SQL Express 2008.

Given that the bulk of your file size is the result of storing blobs, you should take a look at a new feature being introduced in SQL 2008 called Filestream Data. This feature allows for the storage of blobs directly on the NT file system while tracking them from within the database. A bit more can be read about this feature in the SQL 2008 Product Overview available from http://www.microsoft.com/sql/techinfo/whitepapers/sql2008Overview.mspx. This feature will be included in SQL Express and should significantly reduce the size of your file while giving you the flexibility to track your blobs in the database.

Regards,
Mike Wachal
SQL Server Express team
Sign in to post a workaround.