Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.ms-sqlserver > #1074

Can I use Transaction Replication to Replicate to a database in the same instance

Show all headers | View raw

I was looking at using transaction replication to replicate all inserts and updates to a database to an archive database.  The customer wants to create the archive database on the same server where both the existing database and the applicaiton runs.

All the BOL documentation I have looked at so far only mentions using another server as the target but does the replicated database server actually have to be a different physical server?

-- Mark D Powell --

Back to comp.databases.ms-sqlserver | Previous | Next — Next in thread | Find similar

Thread

Can I use Transaction Replication to Replicate to a database in the same instance Mark D Powell <Mark.Powell2@hp.com> - 2012-05-24 10:44 -0700
  Re: Can I use Transaction Replication to Replicate to a database in the same instance Erland Sommarskog <esquel@sommarskog.se> - 2012-05-24 23:34 +0200
    Re: Can I use Transaction Replication to Replicate to a database in the same instance Mark D Powell <Mark.Powell2@hp.com> - 2012-05-24 14:58 -0700
      Re: Can I use Transaction Replication to Replicate to a database in the same instance Mark D Powell <Mark.Powell2@hp.com> - 2012-05-30 10:32 -0700

csiph-web