SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2012 Forums
 SQL Server Administration (2012)
 SQL server primary node failure
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

srikrishnaj
Starting Member

India
1 Posts

Posted - 03/11/2013 :  07:55:53  Show Profile  Reply with Quote
Hello,

I'm very new to SQL and I have the following queries:

I have a 2 node SQL 2012 server using Windows Failover cluster (2012) that uses shared storage for its database and I have a single instance running on the primary node. I have some SQL scripts generating tables, running queries etc. from an external client that connects to the DB engine using the SQL server name- so the external client runs IO to the SQL servers through IP traffic.

Now, when I fail the primary node (say a hard reboot or even a manual failover) where the SQL server role is running, my external client loses its connection to the database engine/FCI. Once the services are up and running on the secondary node after failover, I'm able to re-connect to the server and start IO again. My question is-
1) Is this by design? Meaning the external clients running IO to an SQL server instance will lose connection in case of the primary node failure?
2) Is there any way I can tweak some parameters/settings etc. such that I will have no downtime to the external client and they don't lose connectivity throughout the failover process?

Thanks!

chadmat
The Chadinator

USA
1974 Posts

Posted - 03/11/2013 :  13:21:33  Show Profile  Visit chadmat's Homepage  Reply with Quote
Yes it is by design.

No, there is no way to avoid the downtime, there will always be some failover time involved.

You could use Mirroring/Availability Groups in HA mode, and that would minimize the downtime during failover to just a second or 2, but it will still be there.

-Chad
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.33 seconds. Powered By: Snitz Forums 2000