Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Microsoft SQL Server Cluster Vs Standby Server


Microsoft SQL Server Cluster Vs Standby Server

Author
Message
vsrinivasan
vsrinivasan
Valued Member
Valued Member (51 reputation)Valued Member (51 reputation)Valued Member (51 reputation)Valued Member (51 reputation)Valued Member (51 reputation)Valued Member (51 reputation)Valued Member (51 reputation)Valued Member (51 reputation)

Group: General Forum Members
Points: 51 Visits: 1
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/bahmed/microsoftsqlserverclustervsstandbyserver.asp



JL Dominguez-246595
JL Dominguez-246595
Grasshopper
Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)

Group: General Forum Members
Points: 15 Visits: 59
You didn't mention Transactional Replication as a way to keep a warm standby server. It would be interesting to read about pros/cons from the field regarding this method.
Mike Metcalf
Mike  Metcalf
Say Hey Kid
Say Hey Kid (711 reputation)Say Hey Kid (711 reputation)Say Hey Kid (711 reputation)Say Hey Kid (711 reputation)Say Hey Kid (711 reputation)Say Hey Kid (711 reputation)Say Hey Kid (711 reputation)Say Hey Kid (711 reputation)

Group: General Forum Members
Points: 711 Visits: 53

We use clustering in production and log ship to a secondary site to maintain a standby server, this gives us the best of both worlds in my opinion.

To be honest I don't like the idea for transactional replication for standby servers, not when there are other options available, but that's only my opinion and i'm sure that others will disagree.


Ray M
Ray M
SSCommitted
SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)

Group: General Forum Members
Points: 1839 Visits: 1076

Nice, an advertisment article, the link at the bottom doesn't even work.


bruce sherwood-232207
bruce sherwood-232207
Grasshopper
Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)

Group: General Forum Members
Points: 21 Visits: 28
Yes, indeed, an advertisement and not a lot more.

For similar solutions:

Legato (now EMC) had Co-Standby Server, which has now evolved into Autostart. I have used Co-Standby since its days with Vinca and then into Legato. It does disk level bit replication, and allows a fail over cluster to exist without the need of shared storage. Their own management software monitors for server failure and automatically takes over much the same way Microsoft clustering does. If you can't afford Enterprise Edition, then Legato is a far easier purchase. Downside: Both servers have to exist in the same datacenter and will have a dedicated link between them for the disk replication.
- Note: this product is NOT limited to just SQL Server. You can use it for a lot of things. It is basically failover clustering for virtually any app/service.

NSI Doubletake: While not a clustering solution, it does let you implement 'block' level file replication. What ever gets written to disk for a monitored file also goes into the queue to go to the destination server. The cool aspect to this as it can watch all file I/O on your SQL databases and capture that and send it over a slow link like a WAN to remote server. It also is not specifically tied to SQL server. But, as a downside, recovery on the far side (where ever that is for you) will be a manual task. NSI claims there is some scripting ability you can implement to make the process almost automatic, but until I actually use the product, I am not so trusting yet.
Note: We (my company) are considering this to keep several of our database servers in our corporate datacenter replicated to standby servers locate on another continent.
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