question

Leo avatar image
Leo asked

Database Logshipping

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
sql-server-2008log-shippingred-gate
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

3 Answers

·
Fatherjack avatar image
Fatherjack answered
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
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Kev Riley avatar image
Kev Riley answered
Yes you can log ship from one source server to multiple target servers. From [MSDN/BOL][1] > 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) [1]: http://msdn.microsoft.com/en-us/library/ms187103.aspx
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Leo avatar image
Leo answered
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.
4 comments
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Fatherjack avatar image Fatherjack ♦♦ commented ·
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
1 Like 1 ·
Kev Riley avatar image Kev Riley ♦♦ commented ·
Is this any use
1 Like 1 ·
Leo avatar image Leo commented ·
Hi John, I will give them a call. Thanks
0 Likes 0 ·
Leo avatar image Leo commented ·
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
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.