SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Achieving Server Redundancy at Remote Offices


Achieving Server Redundancy at Remote Offices

Author
Message
Mark F. Cook
Mark F. Cook
SSC-Enthusiastic
SSC-Enthusiastic (158 reputation)SSC-Enthusiastic (158 reputation)SSC-Enthusiastic (158 reputation)SSC-Enthusiastic (158 reputation)SSC-Enthusiastic (158 reputation)SSC-Enthusiastic (158 reputation)SSC-Enthusiastic (158 reputation)SSC-Enthusiastic (158 reputation)

Group: General Forum Members
Points: 158 Visits: 61
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/mcook/achievingserverredundancyatremoteoffices.asp



Robert Sterbal
Robert Sterbal
SSC-Enthusiastic
SSC-Enthusiastic (127 reputation)SSC-Enthusiastic (127 reputation)SSC-Enthusiastic (127 reputation)SSC-Enthusiastic (127 reputation)SSC-Enthusiastic (127 reputation)SSC-Enthusiastic (127 reputation)SSC-Enthusiastic (127 reputation)SSC-Enthusiastic (127 reputation)

Group: General Forum Members
Points: 127 Visits: 1

I'm not sure I follow these IP addresses:

Production Server: Name : PROD1 IP : XXX.XX.XX.223

Secondary Server: Name : LOGSHIP1 IP : XXX.XX.XX.224

We create an alias like this:

Alias : Name : PROD1V IP : XXX.XX.XX.223

shouldn't there be 3 total?


Mark F. Cook
Mark F. Cook
SSC-Enthusiastic
SSC-Enthusiastic (158 reputation)SSC-Enthusiastic (158 reputation)SSC-Enthusiastic (158 reputation)SSC-Enthusiastic (158 reputation)SSC-Enthusiastic (158 reputation)SSC-Enthusiastic (158 reputation)SSC-Enthusiastic (158 reputation)SSC-Enthusiastic (158 reputation)

Group: General Forum Members
Points: 158 Visits: 61
It depends. sounds like a microsoft answer doesn't it. But seriously, if you include the unused IP address the failed production server gets changed to then yes - 3 IP addresses will be needed. If you're only talking about normal production operation, then you only need two - one for the alias and the production server and another for the log shipping server.



Tim Chapman-218780
Tim Chapman-218780
SSC Veteran
SSC Veteran (245 reputation)SSC Veteran (245 reputation)SSC Veteran (245 reputation)SSC Veteran (245 reputation)SSC Veteran (245 reputation)SSC Veteran (245 reputation)SSC Veteran (245 reputation)SSC Veteran (245 reputation)

Group: General Forum Members
Points: 245 Visits: 115
Great article. - Tim Chapman
SQLZ
SQLZ
SSCommitted
SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)

Group: General Forum Members
Points: 1714 Visits: 940
Good article.

By the way, it sounds like you've got a couple of unused licenses.

You do not need to buy a sql server or windows server license for the passive server - either in log shipping or clustering. Unless of course you're using the SQL Server for other, non-passive, purposes.

Taken from Microsoft's licensing white paper:

"When doing failover support, a server is designated as the passive server. The purpose of the passive server is to absorb the data and information held in another server that fails. A passive server does not need a license, provided that the number of processors in the passive server is equal or less than those of the active server. The passive server can take the duties of the active server for 30 days. Afterward, it must be licensed accordingly."

Karl
source control for SQL Server
Mark F. Cook
Mark F. Cook
SSC-Enthusiastic
SSC-Enthusiastic (158 reputation)SSC-Enthusiastic (158 reputation)SSC-Enthusiastic (158 reputation)SSC-Enthusiastic (158 reputation)SSC-Enthusiastic (158 reputation)SSC-Enthusiastic (158 reputation)SSC-Enthusiastic (158 reputation)SSC-Enthusiastic (158 reputation)

Group: General Forum Members
Points: 158 Visits: 61
thanks for the information. I knew only one license was needed when using Microsoft Log Shipping included in Enterprise edition, but thought that anything outside that required additional licenses. Again, thanks...



Lisa Slater Nicholls
Lisa Slater Nicholls
Mr or Mrs. 500
Mr or Mrs. 500 (563 reputation)Mr or Mrs. 500 (563 reputation)Mr or Mrs. 500 (563 reputation)Mr or Mrs. 500 (563 reputation)Mr or Mrs. 500 (563 reputation)Mr or Mrs. 500 (563 reputation)Mr or Mrs. 500 (563 reputation)Mr or Mrs. 500 (563 reputation)

Group: General Forum Members
Points: 563 Visits: 618

You're probably better off maintaining the second license if you go ahead with your strategy of having the secondary work for multiple primaries. It might be in use frequently, albeit for short periods each time.

But... if you have multiple primaries for the secondary, I don't think your switch of the secondary's IP address and alias is going to work as well. What if two primaries fail at once? It's unlikely, I'm sure, and this article is a good treatment of a reasonable, low-cost and responsible method. Thanks!


K. Brian Kelley
K. Brian Kelley
Keeper of the Duck
Keeper of the Duck (13K reputation)

Group: Moderators
Points: 13804 Visits: 1917
How are you handling network outages?

K. Brian Kelley
@‌kbriankelley
Mark F. Cook
Mark F. Cook
SSC-Enthusiastic
SSC-Enthusiastic (158 reputation)SSC-Enthusiastic (158 reputation)SSC-Enthusiastic (158 reputation)SSC-Enthusiastic (158 reputation)SSC-Enthusiastic (158 reputation)SSC-Enthusiastic (158 reputation)SSC-Enthusiastic (158 reputation)SSC-Enthusiastic (158 reputation)

Group: General Forum Members
Points: 158 Visits: 61
thanks for the comments. you're correct, the setup can accommodate only a single failure in the multiple primary-single secondary situation, but our assessment was that you can go pretty far down the proverbial rabbit hole in trying to achieve redundancy, and that this was as you said a reasonable, low-cost solution....



Mark F. Cook
Mark F. Cook
SSC-Enthusiastic
SSC-Enthusiastic (158 reputation)SSC-Enthusiastic (158 reputation)SSC-Enthusiastic (158 reputation)SSC-Enthusiastic (158 reputation)SSC-Enthusiastic (158 reputation)SSC-Enthusiastic (158 reputation)SSC-Enthusiastic (158 reputation)SSC-Enthusiastic (158 reputation)

Group: General Forum Members
Points: 158 Visits: 61
the two servers - primary and secondary are located next to each other on the local lan. In the event that there is a problem with the primary and we need to failover to the secondary ... and the wan link is down, there are procedures in place that a designated person at the facility can be guided through by a DBA....or did i miss your point entirely...



Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search