all groups > sql server clustering > november 2004 > threads for november 1 - 7, 2004
Filter by week: 1 2 3 4 5
IP Addr not failing over..
Posted by tbithoney at 11/7/2004 6:56:02 AM
I have a w2k3 cluster w/ sql 2k failover.
Problem:
the SQL fails over OK, but not the IP Addr
Any Ideas?... more >>
ip addr not failing over...
Posted by tbithoney at 11/7/2004 6:53:04 AM
I have a w2k3 cluster w/ SQL 2k failover cluster.
Problem:
when I fail the cluster to the other node, I can access the SQL name but
not the IP Addr.
I need it to work so I can rebuild the primary node.
Thanks! ... more >>
SQL Server 2000 Clustered stopped
Posted by David at 11/5/2004 10:38:32 AM
Everything worked fine, but days ago my node1 stopped and stoped few times
per day, this is the event log....
Event Type: Error
Event Source: MSSQL$SQL1
Event Category: (2)
Event ID: 17052
Date: 11/5/2004
Time: 10:15:16 AM
User: SQLCLUSTER\sqlsvc
Computer: CLR-SQL1
Description:
Err... more >>
IP Address.
Posted by w2system NO[at]SPAM system.com at 11/4/2004 11:40:57 AM
Hi,
i have to node cluster on w2k3 when i check the
servername parameter i see the virtual server name but i want to see the
real address on dns name for each machine .
is that possible ?
i want to write a store procedure to help see on which machine the sql is
currently runing .
... more >>
Clustering and Transactions
Posted by Leila at 11/3/2004 10:10:05 PM
Hi,
When the primary server fails and the secondary starts to take over the job,
what will happen to the transactions opened on the primary node prior to
failure?
Thanks,
Leila
... more >>
IP Address
Posted by Leila at 11/3/2004 9:27:24 PM
Hi,
While installing SQL Server on the primary node, it needs an IP address for
Virtual SQL Server. Should I enter the IP address of the primary node
machine in the network or something else?
What's the advantage of adding more than one IP in this screen?
Any help would be greatly appreciated.
... more >>
Rename a SQL Server 2000 virtual server (Workaround)
Posted by Joe K. at 11/1/2004 2:13:05 PM
I have read from the MS SQL Server 2000 High Availability book by Allan Hirt
that Renaming a SQL Server 2000 virtual server is neither possible or
supported.
What is a workaround to this procedure if you would like to move your
present virtual server to a new server? The database is 300 GB... more >>
|