Re: What happens to application during failover?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Andrew J. Kelly (sqlmvpnooospam_at_shadhawk.com)
Date: 08/06/04

  • Next message: Geoff N. Hiten: "Re: What happens to application during failover?" 
    Date: Fri, 6 Aug 2004 15:37:50 -0400

    That depends on several things such as the hardware, how many db's you have
    and how many transactions need to be rolled forward or back. It could be 20
    or 30 seconds or it could be minutes. That is something you need to test
    and plan for. 

    -- 
Andrew J. Kelly  SQL MVP
<anonymous@discussions.microsoft.com> wrote in message
news:15c501c47be4$34b14810$a301280a@phx.gbl...
> Thanks Geoff. Approximately, how long does the failover
> take?
> >-----Original Message-----
> >A Cluster SQL failover looks exactly like the SQL server
> stopped and
> >restarted from the client's viewpoint.  All connections
> will have to be
> >reestablished and any pending actions will need to be
> reissued.
> >
> >-- 
> >Geoff N. Hiten
> >Microsoft SQL Server MVP
> >Senior Database Administrator
> >Careerbuilder.com
> >
> >I support the Professional Association for SQL Server
> >www.sqlpass.org
> >
> ><anonymous@discussions.microsoft.com> wrote in message
> >news:181d01c47bdd$59332750$a401280a@phx.gbl...
> >> Hi,
> >>
> >> Our customer has is runnning SQL server standard and
> they
> >> have clients that access the database.
> >>
> >> We are moving them to SQL Server Enterprise in an
> >> Active/Passive configuration.
> >>
> >> My questions is what happens when the application
> connects
> >> to the database, it starts doing a series of reads, and
> a
> >> failure happens on the Active server in the cluster?
> >>
> >> Will the client application have to be re-written in any
> >> way to handle this failover? Will the application have
> >> to "re-connect" to the database? Or will the failover be
> >> transparent to the client application? How long will the
> >> failover take?
> >>
> >> Thanks,
> >> Todd
> >
> >
> >.
> >
  • Next message: Geoff N. Hiten: "Re: What happens to application during failover?"

    Relevant Pages

    • Re: Reaching Access 2003 datas via SQL Server 2005 64 bits
      ... even with the procedure to create the invoice number I still ... One client enters in the store and asks for a product. ... formats of Access database files known as MDB and ACCDB and/or Access JET. ... (I have no problem to reach Sql Server 2005 tables from Microsoft ...
      (microsoft.public.access.adp.sqlserver)
    • Re: Access 2007->SQL Server2005 "connection was forcibly closed",G
      ... an Access database in former times this was a lot of work which took me ... closed connections - but all of these errors are in the version which used ... the SQL Server 2000 and everything worked ... client for programming easy, fast and good applications. ...
      (microsoft.public.sqlserver.connect)
    • Re: Quick Question on SQL Server 2005 Express
      ... you can't attach a database in a remote machine in your network as Andrew has already mantioned. ... One database can be used only by one SQL Server instance and as far as I understand the database in question is already attached to a SQL Server instance. ... Why not installing only SQL Server Management Studio and connect to your remote instance and perform actions this way? ... The Client can live anywhere as long as it has TCP access to the server. ...
      (microsoft.public.sqlserver.setup)
    • Re: Permissions problem on SBS 2003 R2 for SQL Server 2005 clients
      ... use SQL Server authentication instead. ... I've been testing a SQL Server 2005 Express database in a multiuser ... environment using Window Small Business Server 2003 R2 with Windows XP ... On a given client computer to which I may have logged on with Windows ...
      (microsoft.public.windows.server.sbs)
    • What happens to application during failover?
      ... Our customer has is runnning SQL server standard and they ... have clients that access the database. ... Will the client application have to be re-written in any ... Or will the failover be ...
      (microsoft.public.sqlserver.clustering)