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.
You can use the log files to maintain as many standby databases/servers as you need - http://msdn.microsoft.com/en-us/library/bb895393.aspx
answered May 19, 2011 at 03:20 AM
Yes you can log ship from one source server to multiple target servers.
(emphasis mine) : http://msdn.microsoft.com/en-us/library/ms187103.aspx
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.
answered May 19, 2011 at 05:58 AM