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
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".
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
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?
11 People are following this question.
