Hi,
We have (had) 3 servers on our network all happily working together in replication ...
Server 1
1 database published
Server 2
distribution server
Server 3
1 database subscribed.
on friday night it would appear that we had a power failure that KO'd Server 2. We are unable to rebuild the server so have brought a new server into the equation - Server4. this server is now in the domain, set up with SQL2000 and is a distributor. I have register the other servers and have set server 1 as a publisher.
however, i cannot get replication restarted. If i run the sql scripts from the working publication there are loads of errors saying that the publication already exists and that the distribnutor cannot be reached.
what step am i missing that will get this back together?
any help much appreciated.