Re: SQL Failover problem.

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

From: C-Ya (CYa_at_discussions.microsoft.com)
Date: 02/18/05 

Date: Fri, 18 Feb 2005 09:01:18 -0800

Well guys, like magic it now works. I did do a lots of things so I probably
fixed it. Both instances will fail over to the other server and then
fail-back. I problem down.

Now I have another question. I have been told that I can have my web servers
make calls to the MSDTC, and it will pass the data back and forth to the
instances of SQL. This way my web servers don't have to know which instance
of SQL the database they need is in. Correct ??? If so where can I find
information on how to run it this way. Web sites, books, anything will help

Thanks

"joe." wrote:

> A few thoughts:
> 1. Have you tried a manual failover/move of your default instance without
> shutting down the machine?
> 2. Anything interesting in the event logs?
> 3. Do you have enough memory on server 1 to accomodate the default instance
> after the named instance is up and running?
>
>
> joe.
>
>
> "C-Ya" <C-Ya@discussions.microsoft.com> wrote in message
> news:283188D9-B426-4DD2-9ED3-2B3105438F9D@microsoft.com...
> >I have multiple (2) instances of sql 2000 running on my windows 2003
> >cluster.
> > I have the default instance owned by server1 and a named instance owner by
> > server 2. If I shutdown server 1 then my default instance fails over to
> > server2. Now server two is running both. (no problem). If I shutdown
> > server
> > 2 then my named instance fails over to server1, but my default instance
> > fails
> > and will only come up when server2 is back online. I have check all
> > dependencies. The physical disks, the SQL IP Address, and the SQL Network
> > Name stay online, just the SQL Server (and stuff dependant on it) fail.
> > This
> > is a new installation (just a few days old)
> >
> > Should I have done two named instances instead of a default and a named?
> >
> > One more bit of info. There is no problem with my Cluster Group or my DTC
> > Group failing over or failing back.
>
>
>

Relevant Pages

  • Re: SQL injection in Persianblog
    ... course you only intend to inject numbers into the database records.. ... The CInt calls force typecasting, ... application that doesn't fail gracefully? ... > parameter values that will execute SQL commands on the ...
    (Bugtraq)
  • Re: Distribution Cleanup Job Fails
    ... No it would not cause replication to fail, ... Make sure that xp_cmdshell is enabled and the SQL Serer agent account has ... Looking for a SQL Server replication book? ...
    (microsoft.public.sqlserver.replication)
  • Re: ADSI to detect if New Virtual Web/FTP Servers allowed
    ... Does it mean the same on all IIS servers? ... You can create multiple websites on Windows XP Pro, ... So you cannot write code that will never fail in the future, ... > Is there some information somewhere in the metabase or other API that will> give me a clue that IIS is running on a machine that doesn't allow multiple> virtual web servers without having to just try to> create the web server and have it fail? ...
    (microsoft.public.inetserver.iis)
  • Re: Server 2003, and Server 2000 , Can both OSs be in the same cluster running sql2000?
    ... Fail the cluster over to it and upgrade the other. ... one node and remove it from SQL using the SQL install CD. ...
    (microsoft.public.sqlserver)
  • Re: Server 2003, and Server 2000 , Can both OSs be in the same cluster running sql2000?
    ... Fail the cluster over to it and upgrade the other. ... one node and remove it from SQL using the SQL install CD. ...
    (microsoft.public.sqlserver.clustering)