Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 Replication Monitor
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Yak Posting Veteran

84 Posts

Posted - 12/21/2012 :  15:58:26  Show Profile  Reply with Quote

I set up snapshot replication. I am looking at replication monitor. br / " border="0">

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?


Posting Yak Master

212 Posts

Posted - 12/24/2012 :  01:01:39  Show Profile  Visit prett's Homepage  Reply with Quote
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 databases

3. 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 replication

4. Create the distributor, gave the snapshot shared folder while configuring the distributer, run the log reader agent and snapshot agents under sql service logins

5. Create the publisher and gave the replication_admin login for CONNECT TO DISTRIBUTER option

6. Check the replication monitor for any issues

7. 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!!
Go to Top of Page

Starting Member

3 Posts

Posted - 12/27/2012 :  04:01:38  Show Profile  Reply with Quote
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=]Christian Louboutin Shoes[/url]
[url=]Christian Louboutin Tall Boots[/url]
[url=]Karen Millen Outlet[/url]
[url=]Abercrombie Fitch Femme[/url]
[url=]Doudoune Woolrich Femme[/url]

xingchent xingchent
Go to Top of Page
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.02 seconds. Powered By: Snitz Forums 2000