Wednesday, March 28, 2012

Replication Error

I am using Replication wizard and created Publisher with
name "Services3 and Subscriber is HOffice with
Subscription database is GinFactory1 and using Windows
authentication Mode. Subscription is Push Subscription.
It create sanapshot and also transfer data in GinFactory1
as soon as Wizard has been completed. But when i try to
synchronize Subscription using option start sunchronizing
it returns error "Publication is invalid" .What can be
reason of it?Please give me detail description if u have.
Thanks in advance
Normally the publication is invalid error message means that your snapshot
files are too old. Can you regenerate your snapshot (right click on your
snapshot agent and select start agent), and then restart your distribution
agent?
You may get a message telling you the no snapshot was generated as
subscriptions needed reinitialization.
If you get this message right click on your publication, publication
properties, go to the subscribers tab, located your subscriber and click
reinitialize. Then restart your snapshot agent.
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html
"Saima" <ucoxk@.yahoo.com> wrote in message
news:3fa701c47308$49893d40$a601280a@.phx.gbl...
> I am using Replication wizard and created Publisher with
> name "Services3 and Subscriber is HOffice with
> Subscription database is GinFactory1 and using Windows
> authentication Mode. Subscription is Push Subscription.
> It create sanapshot and also transfer data in GinFactory1
> as soon as Wizard has been completed. But when i try to
> synchronize Subscription using option start sunchronizing
> it returns error "Publication is invalid" .What can be
> reason of it?Please give me detail description if u have.
> Thanks in advance
|||It is not too old . i just do it after 5 minutes
>--Original Message--
>Normally the publication is invalid error message means
that your snapshot
>files are too old. Can you regenerate your snapshot
(right click on your
>snapshot agent and select start agent), and then restart
your distribution
>agent?
>You may get a message telling you the no snapshot was
generated as
>subscriptions needed reinitialization.
>If you get this message right click on your publication,
publication
>properties, go to the subscribers tab, located your
subscriber and click[vbcol=seagreen]
>reinitialize. Then restart your snapshot agent.
>--
>Hilary Cotter
>Looking for a book on SQL Server replication?
>http://www.nwsu.com/0974973602.html
>
>"Saima" <ucoxk@.yahoo.com> wrote in message
>news:3fa701c47308$49893d40$a601280a@.phx.gbl...
with[vbcol=seagreen]
GinFactory1[vbcol=seagreen]
sunchronizing[vbcol=seagreen]
have.
>
>.
>
|||can you script out your publication and post it here?
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html
"Saima" <ucoxk@.yahoo.com> wrote in message
news:44de01c4733d$c1287570$a601280a@.phx.gbl...[vbcol=seagreen]
> It is not too old . i just do it after 5 minutes
> that your snapshot
> (right click on your
> your distribution
> generated as
> publication
> subscriber and click
> with
> GinFactory1
> sunchronizing
> have.

No comments:

Post a Comment