Replication between instances

we are looking to doing a transactional replication of a database of 12 gig
between instances of sql 2000 on the same server.
We want to do this so we can have a read database and a write database.
On other setups we have had a write database and a read database different
servers. We have never attempted to do it on the same server. Has anyone
found any issues doing this in a live enviroument.
Cheers
In general transactional replication (which should should be using) has a
low resource footprint on your server. However this depends highly on the
amount of transactions you are replicating.
Hilary Cotter
Looking for a SQL Server replication book?
Now available for purchase at:
http://www.nwsu.com/0974973602.html
"Rory P" <Rory P@.discussions.microsoft.com> wrote in message
news:7B06EFE4-5EF9-4450-A375-BB87598EC20D@.microsoft.com...
> we are looking to doing a transactional replication of a database of 12
> gig
> between instances of sql 2000 on the same server.
> We want to do this so we can have a read database and a write database.
> On other setups we have had a write database and a read database different
> servers. We have never attempted to do it on the same server. Has anyone
> found any issues doing this in a live enviroument.
> Cheers
|||On 2004-12-03, Rory P <> wrote:
> we are looking to doing a transactional replication of a database of 12 gig
> between instances of sql 2000 on the same server.
> We want to do this so we can have a read database and a write database.
> On other setups we have had a write database and a read database different
> servers. We have never attempted to do it on the same server. Has anyone
> found any issues doing this in a live enviroument.
Never tried with transactional, but merge works. Publisher and subscriber
can even be same server (same instanc), you publish one database and
subscribe another one, on same instance.
Mike
"I can do it quick. I can do it cheap. I can do it well. Pick any two."
Mario Splivalo
msplival@.jagor.srce.hr