DB size limit on SQL2k Personal Edition

[totoro]

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....

[Alan Brewer [MSFT]]

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

[Aaron Kempf]

MSDE is a _LOT_ better than personal edition

I'd reccomend not using personal edition for anything

Post by Alan Brewer [MSFT]
The SQL Server 2000 Books Online topic on maximum capacities has a footnote
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
http://msdn2.microsoft.com/en-us/library/aa224554(SQL.80).aspx
--
Alan Brewer [MSFT]
SQL Server Documentation Team
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
This posting is provided "AS IS" with no warranties, and confers no rights.

[MarkL]

Came across this post as i think i'm running into a problem with the personal
edition database that has exceeded the 2GB limit (its currently at 3.4GB,
data portion only).

I actually consider the answer below to be quite poor, as it doesn't
actually answer the question; when people ask questions like this they
actually want a Yes/No sort of reply.

I'll assume from the answer that there IS a 2GB limitation on the data
portion of the database. So... what happens when this is reached or exceeded?
Does SQL start throwing errors (the one i'm working with isn't)?

Mark

Post by Alan Brewer [MSFT]
The SQL Server 2000 Books Online topic on maximum capacities has a footnote
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
http://msdn2.microsoft.com/en-us/library/aa224554(SQL.80).aspx
--
Alan Brewer [MSFT]
SQL Server Documentation Team
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
This posting is provided "AS IS" with no warranties, and confers no rights.