January 19, 2012 at 4:57 am
Adding new articles (new tables) to replicate.
This is the process I followed which worked the last time I used it.
•Publisher (REPL_ISIS_APPS) --> Properties
•Articles page
•Click off ‘Show only checked articles in the list’
•Click on extra tables to add
•Click on OK
•Publisher (REPL_ISIS_APPS) --> View Snapshot Agent Status
•On View Snapshot Agent Status page click on Start
On the last step an error message is displayed.
Error message reads :-
BEGIN
The Agent could not be started
An exception occurred while executing a transaction-SQL statement or batch.
(Microsoft.SqlServer.ConnectionInfo)
Could not find regular snapshot job for specified publication 'REPL_ISIS_APPS'.
Supply either @job_id or @job_name to identify the job.
Changed database context to 'ISIS'. (Microsoft SQL Server, Error 20678)
END
Q1) Does anyone know what caused this error?
Q2) Is there anyway to fix this error?
Q3) Would the option 'Reinitialize All Subscriptions' (with Use a new snapshot and generate the new snapshot now) correct this issue or make the issue worse?
At present all tables replicate (except the new ones I want to replicate) fine. What I don't want is to be in a situation where things stop replicating all together.
I have tried searching the internet for resolutions to this but I cannot seem to find this exact scenario.
Can you help?
Regards,
Richard.
January 26, 2012 at 3:22 am
ANSWER:
After help from another forum post the resolution to this is to run the snapshot job directly manually.
What is broken here is the link between the Snapshot Agent popup screen START button and the job.
January 26, 2012 at 5:37 am
:hehe:
Can you do a refresh and start it again. It is possible that the GUI has cached an old job.
Try to start the snapshot agent from the jobs folder.
If you get this message you will likely need to recreate your publication and subscription and try again.
January 26, 2012 at 7:40 am
Not sure if running the job directly is the solution for the given error but if you want to avoid a new snapshot for all the articles then run the snapshot job instead of using the replication monitor to take a new snapshot for the new articles.
If you try to use the replication monitor to take a new snapshot it will do that for all the articles.
http://saveadba.blogspot.com/2011/08/adding-new-article-without-generating.html
Blog
http://saveadba.blogspot.com/
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply