DB size limit on SQL2k Personal Edition

Does the Personal Edition of SQL Server 2000 (bundled with Enterprise
Edition) have a limit on the database size? I know the Desktop Edition has
the 2 gig limit, I wonder if the Personal Edition is also limited at the same
size...
Thanks in advance...
The SQL Server 2000 Books Online topic on maximum capacities has a footnote
about the DB size limit, it only mentions the DB size limit for MSDE:
3 The data portion of a database cannot exceed 2 GB in size when using the
SQL Server 2000 Desktop Engine (MSDE 2000) or the Microsoft Data Engine
(MSDE) 1.0. The total size of the database, including log files, can exceed
2 GB provided the sum of the sizes of the data files remains 2 GB or lower.
The topic is at
http://msdn2.microsoft.com/en-us/library/aa933149(SQL.80).aspx.
Personal Edition does share many of the other same limitations as MSDE (such
as the amount of RAM and number of CPUs), this is mentioned in the tables
lower in the same topic.
Personal Edition also shares the workload governor with MSDE 2000. For more
info, see this topic and the last three links in the topic:
http://msdn2.microsoft.com/en-us/library/aa224554(SQL.80).aspx
Alan Brewer [MSFT]
SQL Server Documentation Team
Download the latest Books Online update:
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
This posting is provided "AS IS" with no warranties, and confers no rights.
|||MSDE is a _LOT_ better than personal edition
I'd reccomend not using personal edition for anything
"Alan Brewer [MSFT]" <alanbr@.microsoft.com> wrote in message
news:epV4fr0ZHHA.4888@.TK2MSFTNGP06.phx.gbl...
> The SQL Server 2000 Books Online topic on maximum capacities has a
footnote
> about the DB size limit, it only mentions the DB size limit for MSDE:
> 3 The data portion of a database cannot exceed 2 GB in size when using the
> SQL Server 2000 Desktop Engine (MSDE 2000) or the Microsoft Data Engine
> (MSDE) 1.0. The total size of the database, including log files, can
exceed
> 2 GB provided the sum of the sizes of the data files remains 2 GB or
lower.
> The topic is at
> http://msdn2.microsoft.com/en-us/library/aa933149(SQL.80).aspx.
> Personal Edition does share many of the other same limitations as MSDE
(such
> as the amount of RAM and number of CPUs), this is mentioned in the tables
> lower in the same topic.
> Personal Edition also shares the workload governor with MSDE 2000. For
more
> info, see this topic and the last three links in the topic:
> http://msdn2.microsoft.com/en-us/library/aa224554(SQL.80).aspx
> --
> Alan Brewer [MSFT]
> SQL Server Documentation Team
> Download the latest Books Online update:
> http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>