question

sql2008 avatar image
sql2008 asked

log shipping

hi, In a log shipping environment can i have one primary server and two secondary server? but it would be like the Primary Server "A" restoring log files to the secondary server "B" and then again the secondary server "B" restoring the same log file to another secondary server "C". thanks
logshippingprimarysecondary
1 comment
10 |1200 characters needed characters left characters exceeded

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

yes i can have one primary and many secondary server but my senerio is one primary server and two secondary server but the layout should be like Server "A" (Primary) -> Server "B" (Secondary) and Server "B" connected to Server "C" (another secondary server). So in short the primary server will be updating the log files to the secondary server "B" and then server "B" will be updating Server "C" but what you are saying i believe is both the secondary server's (B,C) connected to the primary server "A".
0 Likes 0 ·
Tim avatar image
Tim answered
You would be able to log ship from A to B and A to C but not A to B and B to C. The the latter case the database is still in recovery.
1 comment
10 |1200 characters needed characters left characters exceeded

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

thank you
0 Likes 0 ·
Fatherjack avatar image
Fatherjack answered
In a Log Shipping scenario you can take the backup files and apply them to as many secondary servers as you wish, you simply copy the file to the secondary servers and restore it. Research it all here : http://msdn.microsoft.com/en-us/library/ms187103.aspx To answer your latest comment regarding the topology of having one primary and two secondary. Having a 'cascade' of backups would not be recommended as this could lead to a lot of confusion and headaches when you need to restore/backup. You could use the logfile location for the Server C restore as a location on Server B so ... ServerA Backup of local database + copies backup file to ServerB ServerB restores logfile to local database ServerC restores logfiles from share on ServerB to database on ServerC
10 |1200 characters needed characters left characters exceeded

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

ramesh 1 avatar image
ramesh 1 answered
yes you can have 1 primary and many standby servers in Log shipping ,but make sure that copy job should not colide at the same time?
10 |1200 characters needed characters left characters exceeded

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

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.