|
Home > Archive > Microsoft SQL Server forum > August 2005 > Replication
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
|
| 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 2005-08-19, 8:23 pm |
| jai (dba_sybase2003@yaho
o.com) writes:
> Hi guys,
> Is it possible to replicate in MSSQL SERVER standard edition and be
> supported??? Or do I need to buy enterprise edition.
>
You can do replicaiton in Standard Edition.
--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp
| |
|
| Yeah I kind of knew that replication is possible in the standard
edition but will MIcrosoft support it.
Regards
Jaideep
| |
| Erland Sommarskog 2005-08-22, 8:23 pm |
| jai (dba_sybase2003@yaho
o.com) writes:
> Yeah I kind of knew that replication is possible in the standard
> edition but will MIcrosoft support it.
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@sommarskog.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp
| |
|
| 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 2005-08-22, 8:23 pm |
| jai (dba_sybase2003@yaho
o.com) writes:
> 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???
You will have to ask the friendly people in
microsoft.public.sqlserver.replication 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@sommarskog.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp
| |
| Greg D. Moore \(Strider\) 2005-08-22, 8:23 pm |
|
"jai" < dba_sybase2003@yahoo
.com> wrote in message
news:1124737698.551148.233410@z14g2000cwz.googlegroups.com...
> 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???
>
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.
> Regards
>
> Jaideep
>
|
|
|
|
|