Re: How to auto generate a snapshot for an existing subscriber

This is a hard one to diagnose. Can you try to bump up the permissions
of the publisherlogin, distributorlogin and make sure that the
publisherlogin is in the dbo_role on the publisher and in the PAL.

It also needs rights to read the snapshot share, and needs permission
to read and list the files and folders on the directory underlying the
snapshot share and all subdirectories of it.

On Feb 2, 5:47 am, JDS <ad...@xxxxxxxxxxxxxx> wrote:
Thanks for the reply. Maybe I am looking at the wrong thing then.

As it was, when the client with an expired subscription tried to
synchronise (using RMO from my app) it got the message "Snapshot for
the publication has become obsolete" and the synchronisation attempt
stopped. This is obviously no good for the user of the client machine.
I need the synchronisation to automatically use the latest available
snapshot. (When I manually recreated a snapshot the synchronisation
worked fine).

However, rather than looking at the subscription/publication settings
maybe I need to be looking at the agent to make sure it is
automatically regenerating a snapshot. Any suggestions greatly
appreciated but I will see if I can fix it.

.

Relevant Pages

  • Re: The operation completed successfully (Exception from HRESULT: 0x80
    ... I take it the snapshot share is local and precreated? ... apply the share permissions, and then re-run the creation applet? ... Director of Text Mining and Database Strategy ... I really do not understand why of this error, because the process set the ...
    (microsoft.public.sqlserver.replication)
  • Re: Table permissions being removed on transactional replication
    ... Table permissions are not replicated - you will need to ... snapshot is applied via a post snapshot command. ... Looking for a SQL Server replication book? ... > re-apply the permissions at the subscriber every time the distributor ...
    (microsoft.public.sqlserver.replication)
  • Re: How to auto generate a snapshot for an existing subscriber
    ... when the client with an expired subscription tried to ... synchronise it got the message "Snapshot for ... This is obviously no good for the user of the client machine. ... I need the synchronisation to automatically use the latest available ...
    (microsoft.public.sqlserver.replication)
  • Pre snapshot to apply permissions
    ... I would like to apply the objects' permissions after to apply an snapshot. ... To do it, I need a script file, with the grant commands to apply that ... command to generate and save the script file with these permissions?. ...
    (microsoft.public.sqlserver.replication)
  • Re: Registry problem
    ... and I don't know which permissions are supposed to be on there ... Use the System Restore tool since it took a snapshot of the registry as ...
    (microsoft.public.windowsxp.general)
Loading