If things go wrong with snapshot.

From: jostein.solstad@xxxxxxxxx
Date: 17 Jan 2007 04:02:17 -0800

Hi

I have a script that is run before the snapshot that disables a set
with primary and foreign keys on the subscriber. This is to be able to
delete some data before i reinsert new data. I also have a script that
runs after the snapshot that restores these keys. But, if something
goes wrong with the transfer of data, the last script is not run and i
end up having a subscriber with a database with missing keys. Is there
a way to make sure that the last script is run even tough a task fails?

Regards
J

.

Follow-Ups:
- Re: If things go wrong with snapshot.
  - From: Hilary Cotter
- Re: If things go wrong with snapshot.
  - From: Paul Ibison

Prev by Date: Re: problem in creation database mirroring
Next by Date: wrong server name
Previous by thread: Transaction Replication
Next by thread: Re: If things go wrong with snapshot.
Index(es):
- Date
- Thread

Relevant Pages

Re: If things go wrong with snapshot.
... But, as far as i understand it, the script added with sp_addscriptexec ... on failure will run the next time the agent runs, ... This means that the subscriber db can me without keys for 24 hours? ... Another option would be something in place on the subscriber which would ...
(microsoft.public.sqlserver.replication)
Re: If things go wrong with snapshot.
... You could run sp_addscriptexec to run the script on all subscribers deployed ... Another option would be something in place on the subscriber which would ... I have a script that is run before the snapshot that disables a set ... with primary and foreign keys on the subscriber. ...
(microsoft.public.sqlserver.replication)
Re: Primary Key and Idenity check apply to subscriber db for dis
... snapshot tab, ... Then you can script out the tables on the publisher with the contrainsts you ... script on the subscriber, then deploy your snapshot. ... > currently have a script that will apply the primary key to ...
(microsoft.public.sqlserver.replication)
Re: Error number: 208
... I think i have found the problem, it is a view that has referenses to this ... The snapshot is trying to create a view that contains another view that not ... > When you script the view and test it on the subscriber, ... > the same as the script you have tested separately. ...
(microsoft.public.sqlserver.replication)
Re: adds articles to a publication
... I can't re-initialize the entire publication, because the snapshot is ... Publication other script to execute in subscriber after run the ...
(microsoft.public.sqlserver.replication)