SQL Server Clustering - SQL Server Mirroring solution

Have you ever felt the need to have redundancy or maybe even a failover solution for your SQL Server database?

If yes, perhaps you should look for a SQL Server Clustering or a SQL Server Mirroring solution. I have come across many users who need a disaster recovery solution for their web application. One of those users has a system which runs on Microsoft ASP.NET with a MS SQL back-end. He was suggested the possibility of MS-SQL mirroring by a web hosting provider. According to the web host this solution is a very good for applications which require very small changes to the application itself and require the minimum amount of hardware and additional software.

These servers also share a common Virtual IP address for the SQL server and the IP will be assigned to the node that is running the SQL service and the same IP should be used in the scripts to connect the SQL server.

These servers will also use the internal vLAN to check the availability of each not in the cluster with the Heart Beat Method.

A quick overview of the suggested SQL Clustering service is as follows:

- You require 2 dedicated servers, a primary database server and a secondary database server with a SAN device (Storage Area Network).

- The setup require SQL Server Enterprise Edition for the primary and secondary database servers.

- Cluster Service acts as a back-end solution which provides high availability for applications such as databases. Both servers in the cluster remain in constant communication.

- Both SQL Servers share a common storage space on a SAN device attached using iSCSI cards. SAN stores the SQL server files as well as the databases.

- The network drive on SAN device is available on the primary database server only. If the primary database server goes down for any reason the secondary server in the cluster will take over the SQL service along with the network drive causing no down time. This process is known as ‘failover’

- In this cluster, the secondary server remains inactive as an SQL server unless it is required to act as a primary database server.

- When both the servers are connected in a cluster together, they appear as a single computer to clients.

It all depends on how important the availability of your website / application is. If you require absolutely no downtime, then this kind of mirroring solution that would be suitable for your needs.

You can also read upon more information about MS SQL clustering and mirroring at http://www.eukhost.com/load-balanced-servers.php

Ryan Watson Sales Manager http://www.eukhost.com

Comment on "SQL Server Clustering - SQL Server Mirroring solution"

Home Site Map Advertise For Sale Subscribe to our Monthly Email Newsletter	Not While the Surf's Up Press SQL Server Clustering - SQL Server Mirroring solution Have you ever felt the need to have redundancy or maybe even a failover solution for your SQL Server database? If yes, perhaps you should look for a SQL Server Clustering or a SQL Server Mirroring solution. I have come across many users who need a disaster recovery solution for their web application. One of those users has a system which runs on Microsoft ASP.NET with a MS SQL back-end. He was suggested the possibility of MS-SQL mirroring by a web hosting provider. According to the web host this solution is a very good for applications which require very small changes to the application itself and require the minimum amount of hardware and additional software. These servers also share a common Virtual IP address for the SQL server and the IP will be assigned to the node that is running the SQL service and the same IP should be used in the scripts to connect the SQL server. These servers will also use the internal vLAN to check the availability of each not in the cluster with the Heart Beat Method. A quick overview of the suggested SQL Clustering service is as follows: - You require 2 dedicated servers, a primary database server and a secondary database server with a SAN device (Storage Area Network). - The setup require SQL Server Enterprise Edition for the primary and secondary database servers. - Cluster Service acts as a back-end solution which provides high availability for applications such as databases. Both servers in the cluster remain in constant communication. - Both SQL Servers share a common storage space on a SAN device attached using iSCSI cards. SAN stores the SQL server files as well as the databases. - The network drive on SAN device is available on the primary database server only. If the primary database server goes down for any reason the secondary server in the cluster will take over the SQL service along with the network drive causing no down time. This process is known as ‘failover’ - In this cluster, the secondary server remains inactive as an SQL server unless it is required to act as a primary database server. - When both the servers are connected in a cluster together, they appear as a single computer to clients. It all depends on how important the availability of your website / application is. If you require absolutely no downtime, then this kind of mirroring solution that would be suitable for your needs. You can also read upon more information about MS SQL clustering and mirroring at http://www.eukhost.com/load-balanced-servers.php Ryan Watson Sales Manager http://www.eukhost.com Rate This Article: Comment on "SQL Server Clustering - SQL Server Mirroring solution" Your Name Your Comments Verification Code: 68E41 Enter Code: A Guide to SQL Server 2000 Transactional and Snapshot Replication This chapter focuses on installing replication on your SQL Server.Most users will only install replication on their SQL Server and then enable Subscribers.We’ll look at these two options and then look at how to set up your SQL Server to use a remote Distributor. After looking at these options, we’ll look at Replication Monitor, which is the central point for replication administration. In the process we’ll cover some of the more advanced options and settings. Following that, for those of you who are wizard adverse, we will look at the replication stored procedures that you can use to carry out the same things. TITLES A Guide to SQL Server 2000 Transactional and Snapshot Replication xSQL Software's RSS Reporter for SQL Server Makes Job Monitoring Easy xSQL Software releases an innovative new tool for SQL Server database administrators, the RSS Reporter for SQL Server 2005 and SQL Server 2000. No more cluttering your mailbox with hundreds of SQL Server notifications, no more digging through those emails to get the information you need, no more missed important notifications… You can now, in minutes, generate standard RSS feeds that contain all the information you need for monitoring SQL Server jobs running on multiple servers - clean, simple, and standard. Shred and Import XML Into SQL Server Using Exult For SQL Server, A Powerful Windows Application Released By Novixys Software, Inc. Novixys Software, Inc. has released Exult for SQL Server v. 1.1 a powerful new tool aimed at database administrators and IT departments for easy shredding and importing XML into SQL Server. USJade Corp's Innovative System Integration and Consulting Services Showcased at Oracle OpenWorld 2008 Global systems integration and consulting firm USJade shared its suite of Oracle based solutions designed to deliver companies mission-critical business solutions with cost effective, revenue-impacting results. USJade's customer Telegent Systems shared its successful Oracle E-Business Suite R12 Implementation at the "Oracle for High Tech" session, and was joined by Karan Yaramada, USJade President & CEO. USJade's knowledge and expertise was recognized by Oracle's group vice president, Tyler Prince, of Oracle's North America Applications Alliances and Channels. DAZ Systems, Inc. Opens New Office on East Coast DAZ Systems, Inc. an Oracle Certified Advantage Partner, providing Oracle E-Business Suite implementation and integration services, today announced the expansion of its offices on the East Coast. After IBM dalliance, Sun goes to Oracle for $7.4B Sun Microsystems Inc.'s scramble to find a suitor landed the slumping server and software maker in the arms of Oracle Corp., which agreed to pay $7.4 billion in cash for Sun in a startling marriage that would transform Silicon Valley and the computing industry. Ntirety Inc. Supports SQL Server Loadfest Ntirety Inc., the pioneer of Database Administration as a Service™, recently cosponsored SQL Server Loadfest, a free, hands-on installation of SQL Server 2008 for IT professionals in Greater Boston. Core Services Achieves OracleÂ® PartnerNetwork Platinum-Level Partner Status SOMERSET, N.J., June 14 /PRNewswire/ -- Core Services Corporation ("Core Services"), a leading global Oracle hosting and consulting service provider, is pleased to announce its achievement of the prestigious Platinum Partner status in the Oracle PartnerNetwork ("OPN"). Idera Webcast Demonstrates How to Best Use SQL Server Dynamic Management Views Expert Greg Robidoux Shows How DMVs Can Improve SQL Server Management DAZ Systems, Inc. Showcases Oracle Business Accelerator for Agile Product Lifecycle Management DAZ Systems, Inc. announced today that it is the first Implementation organization qualified to use the Oracle Business Accelerator Solution for Agile Product Lifecycle Management. The Agile PLM product offering has consistently been rated the best in class, and was acquired by Oracle in the past year. Oracle Accelerate solutions provide midsize organizations with pre-packaged bundles that allow for rapid, affordable implementations. MiPro Consulting Achieves Oracle PartnerNetwork Certified Advantage Partner Status MiPro Consulting joins elite group of companies focused on Oracle's PeopleSoft Enterprise, Oracle Business Intelligence Enterprise Edition and Oracle Business Intelligence Applications who have achieved Certified Advantage Partner status within the Oracle PartnerNetwork. SQL Server Clustering - SQL Server Mirroring solution Have you ever felt the need to have redundancy or maybe even a failover solution for your SQL Server database? Publisher Announces Long-term Support for Oracle Technologies Packt Publishing has today unveiled ambitious plans to improve its support for Oracle documentation by announcing a long-term commitment to publishing in the area. MS SQL Server Versions The latest version of SQL Server is Microsoft SQL Server 2005, this was released on 7th November 2005, at the time of writing this article I do not know of many organisations that are utilising SQL Server 2005 in a production environment but many organisations that utilise Microsoft SQL Server as a database solution have SQL Server 2005 setup in a test environment and have plans to migrate their production environments to this latest version in the future.