[dba-SQLServer]MSDE Replication - Crossposted

howard gramer hagdb at hotmail.com
Thu Mar 27 22:54:01 CST 2003


For what it's worth..not sure what it means:

A2KDH Volume 2: Enterprise Edition, pg.159
It states specifically about MSDE:

"Can only be a replication subscriber, not a publisher"

howard

----- Original Message -----
From: "John W. Colby" <jcolby at colbyconsulting.com>
To: "AccessD" <AccessD at databaseadvisors.com>
Cc: "SQLServer" <dba-sqlserver at databaseadvisors.com>
Sent: Thursday, March 27, 2003 9:57 PM
Subject: [dba-SQLServer]MSDE Replication - Crossposted


> On a related note...
>
> MDSE claims to support replication.  I don't know enough about MDSE, never
> mind replication, to understand the issues - but...
>
> If each workstation ran MSDE and the server runs MSDE, then you have
> effectively created SQL Server for more than "5 simultaneous users".
Since
> each user is now hitting a SQL Server Be on their own machine, with only
> replication data going to the main BE on the server, it certainly sounds
> like you could get fairly decent performance for 10 or 20 users.
>
> John W. Colby
> Colby Consulting
> www.ColbyConsulting.com



More information about the dba-SQLServer mailing list