2 GB for each db and 5 db for each instance

anonymous_at_discussions.microsoft.com
Date: 04/08/04 

Date: Thu, 8 Apr 2004 14:27:50 -0700

I read the following msg in a previous post:
"Each database MSDE manages can access up to 2GB. 5
databases in an instance = 5 x 2 = 10GB Each system can
host up to 16 instances."

I thought I can create as many database as I need to
overcome the 2 GB limit and didn't know there's a 5
database limit.
However I did a little experiment and created 8 databases
use the statement like the following:
create database db1
go
create database db2
go
.
.
.
  the default size is only 0.63 MB for each db. It seems I
can create more if I want. Can anyone give additional info
on the 5 db limit?

Thanks.

Relevant Pages

  • UPDATE weird sendmail problem on Solaris 9 (fwd)
    ... I was asked to supply info about my sendmail config and my nsswitch.conf ... names that should be exposed as from this host, ... # list of locations of user database file ... # SMTP STARTTLS server options ...
    (SunManagers)
  • Re: Transferring web hosts - php/mysql application
    ... application from host to host are os specific calls. ... If your application simply has sessions and uses mysql as a back end ... database then the pain of transfer will be very small. ... create mysql database user ...
    (php.general)
  • Re: The Sorrows of Record Cataloguing
    ... database isn't. ... It is important to me that any such application for my iPhone have the ... to host my database. ... paying extra for SQL Server capabilities. ...
    (rec.music.classical.recordings)
  • The convenient database engine for a "Distributed" System
    ... - Many hosts connected via VPN to a server. ... The problem is that the database structure may change, ... change the database structure of each host. ... to install it silently, I mean ...
    (comp.lang.python)
  • Re: Any security problems
    ... Those are the good host... ... FrontPage Resources, WebCircle, MS KB Quick Links, etc. ... >> secure, then the database is ...
    (microsoft.public.frontpage.client)