Hi, I'm trying to get log shipping to work with a distribution server used in transactional replication. Shipping the distribution database is no problem but the issue is in failover getting the distributor to talk to the publisher. The replication monitor won't display anything - distribution or log reader agents. I could only get this all to work by renaming the standby server to that of the primary server, and then restoring both the master and msdb databases. Has anyone done this and know all the steps necessary to get this to work. I can't even find a white paper on the net with the info I want. I'm not sure if it is necessary to do all that I am doing. I also think there could be a problem with a role change - but I haven't tested that yet.Any help appreciated.
This looks like a hard one for many as I've posted many places with no response.cheers,Brent.
What exactly are you looking at ? Are you trying to setup replication and log shipping on the same machines for the same databases ? Is so, why do you want both the options.
Please provide with more info. to help you better.
What is the size of the database you want to duplicate ? What is the purpose of creating a duplicate ? What is the load on your OLTP server ? Is the secondary server of the same config. of your original server ?