Hi, I have already setup Database Log Shipping for one of my server. Server A to Server B (Server B is in Simple Recovery Mode). But I want to Log Ship again to CoLocation Site. Is that okay to setup again from Server A to Server C? Do you think it will mess up the LSN?? **I can't Log Ship from Server B to Server C because DB is in Simple Recover Mode. Thanks
Yes you can log ship from one source server to multiple target servers. From [MSDN/BOL] > Log shipping allows you to automatically send transaction log backups from a primary database on a primary server instance to **one or more** secondary databases on separate secondary server instances. (emphasis mine) :
Hi Kev and John... I setup Server A to Server C last 2 hours ago and now I am getting error on Server C and also error on Server B as well. Error Message was saying 'It can't find earlier LSN file...' I am using Red Gate Log Shiping.