MSDE 2GB Limit

Hi
A Client has an MSDE install - checked by running @.@.version (clearly
says developer edition in the result text).
However the size of the data file is over 3GB, even allowing for empty
spaces the amount of data far exceeds 2GB. Pls explain?
The database was filled by regular insert statements.
Am 31 Oct 2005 04:14:49 -0800 schrieb yitzak:

> Hi
> A Client has an MSDE install - checked by running @.@.version (clearly
> says developer edition in the result text).
> However the size of the data file is over 3GB, even allowing for empty
> spaces the amount of data far exceeds 2GB. Pls explain?
> The database was filled by regular insert statements.
MSDE always shows "Desktop Engine" and not "Developer Edition"!
bye,
Helmut

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

MSDB up to 2GB due to DTA

I noticed my MSDB database is up over 2GB. Most of the data is in
DTA_tuninglog. Is there a process to purge this data? Can I simply delete
all the rows or will that cause an inconsistency with another table?
Thanks
Ron
Hi Ron,
I am not sure what version of the server you have running, however check
this link out as I think it may help you clean up the database:
http://support.microsoft.com/kb/899634
Take care.
~lb
"Ron" wrote:

> I noticed my MSDB database is up over 2GB. Most of the data is in
> DTA_tuninglog. Is there a process to purge this data? Can I simply delete
> all the rows or will that cause an inconsistency with another table?
> Thanks
> Ron

MSDB up to 2GB due to DTA

I noticed my MSDB database is up over 2GB. Most of the data is in
DTA_tuninglog. Is there a process to purge this data? Can I simply delete
all the rows or will that cause an inconsistency with another table?
Thanks
RonHi Ron,
I am not sure what version of the server you have running, however check
this link out as I think it may help you clean up the database:
http://support.microsoft.com/kb/899634
Take care.
--
~lb
"Ron" wrote:
> I noticed my MSDB database is up over 2GB. Most of the data is in
> DTA_tuninglog. Is there a process to purge this data? Can I simply delete
> all the rows or will that cause an inconsistency with another table?
> Thanks
> Ron