MSDE 2BG limit - for just the data file?

Hi -
I'm looking at an archive strategy for an MSDE database.
In ref to the 2GB "database size" limit: anyone know if
this applies to the log file size + data file size, or
just to the data file size?
I need to figure out the point at which archiving needs
to kick in and trim down an in-production database.
Thanks!
Andy
hi Andy,
Andy wrote:
> Hi -
> I'm looking at an archive strategy for an MSDE database.
> In ref to the 2GB "database size" limit: anyone know if
> this applies to the log file size + data file size, or
> just to the data file size?
> I need to figure out the point at which archiving needs
> to kick in and trim down an in-production database.
> Thanks!
> Andy
the 2gb limit only applies to the sum of data files, including primary
(.Mdf) and all eventual secondary (.Ndf) files...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Great, thanks Andrea!
|||Hi
2Gb for the data file, per database.
You could have more than one database.....
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Andy" <anonymous@.discussions.microsoft.com> wrote in message
news:0dbd01c5092b$ac4a6e90$a601280a@.phx.gbl...
> Hi -
> I'm looking at an archive strategy for an MSDE database.
> In ref to the 2GB "database size" limit: anyone know if
> this applies to the log file size + data file size, or
> just to the data file size?
> I need to figure out the point at which archiving needs
> to kick in and trim down an in-production database.
> Thanks!
> Andy