April 28, 2009 at 10:24 pm
can anyone teach me how to setup transactional replication?after that how to know the replication is success or fail..thx
April 28, 2009 at 10:33 pm
You might start here: http://msdn.microsoft.com/en-us/library/bb500348.aspx
It's worth understanding how this works before you set it up. It's pretty simple to set up with the wizard, but you want to know what you're doing. You can see articles here as well:
http://www.sqlservercentral.com/Articles/replication
If you make a change on the first server, it should appear on the subscriber. That will tell you it's working.
April 29, 2009 at 12:30 am
adding a new table izzit considered changes to article??can i use snapshot,logreader agent to know whether my replication work?
April 29, 2009 at 8:04 am
the setup it's self is easy because there is a wizard to walk you through it. I always set it up once on a local machine to test it then do it again after i have made sure it worked.
[font="Comic Sans MS"]Being "normal" is not necessarily a virtue; it rather denotes a lack of courage.
-Practical Magic[/font]
April 29, 2009 at 9:22 am
What I would suggest is to try to set it up in a test environment with the UI and then Script all your Publications.
Then go through the script and try to understand what it does.
When you go to production you can modify these scripts to make it work. It is better to work with scripts than UI.
-Roy
April 30, 2009 at 12:12 am
y my merge replication i add new table to original database but merge replicated data base wont update de??transactional replication got error at logreader agent.the error msg is " the proccess cant execute "sp_replcmds" on "server name"..haiz
April 30, 2009 at 8:15 am
the update will update the tables in it's snapshot. but you can tell it to get a new snapshot and it should then see the new table.
[font="Comic Sans MS"]Being "normal" is not necessarily a virtue; it rather denotes a lack of courage.
-Practical Magic[/font]
May 3, 2009 at 10:00 pm
transactional replication got error at logreader agent.the error msg is " the proccess cant execute "sp_replcmds" on "server name"..haiz....how to fix this?am i wrong install sql server function
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply