MSDE Subscriber's database > 2GB

Hi all !
We have a database with publication on
SBS2003 Premium Edition,
and 4 subscribers on workstations in warehouses on:
- Windows XP Professional
- MSDE
The database is 1.6 GB now and growing
further. I should migrate from MSDE
to SQL Server 2000.
Which version of SQL has to be installed
at warehouses (on top of Win XP Prof)?
Do I have to break the replication before ?
Thanks,
Pagus
Paul,
what about Personal Edition + Win XP Pro ?
Win XP Pro is working OK with MSDE, I wouldn't like to
purchase Win Server product :-(
Pagus
On Mon, 6 Sep 2004 00:48:11 -0700, "Paul Ibison"
<Paul.Ibison@.Pygmalion.Com> wrote:

>Pagus,
>you'll need Standard or Enterprise Edition. The OSs=20
>required for these editions of sql server are:
>Windows Server 2003, Standard Edition1=20
>Windows Server 2003, Enterprise Edition1=20
>Windows Server 2003, Datacenter Edition1=20
>Windows=AE 2000 Server=20
>Windows 2000 Advanced Server=20
>Windows 2000 Datacenter Server=20
>Windows NT=AE Server version 4.0 with Service Pack 5 (SP5)=20
>or later=20
>Windows NT Server 4.0, Enterprise Edition, with SP5 or=20
>later=20
>HTH,
>Paul Ibison
>(The ONLY sql server 2000 replication book:
>http://www.nwsu.com/0974973602p.html)
>
|||Pagus,
you're quire right, subject to the following restrictions:
It includes a concurrent workload governor that limits
its scalability; performance degrades when more than five
Transact-SQL batches are executed concurrently.
It cannot act as a transactional replication publisher
(subscriber only).
Regards,
Paul Ibison

MSDE not upgraded to full version

We have a customer that has MSDE 2000 loaded on his machine. They are
running SBS 2003 Premium, so we took the SQL 2000 CD that came w/ the
system and went to load SQL Server 2000. Well, it didn't give me the
ooption of the default instance.
How can I upgrade the default instance of MSDE to a full version of SQL
Server 2000? Or did i just miss something in the installation?
Darin
*** Sent via Developersdex http://www.developersdex.com ***Never mind - I didn't read the screens inthe setup - I needed to select
UPGRADE.
duh
Darin
*** Sent via Developersdex http://www.developersdex.com ***|||"Darin" <darin_nospam@.nospamever> wrote in message
news:ufd7BopEIHA.3548@.TK2MSFTNGP06.phx.gbl...
> We have a customer that has MSDE 2000 loaded on his machine. They are
> running SBS 2003 Premium, so we took the SQL 2000 CD that came w/ the
> system and went to load SQL Server 2000. Well, it didn't give me the
> ooption of the default instance.
> How can I upgrade the default instance of MSDE to a full version of SQL
> Server 2000? Or did i just miss something in the installation?
> Darin
> *** Sent via Developersdex http://www.developersdex.com ***
You cannot upgrade. You have to install a new instance and then restore or
reattach your existing data to it.
--
David Portas