Hi all,
I have been running replication of our data out to our webserver for some time now, last week it suddenly stopped refreshing with the following error
initial snapshot for publication 'mypub' is not ready
I couldn't find a fix for the problem, including reinitialising the data, so created the data replication from scratch and created a subscription.
In doing so it took down my site for 2 hours whilst it ran, then i had to recreate all of the permissions for the tables so that the website can access the data (read only)
This initially fixed the problem.
I have just looked into my replication and sometime between 9:30 and 11 yesterday it stopped, nothing significantly our of the ordinary in log files.
Any ideas on how to resolve without having to recreate the subscription (taking me down for a few hours!!)
Thank you
daveJam
it works on my machine, so technically i win!
I have been running replication of our data out to our webserver for some time now, last week it suddenly stopped refreshing with the following error
initial snapshot for publication 'mypub' is not ready
I couldn't find a fix for the problem, including reinitialising the data, so created the data replication from scratch and created a subscription.
In doing so it took down my site for 2 hours whilst it ran, then i had to recreate all of the permissions for the tables so that the website can access the data (read only)
This initially fixed the problem.
I have just looked into my replication and sometime between 9:30 and 11 yesterday it stopped, nothing significantly our of the ordinary in log files.
Any ideas on how to resolve without having to recreate the subscription (taking me down for a few hours!!)
Thank you
daveJam
it works on my machine, so technically i win!