|
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
(comments are locked)
|
|
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
(comments are locked)
|
|
Yes you can log ship from one source server to multiple target servers. From [MSDN/BOL][1]
(emphasis mine) [1]: http://msdn.microsoft.com/en-us/library/ms187103.aspx
(comments are locked)
|
|
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. Have you followed the help that comes with SQLBackup? Have you got a support contract with RedGate? If so then I would suggest that you contact them as they have a brilliant support desk who will work with you on the problem
May 19 '11 at 06:06 AM
Fatherjack ♦♦
Is this any use http://www.red-gate.com/supportcenter/Content?p=SQL%20Backup&c=knowledgebase%5CSQL_Backup%5CKB200906000409.htm
May 19 '11 at 06:10 AM
Kev Riley ♦♦
Hi John, I will give them a call. Thanks
May 19 '11 at 06:18 AM
Leo
Sorted. They suggested me to Log ship from Server A to B Only, then added extra script to restore the Log for Server C same as Server B. Now works. Thanks
May 19 '11 at 09:03 AM
Leo
(comments are locked)
|
