Full error I am getting: a snapshot was not generated because no
subscriptions needed initialization
Scenario: I run the New Publication Wizard to create and add a
Transactional Publication with Updateable Subscriptions to my SQL Server. I
choose the script option at the end of the Wizard and save the script that
the Wizard generates. The publication is created fine and an initial snapshot
is created for the publication. Obviously I have no Subscribers to the
Publication yet...I just created it, but the Snapshot is created without
issue. That's cool, that's what is wanted.
The Problem: Now, if the Publication is Deleted from the SQL
Server(successfully...no errors & no funkiness), and I then run the script
that the Wizard created for me, the initial Snapshot does not get created as
it did thru the Wizard, but everything else involving the script is fine. I
get the aforementioned error at the top of this message. This sucks. Isn't
this script supposed to do exactly what I just did in the Wizard? I want the
Snapshot created in the same fashion as it was when the Wizard did it. What
is going on that is different between the Wizard and the script that the
Wizard created (and something must be different)? I did not alter the
script in any way from what the Wizard gave me. Is there some trick or
workaround to get this behavior? Am I missing the boat on something here?
Thanks.
Chris Jones
Application Development Consultant
Chris,
Check to see if the sp_addpublication in the generated script has the
parameter @.immediate_sync set to 'true'.
When creating the publication if the immediate sync property is set to
'true', a snapshot for the publication will be generated everytime the
snapshot agent runs even if the publication doesn't have any
subscriptions....else if @.immediate_sync is set to 'false', the snapshot
will not be generated because the publication does not have any subscriptions
yet.
HTH
Emaniel
"Chris" wrote:
> Full error I am getting: a snapshot was not generated because no
> subscriptions needed initialization
> Scenario: I run the New Publication Wizard to create and add a
> Transactional Publication with Updateable Subscriptions to my SQL Server. I
> choose the script option at the end of the Wizard and save the script that
> the Wizard generates. The publication is created fine and an initial snapshot
> is created for the publication. Obviously I have no Subscribers to the
> Publication yet...I just created it, but the Snapshot is created without
> issue. That's cool, that's what is wanted.
> The Problem: Now, if the Publication is Deleted from the SQL
> Server(successfully...no errors & no funkiness), and I then run the script
> that the Wizard created for me, the initial Snapshot does not get created as
> it did thru the Wizard, but everything else involving the script is fine. I
> get the aforementioned error at the top of this message. This sucks. Isn't
> this script supposed to do exactly what I just did in the Wizard? I want the
> Snapshot created in the same fashion as it was when the Wizard did it. What
> is going on that is different between the Wizard and the script that the
> Wizard created (and something must be different)? I did not alter the
> script in any way from what the Wizard gave me. Is there some trick or
> workaround to get this behavior? Am I missing the boat on something here?
> --
> Thanks.
> Chris Jones
> Application Development Consultant
Showing posts with label snapshot. Show all posts
Showing posts with label snapshot. Show all posts
Sunday, March 11, 2012
Saturday, February 11, 2012
A Guide to SQL Server Transactional and Snapshot Replication from Hilary Cotter
Hi all
Can tell me anyone, if the book
A Guide to SQL Server Transactional and Snapshot Replication from
Hilary Cotter, Publish Date June 15/2004
are available?
How and where can I order this book.
http://www.nwsu.com/0974973602.html
Thanks Thomas
It hasn't gone to print yet. It should be going to print early next month.
Then it will take about 25-35 days to print. I'll announce when you can
preorder the book here.
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html
"Thomas Hase" <tohas@.freenet.de> wrote in message
news:41088b9f.6019281@.news.t-online.de...
> Hi all
> Can tell me anyone, if the book
> A Guide to SQL Server Transactional and Snapshot Replication from
> Hilary Cotter, Publish Date June 15/2004
> are available?
> How and where can I order this book.
> http://www.nwsu.com/0974973602.html
> Thanks Thomas
|||Hi Hillary,
thanks for fast reply. Currently I am working on an bidirectional
replication migration from 6.5 to 2k.
Additional information would be nice for me, but not absolute needed.
But 30 days are to late for me.
Is it possible to get an (beta) online issue?
Greetings from Germany
On Wed, 28 Jul 2004 08:12:58 -0400, "Hilary Cotter" <hilaryk@.att.net>
wrote:
>It hasn't gone to print yet. It should be going to print early next month.
>Then it will take about 25-35 days to print. I'll announce when you can
>preorder the book here.
Can tell me anyone, if the book
A Guide to SQL Server Transactional and Snapshot Replication from
Hilary Cotter, Publish Date June 15/2004
are available?
How and where can I order this book.
http://www.nwsu.com/0974973602.html
Thanks Thomas
It hasn't gone to print yet. It should be going to print early next month.
Then it will take about 25-35 days to print. I'll announce when you can
preorder the book here.
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html
"Thomas Hase" <tohas@.freenet.de> wrote in message
news:41088b9f.6019281@.news.t-online.de...
> Hi all
> Can tell me anyone, if the book
> A Guide to SQL Server Transactional and Snapshot Replication from
> Hilary Cotter, Publish Date June 15/2004
> are available?
> How and where can I order this book.
> http://www.nwsu.com/0974973602.html
> Thanks Thomas
|||Hi Hillary,
thanks for fast reply. Currently I am working on an bidirectional
replication migration from 6.5 to 2k.
Additional information would be nice for me, but not absolute needed.
But 30 days are to late for me.
Is it possible to get an (beta) online issue?
Greetings from Germany
On Wed, 28 Jul 2004 08:12:58 -0400, "Hilary Cotter" <hilaryk@.att.net>
wrote:
>It hasn't gone to print yet. It should be going to print early next month.
>Then it will take about 25-35 days to print. I'll announce when you can
>preorder the book here.
A Guide to SQL Server Transactional and Snapshot Replication
Is it ready?
Last I heard it was at the printer, with a street date mid to late November.
It was stuck in typesetting for several months.
I'll let you know when I hear more.
"Thomas Hase" <tohas@.freenet.de> wrote in message
news:4171e9f5.245848500@.news.t-online.de...
> Is it ready?
Last I heard it was at the printer, with a street date mid to late November.
It was stuck in typesetting for several months.
I'll let you know when I hear more.
"Thomas Hase" <tohas@.freenet.de> wrote in message
news:4171e9f5.245848500@.news.t-online.de...
> Is it ready?
Labels:
database,
guide,
microsoft,
mysql,
oracle,
replication,
server,
snapshot,
sql,
transactional
Subscribe to:
Posts (Atom)