Maximum SQL database size

Maximum SQL database size

Post by Erik Veenhuijse » Wed, 14 Jul 2004 09:22:37



Can anyone tell me, what the maximum size of a SQL 2000 database is with the
version delivered with SBS2003 Premium Edition?

With regards,
Erik.

 
 
 

Maximum SQL database size

Post by Steve Foster [SBS MVP » Wed, 14 Jul 2004 16:39:24



> Can anyone tell me, what the maximum size of a SQL 2000 database is
> with the version delivered with SBS2003 Premium Edition?

As big as your hard disk.

--
Steve Foster [SBS MVP]
---------------------------------------
MVPs do not work for Microsoft. Please reply only to the newsgroups.

 
 
 

Maximum SQL database size

Post by Erik Veenhuijse » Wed, 14 Jul 2004 18:15:15


Steve, thanks, i got an answer that the maximum size was 2GB and since we
want to use it to hold an 120GB database, i started to freak out a little
bit for a moment.
But if i understand correctly that shouldn't be a problem with this version.




> > Can anyone tell me, what the maximum size of a SQL 2000 database is
> > with the version delivered with SBS2003 Premium Edition?

> As big as your hard disk.

> --
> Steve Foster [SBS MVP]
> ---------------------------------------
> MVPs do not work for Microsoft. Please reply only to the newsgroups.

 
 
 

Maximum SQL database size

Post by Steve Foster [SBS MVP » Thu, 15 Jul 2004 04:17:56



> Steve, thanks, i got an answer that the maximum size was 2GB and
> since we want to use it to hold an 120GB database, i started to freak
> out a little bit for a moment.
> But if i understand correctly that shouldn't be a problem with this
> version.

MSDE has a 2Gb database limit.

SBS2003 (both editions) uses MSDE for the Monitoring database, though
you can upgrade it to full SQL in Premium if you wish (not that there's
any reason to do so).

SBS2003 also has WMSDE (basically MSDE without the 2Gb limit) for WSS
(CompanyWeb), which may also be upgraded to full SQL Server in Premium
if you wish. This is worth doing, since it means you get full-text
indexing for WSS.

On top of that, you may of course install a default instance of SQL
Server on Premium too. This has all the same limits as plain SQL
Server, Standard Edition.

--
Steve Foster [SBS MVP]
---------------------------------------
MVPs do not work for Microsoft. Please reply only to the newsgroups.