November 7, 2008 at 7:45 pm
we are running trasaction replication sql 2005 for 5 tables and it is replicated?
Now we have to do replication on same server but different db.
does it will create all agents again ?
November 7, 2008 at 9:59 pm
It will create a new snapshot agent for the publication that you are creating and it will create a new log reader agent for that database. Any other publications that you build against that database can then use the shared agent (log reader agent).
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy