July 1, 2003 at 3:10 pm
When running the create publication wizard, I get:
"Error 14294 - Supply either @Job_id or @Job_Name to identify the job"
I had pubs & subs set up, but things were erroring, so I tried deleting everything and wanted to start from scratch, but the last step in the wizard gets me stuck.
Is it ok to clear the tables in the Distribution database that have info from earlier attempts at setting things up ?
Is there a way to delete the distribution database & really start from scratch ?
July 1, 2003 at 4:22 pm
First about the error message. I've seen this one once before at a customer site and it turned out that they had been messing around with their master database.I don't say you did, but you might wanna check. What they actually did was copying the master database from an old server over the master DB of the new server, without realizing that they were on different service packs. Especially SP3 contains a lot of fixes and changes (like new SP's) for merge replication. After trying to fix it manually for almost a day I told them to reinstall the SQL Server
quote:
Is it ok to clear the tables in the Distribution database that have info from earlier attempts at setting things up ?
The short answer would be yes, but it's not advisable.
quote:
Is there a way to delete the distribution database & really start from scratch ?
Again yes, and it's save. Just run the Disable publishing wizard and everything will get cleaned up.
Hope this helps
Markus
[font="Verdana"]Markus Bohse[/font]
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply