Re: Data File Sizes in NT

In theory, unlimited. BUT, it is release dependent and platform dependent, with blocksize variants. I seem to remember it is 2M blocks, with most OS's the max is 16K block size, so in theory 32GB per file.

NT 8.0.5 (and maybe higher, I am not sure) has a bug that limits it to 8GB per reliable file.

Some OS's have variable settings (such as AIX), so need to check with your SA.

In article <sq9pc01ut91170_at_corp.supernews.com>,   "JT" <jtorres_at_redconnect.net> wrote:
> Max per tablespace is OS dependent.... usually 1022
>
> Max per database 65533, but may be less on some OS, this is also
 limited by
> the size of database blocks and by DB_FILES parameter for a instance.
>
> stuarti <stuirvineNOstSPAM_at_hotmail.com.invalid> wrote in message
> news:030e036c.621e73e4_at_usw-ex0106-046.remarq.com...
> > Does anybody know if there is a max size a data file can be in
> > NT. T think that it is 4 GB, is this correct ???
> >
> >
> >
> >
> > -----------------------------------------------------------
> >
> > Got questions? Get answers over the phone at Keen.com.
> > Up to 100 minutes free!
> > http://www.keen.com
> >
>
>

--
Joseph R.P. Maloney, CCP,CSP,CDP
MPiR, Inc.
502-451-7404
some witty phrase goes here, I think.


Sent via Deja.com http://www.deja.com/
Before you buy.