Replication

[jai]

Hi guys,
Is it possible to replicate in MSSQL SERVER standard edition and be
supported??? Or do I need to buy enterprise edition.

Regards

Jaideep

[Erland Sommarskog]

Re: Replication

jai (dba_sybase2003 @yahoo.com) writes:[color=blue]
> Hi guys,
> Is it possible to replicate in MSSQL SERVER standard edition and be
> supported??? Or do I need to buy enterprise edition.
>[/color]

You can do replicaiton in Standard Edition.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarsk og.se

Books Online for SQL Server SP3 at

http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

[jai]

Re: Replication

Yeah I kind of knew that replication is possible in the standard
edition but will MIcrosoft support it.

Regards

Jaideep

[Erland Sommarskog]

Re: Replication

jai (dba_sybase2003 @yahoo.com) writes:[color=blue]
> Yeah I kind of knew that replication is possible in the standard
> edition but will MIcrosoft support it.[/color]

Yes.

Please check Books Online, the book SQL Server Architecture ->
Implementation Details -> Editions of SQL Server 2000 ->
Features Supported by the Editions of SQL Server 2000.



--
Erland Sommarskog, SQL Server MVP, esquel@sommarsk og.se

Books Online for SQL Server SP3 at

http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

[jai]

Re: Replication

Erland,
I am new to sql server replication but I have worked with sybase
replication. At present, the machine housing the sql server has 2 g of
memory with 1.4 g for sql server. How much more (memory), would I need
if I make the same machine work as publisher as well as the
distributor???

Regards

Jaideep

[Erland Sommarskog]

Re: Replication

jai (dba_sybase2003 @yahoo.com) writes:[color=blue]
> Erland,
> I am new to sql server replication but I have worked with sybase
> replication. At present, the machine housing the sql server has 2 g of
> memory with 1.4 g for sql server. How much more (memory), would I need
> if I make the same machine work as publisher as well as the
> distributor???[/color]

You will have to ask the friendly people in
microsoft.publi c.sqlserver.rep lication about that. My own experience
of replication is very thin. My gut feeling is that it would depend a
lot of the data volume you intend to replicate.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarsk og.se

Books Online for SQL Server SP3 at

http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

[Greg D. Moore \(Strider\)]

Re: Replication


"jai" <dba_sybase2003 @yahoo.com> wrote in message
news:1124737698 .551148.233410@ z14g2000cwz.goo glegroups.com.. .[color=blue]
> Erland,
> I am new to sql server replication but I have worked with sybase
> replication. At present, the machine housing the sql server has 2 g of
> memory with 1.4 g for sql server. How much more (memory), would I need
> if I make the same machine work as publisher as well as the
> distributor???
>[/color]

Howmuch data do you expect to replicate at any time?

Basically all that happens is the log reader puts rows into a distribution
DB which then gets used to distribute them to the subscribers.

You probably have enough RAM since you can't get much more in Standard
version anyway.

[color=blue]
> Regards
>
> Jaideep
>[/color]