May 20, 2015 at 7:47 am
Original database was created in SQL2005 which was upgraded to SQL2008 while migrating to new server and finally upgrading to SQL2008R2 for the increase in database max size, it is not registering the max size as 10gb.
Thanks in advance,
May 20, 2015 at 8:33 am
Do you want 10gb max size? Have you moved from Express edition to standard/enterprise? because 10gb is an express edition limitation. What are you trying to do?
May 20, 2015 at 8:40 am
We started out with 2005Express which is 4gb max, went to 2008Express while migrating to a new server which still was 4gb max and finally went to 2008r2Express which should be 10gb max but that is not what is registering.
May 20, 2015 at 9:01 am
where are you looking to see this information? or have you reached that 4gb limit and even in 2008r2 express not allowed past it? If you are looking in databases properties>files, it may be that someone has explicitly set the max file size to 4gb.
May 20, 2015 at 9:13 am
I am showing the properties of the database in SQL Server Management Studio, Size: 3600.81 MB, Space Available: 19.14 MB. That's probably not where I should be looking?
May 20, 2015 at 9:20 am
No, the database file presently has a small amount of space available, however it will be able to grow up to 10gb, as long as the autogrowth setting is enabled for the database. you will be able to see by looking at the autogrowth setting in database properties>files
May 20, 2015 at 9:40 am
That field is set to; Autogrowth: By 1 MB, unrestricted growth
May 20, 2015 at 9:45 am
best practice is to reduce the amount of autgrowths. so if 10gb is the max the db is ever going to grow, you might as well set the initial size to 10gb and be done with it.
set this on the database properties>files page, set the initial size for the mdf file to 10gb. also set the autogrowth for the log file to a reasonable size, say 5gb. as long as you have the drive space to accomodate this.
May 20, 2015 at 9:48 am
I would guess that the 10GB limit is a limit of SQL Server Express Edition, not a property of the database itself. Therefore, although the database property shows unlimited growth, sooner or later it will hit the SQL Server Express Limit.
John
May 20, 2015 at 10:13 am
Updated properties>files; Initial Size to 10000 and set Autogrowth to By 1 MB, restricted to 10000, we've got plenty of disk space on the server. That should do it,
Thanks,
May 21, 2015 at 3:41 am
Hi,
i dont't unterstand this settings:
Initial Size to 10.000 MB
Autogrowth to By 1 MB
restricted to 10.000 MB
You need no autogrowht, because you have defined the size with 10.000 MB. If the database would be full, the autogrowht might start with 1 MB, but it is restricted to 10.000 MB.
And, i would never use autogrowth with only 1 MB !!!!
Kind regards,
Andreas
May 21, 2015 at 3:44 am
as such it doesn't really matter about the autogrowth setting, as the db can't grow due to the limitations of express. that's why i advised setting the db to it's max size initially. if the db was able to grow you would want to set the autogrowth to much larger chunks.
May 21, 2015 at 3:44 am
Maximum size and autogrowth are separate properties. The autogrowth just means what it will grow by if there's space to do so. And yes, default values for properties aren't always the best!
John
Viewing 13 posts - 1 through 12 (of 12 total)
You must be logged in to reply to this topic. Login to reply