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: DU2WQD 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 Core Services and Oracle SPARC T4 Server Deliver Client Satisfaction SOMERSET, N.J., Feb. 2, 2012 /PRNewswire/ -- Core Services Corporation ("Core Services"), an Oracle Platinum Partner and OAUG Three Star Partner, is delighted to announce Oracle Corporation's ("Oracle") recognition of Core Services as a valued partner in Oracle's SPARC T4 server success. Learn more . CIBER Veterans Mike Dillon and Garth Carter Tapped to Drive CIBER's North America Oracle Business GREENWOOD VILLAGE, Colo., Feb. 2, 2012 /PRNewswire/ -- CIBER, a premier partner of Oracle for more than 20 years, has tapped CIBER veteran Mike Dillon to lead its North America Oracle Practice, and Garth Carter, the head of CIBER's public sector and higher education segment, to lead Oracle sales for the company. M-D Building Products Partners with Core Services Corporation for a Successful Oracle EBS R12 Upgrade SOMERSET, N.J., Jan. 19, 2012 /PRNewswire/ -- Core Services Corporation ("Core Services"), an Oracle Platinum Partner, successfully completed a major Oracle R12 upgrade project with M-D Building Products ("M-D Building"). This significant accomplishment is another example of Core Services' deep consulting and technical expertise with the Oracle E-Business Suite ("EBS"). Through their mutually beneficial, collaborative partnership, Core Services and M-D Building completed this upgrade cost-effectively and efficiently. PlumChoice Announces Availability of Technical Service Automation Solution to Support Microsoft SQL Server BILLERICA, Mass., Dec. 22, 2011 /PRNewswire/ -- PlumChoice, Inc., a pioneer in the delivery of remote technical services in the next-generation Service 2.0 model and the parent company of Tific AB, announced today that its best-of-breed support services automation solution is now generally available for Microsoft SQL Server 2008 R2. Attunity Named Winner of Two Top Awards by SQL Server Magazine for Best Business Intelligence (BI) Software BURLINGTON, Massachusetts, November 29, 2011 /PRNewswire/ -- Attunity Ltd. (OTC BB: ATTUF.OB), a leading provider of real-time data integration software, announced today that its Attunity SQL Server-CDC for SSIS data replication software was awarded the gold medal, top honor in the "2011 Community Choice Awards", and the silver medal in the "2011 Editors' Best Awards" â”€ both in the Best BI/Reporting Tool category. DBSophic's Qure Optimizer Boosts SQL Server Performance at Logimatic JERUSALEM, January 4, 2012 /PRNewswire/ -- DBSophic, an innovative provider of performance management products for SQL Server based applications, announced the deployment of its Qure Optimizer solution at Logimatic. K3 Optimizes SQL Server Performance With DBSophic's Qure Optimizer JERUSALEM, January 17, 2012 /PRNewswire/ -- DBSophic, an innovative provider of performance management products for SQL Server based applications, announced the successful deployment of its Qure Optimizer solution by K3 Business Technology Group. Qure Optimizer is the first product to implement workload tuning, a new approach to SQL Server performance optimization. Project Partners Expands Management Team With Industry Veterans HALF MOON BAY, Calif., Nov. 28, 2011 /PRNewswire/ -- Project Partners, LLC, the world's foremost experts in providing Oracle solutions for project-centric organizations, today announced the addition of two executives to their management team, further strengthening the company's project-centric expertise and their delivery of Oracle consulting services and products that extend the functionality of Oracle Applications. Effective immediately, Steve Derivan joins Project Partners as vice president of Oracle Professional Services with executive responsibility for the strategic direction and profitability of the division focused on delivering Oracle Applications services. Mr. DBSophic's Qure Analyzer Reviewed on SQL-Server-Performance.com JERUSALEM, January 10, 2012 /PRNewswire/ -- DBSophic, an innovative provider of performance management products for SQL Server based applications, announced that the company's Qure Analyzer solution has been reviewed on . SQL Sentry Named as Winner of Multiple SQL Server Magazine Awards CHARLOTTE, N.C., Nov. 21, 2011 /PRNewswire/ -- SQL Sentry, Inc., the developer of award-winning software for Microsoft SQL Server, announced today that it was recognized with several awards by Penton Media's SQL Server Magazine. SQL Sentry Performance Advisor was named as gold medal winner of the "2011 Editors' Best Awards" and bronze medal winner of the "2011 Community Choice Awards" in the Best Database Monitoring and Performance Product category. SQL Sentry Event Manager was named as silver medal winner of the "2011 Community Choice Awards" and bronze medal winner of the "2011 Editors' Best Awards" in the Best Database Management Product category. SQL Sentry Plan Explorer was named as gold medal winner of the "2011 Editors' Best Award ... Sage Achieves Oracle Database Ready Status PARIS, January 12, 2012 /PRNewswire/ -- Sage ERP X3 Tested, Tuned and Ready to Runon Oracle Database Sage announced today that Sage ERP X3 has achieved Oracle Database Ready status through Oracle PartnerNetwork (OPN), demonstrating that Sage has fully tested and supports Sage ERP X3 on Oracle Database 11g Release 2. Mythics Awarded Contract by the State of California for Oracle Products and Services VIRGINIA BEACH, Va., Feb. 6, 2012 /PRNewswire/ -- Mythics an elite Oracle Platinum value-added resale (VAR) product and training partner, an Oracle GSA Schedule holder GS-35-F-0153M and an award winning Oracle Platinum Specialized Consulting partner, today announced that it has been awarded a contract by the California Department of General Services (DGS) Procurement Division (PD) for Oracle software products and services. 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.