sql server msde: MSDE Data Size -- sql server msde

You're in the

sql server msde

group:

MSDE Data Size

Michael French
8/25/2004 3:46:29 PM

sql server msde:

I am using MSDE. Currently the size of all the data and
system database is 5 gb. I want to know since this is
freeware from Microsoft - what is the size limit and how
is it enforced. The databases are currently working fine
in that they are tested on a remote machine - but I am
trying to anticipate any unpleasant surprises regarding
this issue.

Thanks

Re: MSDE Data Size

Jim Young
8/25/2004 8:02:41 PM

MSDE has a limit of 2GB per database. For more information about the
features and any limitations of MSDE see:

http://www.microsoft.com/sql/msde/

Jim

[quoted text, click to view]

Re: MSDE Data Size

jlpraz NO[at]SPAM corobori.com
8/25/2004 8:49:42 PM

Strange I thought it was 2Gb ! Here is what I found on Ms website:
MSDE 2000 supports up to 2 gigabytes (GB) per database. This
limitation is per database, not per server. A single computer can
support multiple MSDE 2000 instances, each with databases of up to 2
GB in capacity.

Re: MSDE Data Size

Aaron [SQL Server MVP]
8/26/2004 11:33:12 AM

2 gb *per database* ... and this does not include log file sizes.

--
http://www.aspfaq.com/
(Reverse address to reply.)

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server msde group.

home · blog · groups

Questions? Comments? Contact the dn