Windows IT Pro is the leading independent community for IT professionals deploying Microsoft Windows server and client applications and technologies.
  
  
  Advanced Search 


April 2006

Neverfail for SQL Server

RSS
Subscribe to Windows IT Pro | See More SQL Server and Database Articles Here | Reprints | Or get the Monthly Online Pass—only $5.95 a month!

Businesses demand high availability and The Never-fail Group's Neverfail for SQL Server provides it, with server-level and site-level protection for Microsoft SQL Server, as well as automatic failover capability. Neverfail runs on Windows Server 2003 Standard and Enterprise Editions, and Windows 2000 Server SP4, and it supports SQL Server 2000 SP3a and later.

I tested Neverfail between two servers running on the same subnet with a 100MB LAN connection. (Neverfail also includes a Low Bandwidth Module for use in WAN scenarios.) My primary and secondary servers were running Windows 2003 and SQL Server 2000 SP4.

Setup involved many steps, including some manual configuration of the network, but it went smoothly. Neverfail installed the software on the primary and secondary servers and initialized the replication environment, including the Neverfail Heartbeat Management Client. You can also install it on an administrative workstation. This client lets you set up parameters for controlling automatic failover, and it can initiate manual failover and failback. Web Figure 1 shows the Neverfail status and control screen.

Neverfail uses queued asynchronous replication to replicate data from the primary to the secondary server. I tested switchover capabilities and found that the manual failover took approximately 20 seconds to complete, plus another 10 seconds for the SQL Server service to start up. After I pulled the plug on the primary server, it took Neverfail about 15 seconds to determine that the server was unavailable and another 30 seconds to complete the failover before SQL Server was active on the secondary server.

In spite of the lengthy setup time, Neverfail worked well, and the failover process was reliable and quick.

Neverfail for SQL Server
PROS: Easy management; quick failover functionality; provides excellent control over failover parameters
CONS: Lengthy setup process
RATING: 4 out of 5
PRICE: $7600 for one CPU; $10,240 for two CPUs; $12,800 for four CPUs
RECOMMENDATION: Neverfail is an excellent choice for organizations demanding maximum availability for SQL Server.
CONTACT: The Neverfail Group 512--327-5777 http://www.neverfailgroup.com

End of Article



Reader Comments

You must be a registered user or online subscriber to comment on this article. Please log on before posting a comment. Are you a new visitor? Register now




Top Viewed ArticlesView all articles
WinInfo Short Takes: Week of November 9, 2009

An often irreverent look at some of the week's other news, including some more Windows 7 sales momentum, some Sophos stupidity, Microsoft's cloud computing self-loathing, more whining from the browser makers, Zoho's "Fake Office," and much, much more ...

Command Prompt Tricks

One reader shares his tip for setting up the command prompt to reflect a remote path. ...

Understanding File-Size Limits on NTFS and FAT

A general confusion about files sizes on FAT seems to stem from FAT32's file-size limit of 4GB and partition-size limit of 2TB. ...


Related Events SQL Server Unleashed EMEA

WinConnections and Microsoft® Exchange Connections

Deep Dive into Windows Server 2008 R2 presented by John Savill

Check out our list of Free Email Newsletters!

SQL Server and Database eBooks Safeguarding Your Windows Servers

SQL Server Administration for Oracle DBAs

Taking Control: Monitoring the Windows Platform Proactively

Related SQL Server and Database Resources Introducing Left-Brain.com, the online IT bookstore
Looking for books, CDs, toolkits, eBooks? Prime your mind at Left-Brain.com

Discover Windows IT Pro eLearning Series!
Clear & detailed technical information and helpful how-to's, all in our trademark no-nonsense format


Windows IT Pro Home Register FAQ for Windows WinInfo News
Europe Edition About Us Contact Us/Customer Service Media Kit Affiliates / Licensing  
SQL Server Magazine Office & SharePoint Pro DevProConnections IT Job Hound
Left-Brain.com Technology Resource Directory asp.netPRO ITTV Windows SuperSite 
 
 Windows IT Pro is a Division of Penton Media Inc.
 © 2009 Penton Media, Inc. Terms of Use | Privacy Statement