2GB Limit

What happens when an SQL2K MSDE database reaches 2GB? I've actually seen
MSDE databases reach that size and nothing happened.
Thanks,
Ademar.
hi Ademar,
Ademar Nunes wrote:
> What happens when an SQL2K MSDE database reaches 2GB? I've actually
> seen MSDE databases reach that size and nothing happened.
when you exceed that limit, nex time the Storage Engine requires a file
allocation beyond the allocated space, thus trying expanding the data file,
an exception will be raised..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Maybe the 2GB+ installation I'm referring to is actually a Personal edition
and not MSDE.
I'll run the SELECT @.@.VERSION statement on it and I'm assuming that will
tell me if it is MSDE.
Thanks,
Ademar.
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:3o8jmjF4mu4pU1@.individual.net...
> hi Ademar,
> Ademar Nunes wrote:
> when you exceed that limit, nex time the Storage Engine requires a file
> allocation beyond the allocated space, thus trying expanding the data
> file, an exception will be raised..
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
|||Hi,
If it is Personal edition; there is no db size limitation. See details in
below URL
http://msdn.microsoft.com/library/?u...asp?frame=true
Thanks
Hari
SQL Server MVP
"Ademar Nunes" <anunes@.myemail.com> wrote in message
news:%23VOAP38sFHA.3500@.TK2MSFTNGP09.phx.gbl...
> Maybe the 2GB+ installation I'm referring to is actually a Personal
> edition and not MSDE.
> I'll run the SELECT @.@.VERSION statement on it and I'm assuming that will
> tell me if it is MSDE.
> Thanks,
> Ademar.
> "Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
> news:3o8jmjF4mu4pU1@.individual.net...
>