restricted file growth - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Express Edition and Compact Edition (2005)

restricted file growth

Author

Topic

sinjin67
Yak Posting Veteran

53 Posts

Posted - 2008-01-15 : 13:20:54

Hello Everyone,

I appear to be doing something wrong. When I
set my Table for Unrestricted File Growth and
save it, When I go back and look at the settings
it is set back to restricted file growth.

It seems to me if you set any settings and apply
and/or save it. Should it not keep that setting.

Any advice would be great.

Thanks

sinjin67
Yak Posting Veteran

53 Posts

Posted - 2008-01-17 : 20:17:23

Good Evening All,

After some reading I found the answer to this
problem.. It appears according to the Microsoft
documentation that SQL Express has a 4 GIG limit.

In my case I would hit that file size in no time.

So I opted to upgrade to the Standard Version which
is unlimited and was able to migrate all my tables
and data.

Maybe this info will help another not have to read so
much...

Peace

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources