Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dolphin123
Yak Posting Veteran
84 Posts |
 Posted - 2012-12-21 : 15:58:26
|
| Hi,I set up snapshot replication. I am looking at replication monitor. [img]http://screencast.com/t/OX0BCt6OkJYC[/img]it says "Running" under the status but down in details it says "No replicated transactions are available.". I checked few tables and it seems that it has been loaded. So why does it say it is running?Regards,D |
|
|
prett
Posting Yak Master
212 Posts |
Posted - 2012-12-24 : 01:01:39
|
| I found the solution on many forums, here are all the steps: 1. Delete the whole replication including, first delete the subscriber then delete the publisher and then the distributer (make sure u delete the distributer by running select * from sysdatabases and u don’t want to see the distribution database (to delete the distributer make the database offline and then delete)2. Create a login (Ex: replication_admin) with sysadmin privileges in publisher, subscriber and in distribution database and make the that login ad dbo for publisher and subscriber databases3. Share the snapshot folder (Ex: \\servername\sharedname\) and gave enough permissions to sql service logins and the login under which u want r going to setup replication4. Create the distributor, gave the snapshot shared folder while configuring the distributer, run the log reader agent and snapshot agents under sql service logins5. Create the publisher and gave the replication_admin login for CONNECT TO DISTRIBUTER option6. Check the replication monitor for any issues7. Configure the subscriber and gave the sql service account login for CONNECT TO PUBLISHER option (if u r using pull subscription)8. My publisher and subscriber servers runs under the same sql service account permissions (login and password is same for both)Hope the solution will help you to resolve the issue!! |
 |
|
|
xingchent
Starting Member
3 Posts |
Posted - 2012-12-27 : 04:01:38
|
| I recently came across your article and have been reading along. I want to express my admiration of your writing skill and ability to make readers read from the beginning to the end. I would like to read newer posts and to share my thoughts with you.[url=http://www.louboutinshoesclub.com]Christian Louboutin Shoes[/url][url=http://www.louboutinshoesclub.com/christian-louboutin-tall-boots-c-490.html]Christian Louboutin Tall Boots[/url][url=http://www.karenmillenstyle.com]Karen Millen Outlet[/url][url=http://www.monclervestes.com/abercrombie-fitch-femme-c-9.html]Abercrombie Fitch Femme[/url][url=http://www.monclervestes.com/doudoune-woolrich-femme-c-12.html]Doudoune Woolrich Femme[/url]xingchent xingchent |
|
|
|
|
|
|
Replication Monitor