<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
SQL Server 2005
»
Administering
»
I create new Subscriber and getting error The...
12 posts, Page 1 of 2
1
2
»»
I create new Subscriber and getting error The row was not found at the Subscriber when applying the replicated command.
Rate Topic
Display Mode
Topic Options
Author
Message
MAK-1128556
MAK-1128556
Posted Thursday, August 20, 2009 8:29 AM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Wednesday, September 01, 2010 7:44 AM
Points: 176,
Visits: 290
One of my Subscriber is running fine, but when I create new Subscriber I am getting following error
The row was not found at the Subscriber when applying the replicated command.
Post #774258
Steve Jones - SSC Editor
Steve Jones - SSC Editor
Posted Thursday, August 20, 2009 8:45 AM
SSC-Dedicated
Group: Administrators
Last Login: Today @ 3:30 PM
Points: 31,436,
Visits: 13,751
Did you apply a snapshop to initialize the new subscriber?
Follow me on Twitter:
@way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
Post #774279
MAK-1128556
MAK-1128556
Posted Thursday, August 20, 2009 8:52 AM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Wednesday, September 01, 2010 7:44 AM
Points: 176,
Visits: 290
No, do I have to initialize that, I restore the last night data and just create a subscriber with out initialize.
Post #774290
Steve Jones - SSC Editor
Steve Jones - SSC Editor
Posted Thursday, August 20, 2009 9:03 AM
SSC-Dedicated
Group: Administrators
Last Login: Today @ 3:30 PM
Points: 31,436,
Visits: 13,751
You might need to if the tables in the article might have changed.
When you set up the subscriber, it ought to ask to initialize the subscriber.
Follow me on Twitter:
@way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
Post #774301
MAK-1128556
MAK-1128556
Posted Thursday, August 20, 2009 9:20 AM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Wednesday, September 01, 2010 7:44 AM
Points: 176,
Visits: 290
hi I recreate the subscriber with initianilaze, now I am getting following error
The initial snapshot for publication 'OLTP_PUB_ALL_Tables' is not yet available.
also when I check the properties of Subscriber I can see Subscriber Status is "Pending"
Post #774316
alen teplitsky
alen teplitsky
Posted Thursday, August 20, 2009 9:39 AM
Ten Centuries
Group: General Forum Members
Last Login: 2 days ago @ 8:15 PM
Points: 1,409,
Visits: 4,509
on the subscription reinitialize it. then start it manually to make sure you get the message that the snapshot is not available.
run the snapshot
run the log reader
start the subscription and it should start copying the snapshot and then any transactions that happened during the snapshot copy
https://plus.google.com/100125998302068852885/posts?hl=en
http://twitter.com/alent1234
x-box live gamertag: i am null
[url=http://live.xbox.com/en-US/MyXbox/Profile[/url]
Post #774332
MAK-1128556
MAK-1128556
Posted Thursday, August 20, 2009 9:43 AM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Wednesday, September 01, 2010 7:44 AM
Points: 176,
Visits: 290
How to run the log reader
Post #774339
MAK-1128556
MAK-1128556
Posted Thursday, August 20, 2009 9:48 AM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Wednesday, September 01, 2010 7:44 AM
Points: 176,
Visits: 290
Hi I am getting following error, when I pick up the option initinalize
The initial snapshot for publication 'OLTP_PUB_ALL_Tables' is not yet available.
Post #774347
ps.
ps.
Posted Thursday, August 20, 2009 9:48 AM
SSCrazy
Group: General Forum Members
Last Login: Thursday, May 02, 2013 2:32 AM
Points: 2,236,
Visits: 3,620
MAK (8/20/2009)
How to run the log reader
If you're using pull subscription, the log reader job would be created on the subscriber, if you've setup push subscription, the job will be created on the distributor.
expand sql server agent>expand jobs> the job names with two numbers seperated by a hyphen would be your log reader agent job.
Pradeep Singh
Post #774348
MAK-1128556
MAK-1128556
Posted Thursday, August 20, 2009 10:01 AM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Wednesday, September 01, 2010 7:44 AM
Points: 176,
Visits: 290
Hi Thansk for help,
I am still getting following error
I am getting following error, when I pick up the option initinalize
The initial snapshot for publication 'OLTP_PUB_ALL_Tables' is not yet available.
Post #774358
« Prev Topic
|
Next Topic »
12 posts, Page 1 of 2
1
2
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
