log shipping


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".

more ▼

asked Oct 12 '12 at 07:11 PM in Default

sql2008 gravatar image

90 1 1 1

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".
Oct 15 '12 at 01:51 PM sql2008
(comments are locked)
10|1200 characters needed characters left

3 answers: sort voted first
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.
more ▼

answered Oct 12 '12 at 07:20 PM

Tim gravatar image

35.5k 32 40 138

thank you
Oct 12 '12 at 07:21 PM sql2008
(comments are locked)
10|1200 characters needed characters left

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

more ▼

answered Oct 13 '12 at 10:25 AM

Fatherjack gravatar image

Fatherjack ♦♦
41.2k 72 77 107

(comments are locked)
10|1200 characters needed characters left
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?
more ▼

answered Oct 15 '12 at 05:43 AM

ramesh 1 gravatar image

ramesh 1
2.1k 59 67 69

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Oct 12 '12 at 07:11 PM

Seen: 644 times

Last Updated: Oct 15 '12 at 01:58 PM