December 13, 2006 at 8:35 am
I have a Replication job which runs great on SQL Srvr 2K, but it fails on 2005 with the following message:
"The step is improperly defined and so could not be run. The step failed."
The step I am trying to run is:
-Publisher [TESTSERVER] -PublisherDB [testdb] -Distributor [TESTSERVER] -Publication TestingSnapshot -DistributorSecurityMode 1
The Type is "Replication Snapshot"
Run as : "SQL Agent Service Account"
Any input is appreciated.
Thanks
Anik
December 14, 2006 at 2:47 pm
I don't see the -ReplicationType flag in your command. Perhaps it is optional in SQL 2000 but required in 2005. I'm guessing on this one. Try adding the flag to the command: -ReplicationType 1
December 14, 2006 at 3:10 pm
Now the step is:
-Publisher [TESTSERVER] -PublisherDB [testdb] -Distributor [TESTSERVER] -Publication TestingSnapshot -DistributorSecurityMode 1 -ReplicationType 1
Still fails with the same message! I tried on two different installs - same message.
Is there a sample setup script somewhere that I can use as a template? May be I am setting up the Publisher incorrectly?
I took the exact same script that runs on 2K and copied it to 2K5 for testing - only changed the server names.
March 16, 2010 at 5:24 pm
Have a look at msdb..sysjobsteps.
The server column of the step in question is probably NULL. Change it to whatever your target server is and it should work.
March 18, 2010 at 1:27 pm
i would script out the publication and run the script on the distributor to create the publication from scratch. or create it from scratch
August 6, 2010 at 5:34 pm
By adding server and database_name in sysjobsteps the replication step started to work properly. Thanks for the help.
Branko
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply