December 1, 2005 at 8:39 am
Hi,
I need a database file greater than 2 TB. The disk size is 2.5 TB. But SQL 2005 is not letting me create a file greater than 2,097,152 MB. Is there a way to increase the size of it.
Thanks,
Ray
December 1, 2005 at 12:29 pm
In sql2005 size specifications are
Database size 1,048,516 TB
File size (db) 32 TB and file size (log) 32 TB
so you do not need to increase the size, probably you are having some other issues.
Here is my reference for the details that I have provided
http://www.sqlservercentral.com/columnists/sjones/maximumcapacityspecificationsinsqlserver2005.asp
http://www.yukonxml.com/Reference/default.aspx?t=Capacity
Kindest Regards,
Sameer Raval [Sql Server DBA]
Geico Insurance
RavalSameer@hotmail.com
December 2, 2005 at 2:16 am
Could RECYCLER folder cause the 2.5 TB to be actually be less?
Turn it off for that drive. I am sure that there is some scratch space required on a drive, 100% utilization can never be achieved, IMHO.
Andy
December 6, 2005 at 6:35 am
I am assuming you have an NTFS file system in which case microsoft say "2 terabytes should be considered the practical limit for both physical and logical volumes using NTFS". The article http://www.microsoft.com/resources/documentation/Windows/2000/server/reskit/en-us/Default.asp?url=/resources/documentation/Windows/2000/server/reskit/en-us/core/fncc_fil_tvjq.asp explains it is due to cluster sizes and/or partioning table restictions.
I wouldnt recommend having files that big anyway. If you get corruption in your tables then you will have difficultly restoring them from backups! Try splitting the database into several filegroups. This permits quicker recoveries and you can set some file groups to be read only to improve perormance. You can also put them on different arrays for better disk IO depending on each tables write/read profile.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply