Re: FailOver

It sounds like you aren't using Failover Clustering (or MSCS). This is the goal you want to target for high availability for your SQL installation. There is a ton of great information on the Microsoft site re: SQL Clustering, including step-by-step guides. I believe Marcin gave you some links as well...

Hope this helps,
--Ryan

--
Ryan Sokolowski
MVP - Clustering
MCT, MCITP x3, MCTS x7, MCSE x2, CCNA, CCDA, BCFP


"Marcin" <marcin@xxxxxxxxxxxxxxxx> wrote in message news:uTch%23MHWJHA.3688@xxxxxxxxxxxxxxxxxxxxxxx
Peter,
this is a set of rather loaded questions - so my recommendation would be to first determine whether you deal with clustering or mirroring (which is the most likely suspect based on the info you provided) - since these are two distinct - and for the most part independent - technologies (although there are ways to combine them to some extent).
In case of the former, you have a single instance of SQL Server that has ability to automatically fail-over across multiple physical Windows servers (cluster nodes). The latter involves two separate instances of SQL Server (plus a "witness" instance, which facilitates automatic failover) - and the failover happens on the database level.
For more info, refer to http://technet.microsoft.com/en-us/magazine/cc162491.aspx, http://technet.microsoft.com/en-us/library/ms189127(SQL.90).aspx, and http://technet.microsoft.com/en-us/magazine/cc162479.aspx (if you intend to combine these two technologies)

hth
Marcin

"Peter Newman" <PeterNewman@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:F464E2C9-AB00-496A-8E2B-0653E5BF9D80@xxxxxxxxxxxxxxxx
I have two mirrored SQL 2005 servers which are administered by a third
server. I am not sure if this has been set up as a cluster as I am not fully
up to par with clustering.

Currently is 'SQLPrimary' goes down than all applications accessing data,
stop responding. Most applications were written in vb.net 2005 and the data
connection have the failover set.

Is there any 'procedures' that can be carried out to test if the servers are
set up correctly?

Currently if the primary server goes down then i have to manually failover
the secondary server to make all databases the primary on the main server.
This as you can imagine is a nightmare as our buisness should be online 24/7
and in order to reset the servers we have to take our amin business offline.

Our buisness was devoloped on Novell mirrored servers and I am trying to
ensure that now we are using SQL2005 servers that we capture recreate the
same secnrio we had with Novell.

can any one suggest any post's / white papers that i can study to ensure
that the servers are set correctly and that when the primary server fails
that any applications will contuine to function on the 'mirrored server'

thanks in advance



.

Relevant Pages

  • Re: Cluster IP Address change
    ... I've heard the same story from...after not hearing this in 2 years of SQL ... After changing sql ip address resource & sql name resource came online but ... sql server resource was failing. ... MVP - Windows Server - Clustering ...
    (microsoft.public.sqlserver.clustering)
  • Re: Side-by-side upgrade - moving master, msdb and model
    ... MVP - Windows Server - Clustering ... "In some cases, you may want to copy the system databases, including ... from the source SQL Server 2000 instance to the SQL ...
    (microsoft.public.sqlserver.clustering)
  • Re: 4 Queries about DB clustering
    ... I support the Professional Association for SQL Server ... First you install MSCS (Clustering). ... >> on a single logical device physically connected to all host nodes. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Choosing correct high availability setup
    ... normal SQL startup, DB integrity check, roll back non-committed ... MVP - Windows Server - Clustering ... Basically there will be an Access database that arrives via FTP at ...
    (microsoft.public.sqlserver.clustering)
  • Re: Redundancy design in SBS Domain
    ... SQL as a guest or on the Host? ... Server2 - HyperV with a VM (ready for SBS if needed) ... I want Server2 as my backup Domain controler, so I would need to use the 2nd Win2008 licence for it, but would I just make it the host or put it in a VM with SQL server? ... I don't see anything about 'server' failover (just application failover, ...
    (microsoft.public.windows.server.sbs)