on the passive node i tried to set range port for DTC
I tried using dcomcnfg, but when i reboot the node cannot join the cluster.
Why ?
thanks in advance.
Regards,
Dario
Review the NT event logs and cluster.log to get more details on why the node failed to join the cluster.
Best Regards,
Uttam Parui
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way to do this is to visit the following websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx
|||DTC by deault will use any port ranges.
a registry hack can be done to limit it to certain range of ports.
"Dario Sala" wrote:
> on the passive node i tried to set range port for DTC
> I tried using dcomcnfg, but when i reboot the node cannot join the cluster.
> Why ?
> thanks in advance.
> Regards,
> Dario
>
>
Showing posts with label passive. Show all posts
Showing posts with label passive. Show all posts
Thursday, March 29, 2012
Tuesday, March 27, 2012
Cluster Set up Question
Hello,
We are implementing clustering (Active/Passive) in our Production environment.
So we will have two windows server 2003 for SQL SERVER. (ProdDbServer1 and
ProdDbServer2)
I will install SQL Server on both the machine and i will create my database
(FinDB)
on both the machine's SQL SERVER with all the tables,store procs, functions
etc.
So lets say if my Active Server is in action and accepting all the OLTP
transaction
and for some reason if it goes fail...How can passive server can take over,
how
passive server can be at the same point of the fail of active server ?
Bacically how both the Database will be in sink with each other ?
Pls help me
A cluster consists of two machines and a storage system that is physically
connected to both systems. The Cluster software arbitrates ownership of the
disk resource so that only one server can access it at a time. The cluster
software also monitor the sql instance on the active host node for failure.
If the first node fails, ownership of the SQL instance and the corresponding
disk resource is transferred to the other node. From the outside, it looks
like the SQL Server stopped and restarted.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"mvp" <mvp@.discussions.microsoft.com> wrote in message
news:3F5342B1-3AB6-4CD7-B763-33587B1BED0E@.microsoft.com...
> Hello,
> We are implementing clustering (Active/Passive) in our Production
> environment.
> So we will have two windows server 2003 for SQL SERVER. (ProdDbServer1 and
> ProdDbServer2)
> I will install SQL Server on both the machine and i will create my
> database
> (FinDB)
> on both the machine's SQL SERVER with all the tables,store procs,
> functions
> etc.
> So lets say if my Active Server is in action and accepting all the OLTP
> transaction
> and for some reason if it goes fail...How can passive server can take
> over,
> how
> passive server can be at the same point of the fail of active server ?
> Bacically how both the Database will be in sink with each other ?
> Pls help me
|||Thanks Geoff.
So From your reply, I understand that i will have to install SQL SERVER 2000
on both the windows 2003 server.
I have following questions.
1) After installing SQL SERVER on both the windows m/c, When i create
database on both the machine, Would i have to mentioned same Data files and
Transaction Log Path ( Because we will have storage will be in SAN), when i
create DB ?
2) For example if i create one table in the FinDB of on ServerA and then if
i go to FinDB of ServerB, I will see that table there too, if i will have
Datafiles and Transaction Log Path are same for both the servers ?
"Geoff N. Hiten" wrote:
> A cluster consists of two machines and a storage system that is physically
> connected to both systems. The Cluster software arbitrates ownership of the
> disk resource so that only one server can access it at a time. The cluster
> software also monitor the sql instance on the active host node for failure.
> If the first node fails, ownership of the SQL instance and the corresponding
> disk resource is transferred to the other node. From the outside, it looks
> like the SQL Server stopped and restarted.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
> "mvp" <mvp@.discussions.microsoft.com> wrote in message
> news:3F5342B1-3AB6-4CD7-B763-33587B1BED0E@.microsoft.com...
>
>
|||Thanks Geoff.
So From your reply, I understand that i will have to install SQL SERVER 2000
on both the windows 2003 server.
I have following questions.
1) After installing SQL SERVER on both the windows m/c, When i create
database on both the machine, Would i have to mentioned same Data files and
Transaction Log Path ( Because we will have storage will be in SAN), when i
create DB ?
2) For example if i create one table in the FinDB of on ServerA and then if
i go to FinDB of ServerB, I will see that table there too, if i will have
Datafiles and Transaction Log Path are same for both the servers ?
"Geoff N. Hiten" wrote:
> A cluster consists of two machines and a storage system that is physically
> connected to both systems. The Cluster software arbitrates ownership of the
> disk resource so that only one server can access it at a time. The cluster
> software also monitor the sql instance on the active host node for failure.
> If the first node fails, ownership of the SQL instance and the corresponding
> disk resource is transferred to the other node. From the outside, it looks
> like the SQL Server stopped and restarted.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
> "mvp" <mvp@.discussions.microsoft.com> wrote in message
> news:3F5342B1-3AB6-4CD7-B763-33587B1BED0E@.microsoft.com...
>
>
|||Does anyone want to rethink their perspective on why active/active and
active/passive should be used as terminology?
"mvp" <mvp@.discussions.microsoft.com> wrote in message
news:3F5342B1-3AB6-4CD7-B763-33587B1BED0E@.microsoft.com...
> Hello,
> We are implementing clustering (Active/Passive) in our Production
> environment.
> So we will have two windows server 2003 for SQL SERVER. (ProdDbServer1 and
> ProdDbServer2)
> I will install SQL Server on both the machine and i will create my
> database
> (FinDB)
> on both the machine's SQL SERVER with all the tables,store procs,
> functions
> etc.
> So lets say if my Active Server is in action and accepting all the OLTP
> transaction
> and for some reason if it goes fail...How can passive server can take
> over,
> how
> passive server can be at the same point of the fail of active server ?
> Bacically how both the Database will be in sink with each other ?
> Pls help me
|||If you install SQL Server twice, you will have 2 physically separate
instances of SQL Server running within a single cluster. If you then create
your database in each of these instances, you will have 2 physically
separate copies of the database. In order to synchronize data between the
two databases, you would have to implement replication, log shipping, or
database mirroring (2005 only). If one of the servers failed, you would
have to change your application connections to point at the other SQL Server
instance.
"mvp" <mvp@.discussions.microsoft.com> wrote in message
news:3F5342B1-3AB6-4CD7-B763-33587B1BED0E@.microsoft.com...
> Hello,
> We are implementing clustering (Active/Passive) in our Production
> environment.
> So we will have two windows server 2003 for SQL SERVER. (ProdDbServer1 and
> ProdDbServer2)
> I will install SQL Server on both the machine and i will create my
> database
> (FinDB)
> on both the machine's SQL SERVER with all the tables,store procs,
> functions
> etc.
> So lets say if my Active Server is in action and accepting all the OLTP
> transaction
> and for some reason if it goes fail...How can passive server can take
> over,
> how
> passive server can be at the same point of the fail of active server ?
> Bacically how both the Database will be in sink with each other ?
> Pls help me
|||No. You create the cluster. You then install a single copy of SQL Server
into the cluster. You then create your database inside that instance. You
do not install SQL Server directly to a machine. It is installed to the
cluster.
"mvp" <mvp@.discussions.microsoft.com> wrote in message
news:95A55E02-1BCB-47E1-9458-E01080486B3D@.microsoft.com...[vbcol=seagreen]
> Thanks Geoff.
> So From your reply, I understand that i will have to install SQL SERVER
> 2000
> on both the windows 2003 server.
> I have following questions.
> 1) After installing SQL SERVER on both the windows m/c, When i create
> database on both the machine, Would i have to mentioned same Data files
> and
> Transaction Log Path ( Because we will have storage will be in SAN), when
> i
> create DB ?
> 2) For example if i create one table in the FinDB of on ServerA and then
> if
> i go to FinDB of ServerB, I will see that table there too, if i will have
> Datafiles and Transaction Log Path are same for both the servers ?
> "Geoff N. Hiten" wrote:
|||The SQL Installer is cluster-aware. That is, it handles all the details of
cluster-wide installation. It creates the virtual server and installs the
local binaries on all nodes. It also groups all the cluster resources and
sets the dependencies correctly. Once SQL is running and you are connected,
there is almost no difference in SQL operations between clustered and
non-clustered SQL Servers. You end up connecting to a virtual SQL Server
instance that looks identical regardless of which node is actually hosting
it at the moment.
Here is an excellent overview of SQL failover clustering that you may find
helpful:
http://www.microsoft.com/technet/pro.../failclus.mspx
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"mvp" <mvp@.discussions.microsoft.com> wrote in message
news:95A55E02-1BCB-47E1-9458-E01080486B3D@.microsoft.com...[vbcol=seagreen]
> Thanks Geoff.
> So From your reply, I understand that i will have to install SQL SERVER
> 2000
> on both the windows 2003 server.
> I have following questions.
> 1) After installing SQL SERVER on both the windows m/c, When i create
> database on both the machine, Would i have to mentioned same Data files
> and
> Transaction Log Path ( Because we will have storage will be in SAN), when
> i
> create DB ?
> 2) For example if i create one table in the FinDB of on ServerA and then
> if
> i go to FinDB of ServerB, I will see that table there too, if i will have
> Datafiles and Transaction Log Path are same for both the servers ?
> "Geoff N. Hiten" wrote:
|||Thanks for the reply.
No i do not want two sql server instance in single cluster, I just want one
instance in my cluster. so what should i do, install SQL SERVER 2000 Software
and create my database in just one machine (ProdSqlServerA)?
If i do like this and if i go to another sever (ProdSqlServerB), would i see
SQL SERVER and my created Db on that maching too ?
"Z" wrote:
> If you install SQL Server twice, you will have 2 physically separate
> instances of SQL Server running within a single cluster. If you then create
> your database in each of these instances, you will have 2 physically
> separate copies of the database. In order to synchronize data between the
> two databases, you would have to implement replication, log shipping, or
> database mirroring (2005 only). If one of the servers failed, you would
> have to change your application connections to point at the other SQL Server
> instance.
>
> "mvp" <mvp@.discussions.microsoft.com> wrote in message
> news:3F5342B1-3AB6-4CD7-B763-33587B1BED0E@.microsoft.com...
>
>
|||No thanks! I don't want Mike and Geoff mad at me anymore on this subject.
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training
"Z" <z@.z.com> wrote in message
news:%23MIgYMvFGHA.984@.tk2msftngp13.phx.gbl...
> Does anyone want to rethink their perspective on why active/active and
> active/passive should be used as terminology?
>
> "mvp" <mvp@.discussions.microsoft.com> wrote in message
> news:3F5342B1-3AB6-4CD7-B763-33587B1BED0E@.microsoft.com...
>
sqlsql
We are implementing clustering (Active/Passive) in our Production environment.
So we will have two windows server 2003 for SQL SERVER. (ProdDbServer1 and
ProdDbServer2)
I will install SQL Server on both the machine and i will create my database
(FinDB)
on both the machine's SQL SERVER with all the tables,store procs, functions
etc.
So lets say if my Active Server is in action and accepting all the OLTP
transaction
and for some reason if it goes fail...How can passive server can take over,
how
passive server can be at the same point of the fail of active server ?
Bacically how both the Database will be in sink with each other ?
Pls help me
A cluster consists of two machines and a storage system that is physically
connected to both systems. The Cluster software arbitrates ownership of the
disk resource so that only one server can access it at a time. The cluster
software also monitor the sql instance on the active host node for failure.
If the first node fails, ownership of the SQL instance and the corresponding
disk resource is transferred to the other node. From the outside, it looks
like the SQL Server stopped and restarted.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"mvp" <mvp@.discussions.microsoft.com> wrote in message
news:3F5342B1-3AB6-4CD7-B763-33587B1BED0E@.microsoft.com...
> Hello,
> We are implementing clustering (Active/Passive) in our Production
> environment.
> So we will have two windows server 2003 for SQL SERVER. (ProdDbServer1 and
> ProdDbServer2)
> I will install SQL Server on both the machine and i will create my
> database
> (FinDB)
> on both the machine's SQL SERVER with all the tables,store procs,
> functions
> etc.
> So lets say if my Active Server is in action and accepting all the OLTP
> transaction
> and for some reason if it goes fail...How can passive server can take
> over,
> how
> passive server can be at the same point of the fail of active server ?
> Bacically how both the Database will be in sink with each other ?
> Pls help me
|||Thanks Geoff.
So From your reply, I understand that i will have to install SQL SERVER 2000
on both the windows 2003 server.
I have following questions.
1) After installing SQL SERVER on both the windows m/c, When i create
database on both the machine, Would i have to mentioned same Data files and
Transaction Log Path ( Because we will have storage will be in SAN), when i
create DB ?
2) For example if i create one table in the FinDB of on ServerA and then if
i go to FinDB of ServerB, I will see that table there too, if i will have
Datafiles and Transaction Log Path are same for both the servers ?
"Geoff N. Hiten" wrote:
> A cluster consists of two machines and a storage system that is physically
> connected to both systems. The Cluster software arbitrates ownership of the
> disk resource so that only one server can access it at a time. The cluster
> software also monitor the sql instance on the active host node for failure.
> If the first node fails, ownership of the SQL instance and the corresponding
> disk resource is transferred to the other node. From the outside, it looks
> like the SQL Server stopped and restarted.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
> "mvp" <mvp@.discussions.microsoft.com> wrote in message
> news:3F5342B1-3AB6-4CD7-B763-33587B1BED0E@.microsoft.com...
>
>
|||Thanks Geoff.
So From your reply, I understand that i will have to install SQL SERVER 2000
on both the windows 2003 server.
I have following questions.
1) After installing SQL SERVER on both the windows m/c, When i create
database on both the machine, Would i have to mentioned same Data files and
Transaction Log Path ( Because we will have storage will be in SAN), when i
create DB ?
2) For example if i create one table in the FinDB of on ServerA and then if
i go to FinDB of ServerB, I will see that table there too, if i will have
Datafiles and Transaction Log Path are same for both the servers ?
"Geoff N. Hiten" wrote:
> A cluster consists of two machines and a storage system that is physically
> connected to both systems. The Cluster software arbitrates ownership of the
> disk resource so that only one server can access it at a time. The cluster
> software also monitor the sql instance on the active host node for failure.
> If the first node fails, ownership of the SQL instance and the corresponding
> disk resource is transferred to the other node. From the outside, it looks
> like the SQL Server stopped and restarted.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
> "mvp" <mvp@.discussions.microsoft.com> wrote in message
> news:3F5342B1-3AB6-4CD7-B763-33587B1BED0E@.microsoft.com...
>
>
|||Does anyone want to rethink their perspective on why active/active and
active/passive should be used as terminology?
"mvp" <mvp@.discussions.microsoft.com> wrote in message
news:3F5342B1-3AB6-4CD7-B763-33587B1BED0E@.microsoft.com...
> Hello,
> We are implementing clustering (Active/Passive) in our Production
> environment.
> So we will have two windows server 2003 for SQL SERVER. (ProdDbServer1 and
> ProdDbServer2)
> I will install SQL Server on both the machine and i will create my
> database
> (FinDB)
> on both the machine's SQL SERVER with all the tables,store procs,
> functions
> etc.
> So lets say if my Active Server is in action and accepting all the OLTP
> transaction
> and for some reason if it goes fail...How can passive server can take
> over,
> how
> passive server can be at the same point of the fail of active server ?
> Bacically how both the Database will be in sink with each other ?
> Pls help me
|||If you install SQL Server twice, you will have 2 physically separate
instances of SQL Server running within a single cluster. If you then create
your database in each of these instances, you will have 2 physically
separate copies of the database. In order to synchronize data between the
two databases, you would have to implement replication, log shipping, or
database mirroring (2005 only). If one of the servers failed, you would
have to change your application connections to point at the other SQL Server
instance.
"mvp" <mvp@.discussions.microsoft.com> wrote in message
news:3F5342B1-3AB6-4CD7-B763-33587B1BED0E@.microsoft.com...
> Hello,
> We are implementing clustering (Active/Passive) in our Production
> environment.
> So we will have two windows server 2003 for SQL SERVER. (ProdDbServer1 and
> ProdDbServer2)
> I will install SQL Server on both the machine and i will create my
> database
> (FinDB)
> on both the machine's SQL SERVER with all the tables,store procs,
> functions
> etc.
> So lets say if my Active Server is in action and accepting all the OLTP
> transaction
> and for some reason if it goes fail...How can passive server can take
> over,
> how
> passive server can be at the same point of the fail of active server ?
> Bacically how both the Database will be in sink with each other ?
> Pls help me
|||No. You create the cluster. You then install a single copy of SQL Server
into the cluster. You then create your database inside that instance. You
do not install SQL Server directly to a machine. It is installed to the
cluster.
"mvp" <mvp@.discussions.microsoft.com> wrote in message
news:95A55E02-1BCB-47E1-9458-E01080486B3D@.microsoft.com...[vbcol=seagreen]
> Thanks Geoff.
> So From your reply, I understand that i will have to install SQL SERVER
> 2000
> on both the windows 2003 server.
> I have following questions.
> 1) After installing SQL SERVER on both the windows m/c, When i create
> database on both the machine, Would i have to mentioned same Data files
> and
> Transaction Log Path ( Because we will have storage will be in SAN), when
> i
> create DB ?
> 2) For example if i create one table in the FinDB of on ServerA and then
> if
> i go to FinDB of ServerB, I will see that table there too, if i will have
> Datafiles and Transaction Log Path are same for both the servers ?
> "Geoff N. Hiten" wrote:
|||The SQL Installer is cluster-aware. That is, it handles all the details of
cluster-wide installation. It creates the virtual server and installs the
local binaries on all nodes. It also groups all the cluster resources and
sets the dependencies correctly. Once SQL is running and you are connected,
there is almost no difference in SQL operations between clustered and
non-clustered SQL Servers. You end up connecting to a virtual SQL Server
instance that looks identical regardless of which node is actually hosting
it at the moment.
Here is an excellent overview of SQL failover clustering that you may find
helpful:
http://www.microsoft.com/technet/pro.../failclus.mspx
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"mvp" <mvp@.discussions.microsoft.com> wrote in message
news:95A55E02-1BCB-47E1-9458-E01080486B3D@.microsoft.com...[vbcol=seagreen]
> Thanks Geoff.
> So From your reply, I understand that i will have to install SQL SERVER
> 2000
> on both the windows 2003 server.
> I have following questions.
> 1) After installing SQL SERVER on both the windows m/c, When i create
> database on both the machine, Would i have to mentioned same Data files
> and
> Transaction Log Path ( Because we will have storage will be in SAN), when
> i
> create DB ?
> 2) For example if i create one table in the FinDB of on ServerA and then
> if
> i go to FinDB of ServerB, I will see that table there too, if i will have
> Datafiles and Transaction Log Path are same for both the servers ?
> "Geoff N. Hiten" wrote:
|||Thanks for the reply.
No i do not want two sql server instance in single cluster, I just want one
instance in my cluster. so what should i do, install SQL SERVER 2000 Software
and create my database in just one machine (ProdSqlServerA)?
If i do like this and if i go to another sever (ProdSqlServerB), would i see
SQL SERVER and my created Db on that maching too ?
"Z" wrote:
> If you install SQL Server twice, you will have 2 physically separate
> instances of SQL Server running within a single cluster. If you then create
> your database in each of these instances, you will have 2 physically
> separate copies of the database. In order to synchronize data between the
> two databases, you would have to implement replication, log shipping, or
> database mirroring (2005 only). If one of the servers failed, you would
> have to change your application connections to point at the other SQL Server
> instance.
>
> "mvp" <mvp@.discussions.microsoft.com> wrote in message
> news:3F5342B1-3AB6-4CD7-B763-33587B1BED0E@.microsoft.com...
>
>
|||No thanks! I don't want Mike and Geoff mad at me anymore on this subject.
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training
"Z" <z@.z.com> wrote in message
news:%23MIgYMvFGHA.984@.tk2msftngp13.phx.gbl...
> Does anyone want to rethink their perspective on why active/active and
> active/passive should be used as terminology?
>
> "mvp" <mvp@.discussions.microsoft.com> wrote in message
> news:3F5342B1-3AB6-4CD7-B763-33587B1BED0E@.microsoft.com...
>
sqlsql
Cluster service fails
I'm not able to start the cluster service on the 2nd node of our cluster.
O/S is 2003, with SQL 2000. The 2nd node is passive, and appears to join the
cluster but then it terminates unexpectedly.
We've tried using the Administrator account to start the server, but with
the same results.
The cluster service is fine on node 1.
What can I try to do in order to get the service to start?
Thanks,
Chris
"Chris" <Chris@.discussions.microsoft.com> wrote in message
news:7FE6F3AD-B838-414C-B216-D0CC84AE28F0@.microsoft.com...
> I'm not able to start the cluster service on the 2nd node of our cluster.
> O/S is 2003, with SQL 2000. The 2nd node is passive, and appears to join
the
> cluster but then it terminates unexpectedly.
>
My guess is it's having trouble seeing the Quorum resource. Make sure it
can view all the resources.
> We've tried using the Administrator account to start the server, but with
> the same results.
> The cluster service is fine on node 1.
> What can I try to do in order to get the service to start?
> Thanks,
> Chris
O/S is 2003, with SQL 2000. The 2nd node is passive, and appears to join the
cluster but then it terminates unexpectedly.
We've tried using the Administrator account to start the server, but with
the same results.
The cluster service is fine on node 1.
What can I try to do in order to get the service to start?
Thanks,
Chris
"Chris" <Chris@.discussions.microsoft.com> wrote in message
news:7FE6F3AD-B838-414C-B216-D0CC84AE28F0@.microsoft.com...
> I'm not able to start the cluster service on the 2nd node of our cluster.
> O/S is 2003, with SQL 2000. The 2nd node is passive, and appears to join
the
> cluster but then it terminates unexpectedly.
>
My guess is it's having trouble seeing the Quorum resource. Make sure it
can view all the resources.
> We've tried using the Administrator account to start the server, but with
> the same results.
> The cluster service is fine on node 1.
> What can I try to do in order to get the service to start?
> Thanks,
> Chris
Cluster problems?
Every now and then (about once a week) our SQL server cluster
(active/passive) becomes unresponsive, and the following events are logged:
Type: Error
Event ID: 17052
Source: MSSQLSERVER
User: N/A
Generated: 8/7/2005 7:58:33 AM
Category: Failover
Message: [sqsrvres] CheckQueryProcessorAlive: sqlexecdirect failed
Data: 9C 42 00 40 01 00 00 00 0B 00 00 00 44 00 41 00 54 00 41 00 42 00 41
00 53 00 45 00 30 00 31 00 00 00 00 00 00 00
Type: Error
Event ID: 17052
Source: MSSQLSERVER
User: N/A
Generated: 8/7/2005 7:58:33 AM
Category: Failover
Message: [sqsrvres] printODBCError: sqlstate = HYT00; native error = 0;
message = [Microsoft][ODBC SQL Server Driver]Timeout expired
Data: 9C 42 00 40 01 00 00 00 0B 00 00 00 44 00 41 00 54 00 41 00 42 00 41
00 53 00 45 00 30 00 31 00 00 00 00 00 00 00
Type: Error
Event ID: 17052
Source: MSSQLSERVER
User: N/A
Generated: 8/7/2005 7:58:33 AM
Category: Failover
Message: [sqsrvres] OnlineThread: QP is not online.
Data: 9C 42 00 40 01 00 00 00 0B 00 00 00 44 00 41 00 54 00 41 00 42 00 41
00 53 00 45 00 30 00 31 00 00 00 00 00 00 00
SQL server errorlog contains these errors:
2005-08-07 07:52:16 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE HYT00]
2005-08-07 07:52:16 - ! [382] Logon to server '(local)' failed (JobManager)
2005-08-07 07:52:19 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE HYT00]
2005-08-07 07:52:19 - ! [382] Logon to server '(local)' failed (JobManager)
2005-08-07 07:53:27 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE HYT00]
2005-08-07 07:53:27 - ! [382] Logon to server '(local)' failed (JobManager)
2005-08-07 07:53:47 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE HYT00]
2005-08-07 07:53:47 - ! [382] Logon to server '(local)' failed (JobManager)
2005-08-07 07:54:27 - ! [298] SQLServer Error: 11, General network error.
Check your network documentation. [SQLSTATE 08001]
2005-08-07 07:54:27 - ! [298] SQLServer Error: 65534, ConnectionOpen
(PreLoginHandshake()). [SQLSTATE 01000]
2005-08-07 07:54:27 - ! [382] Logon to server '(local)' failed (JobManager)
2005-08-07 07:54:27 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE HYT00]
2005-08-07 07:54:27 - ! [382] Logon to server '(local)' failed (JobManager)
2005-08-07 07:55:05 - ! [298] SQLServer Error: 11, General network error.
Check your network documentation. [SQLSTATE 08001]
2005-08-07 07:55:05 - ! [298] SQLServer Error: 65534, ConnectionOpen
(PreLoginHandshake()). [SQLSTATE 01000]
2005-08-07 07:57:03 - ! [298] SQLServer Error: 11, General network error.
Check your network documentation. [SQLSTATE 08001]
2005-08-07 07:57:03 - ! [298] SQLServer Error: 65534, ConnectionOpen
(PreLoginHandshake()). [SQLSTATE 01000]
2005-08-07 07:57:03 - ! [382] Logon to server '(local)' failed (JobManager)
During this time, connections are terminated and SQL server does not allow
legitimate accounts to log in. it last for a couple of minutes. The server is
clearly not overloaded, and it doesn't have any specific jobs or anything to
do at this time. I would like to exclude network problems too, because the
machine is otherwise responsive and fine. it's just the SQL server service
that seems to "take a nap". Has anyone seen this before? Win2k3 Ent, SQL 2000
Ent.
thanks
> that seems to "take a nap". Has anyone seen this before? Win2k3 Ent, SQL
2000
> Ent.
I forgot one thing, Win2k3 has SP1, and SQL server has SP3 applied.
- Gabor
sqlsql
(active/passive) becomes unresponsive, and the following events are logged:
Type: Error
Event ID: 17052
Source: MSSQLSERVER
User: N/A
Generated: 8/7/2005 7:58:33 AM
Category: Failover
Message: [sqsrvres] CheckQueryProcessorAlive: sqlexecdirect failed
Data: 9C 42 00 40 01 00 00 00 0B 00 00 00 44 00 41 00 54 00 41 00 42 00 41
00 53 00 45 00 30 00 31 00 00 00 00 00 00 00
Type: Error
Event ID: 17052
Source: MSSQLSERVER
User: N/A
Generated: 8/7/2005 7:58:33 AM
Category: Failover
Message: [sqsrvres] printODBCError: sqlstate = HYT00; native error = 0;
message = [Microsoft][ODBC SQL Server Driver]Timeout expired
Data: 9C 42 00 40 01 00 00 00 0B 00 00 00 44 00 41 00 54 00 41 00 42 00 41
00 53 00 45 00 30 00 31 00 00 00 00 00 00 00
Type: Error
Event ID: 17052
Source: MSSQLSERVER
User: N/A
Generated: 8/7/2005 7:58:33 AM
Category: Failover
Message: [sqsrvres] OnlineThread: QP is not online.
Data: 9C 42 00 40 01 00 00 00 0B 00 00 00 44 00 41 00 54 00 41 00 42 00 41
00 53 00 45 00 30 00 31 00 00 00 00 00 00 00
SQL server errorlog contains these errors:
2005-08-07 07:52:16 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE HYT00]
2005-08-07 07:52:16 - ! [382] Logon to server '(local)' failed (JobManager)
2005-08-07 07:52:19 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE HYT00]
2005-08-07 07:52:19 - ! [382] Logon to server '(local)' failed (JobManager)
2005-08-07 07:53:27 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE HYT00]
2005-08-07 07:53:27 - ! [382] Logon to server '(local)' failed (JobManager)
2005-08-07 07:53:47 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE HYT00]
2005-08-07 07:53:47 - ! [382] Logon to server '(local)' failed (JobManager)
2005-08-07 07:54:27 - ! [298] SQLServer Error: 11, General network error.
Check your network documentation. [SQLSTATE 08001]
2005-08-07 07:54:27 - ! [298] SQLServer Error: 65534, ConnectionOpen
(PreLoginHandshake()). [SQLSTATE 01000]
2005-08-07 07:54:27 - ! [382] Logon to server '(local)' failed (JobManager)
2005-08-07 07:54:27 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE HYT00]
2005-08-07 07:54:27 - ! [382] Logon to server '(local)' failed (JobManager)
2005-08-07 07:55:05 - ! [298] SQLServer Error: 11, General network error.
Check your network documentation. [SQLSTATE 08001]
2005-08-07 07:55:05 - ! [298] SQLServer Error: 65534, ConnectionOpen
(PreLoginHandshake()). [SQLSTATE 01000]
2005-08-07 07:57:03 - ! [298] SQLServer Error: 11, General network error.
Check your network documentation. [SQLSTATE 08001]
2005-08-07 07:57:03 - ! [298] SQLServer Error: 65534, ConnectionOpen
(PreLoginHandshake()). [SQLSTATE 01000]
2005-08-07 07:57:03 - ! [382] Logon to server '(local)' failed (JobManager)
During this time, connections are terminated and SQL server does not allow
legitimate accounts to log in. it last for a couple of minutes. The server is
clearly not overloaded, and it doesn't have any specific jobs or anything to
do at this time. I would like to exclude network problems too, because the
machine is otherwise responsive and fine. it's just the SQL server service
that seems to "take a nap". Has anyone seen this before? Win2k3 Ent, SQL 2000
Ent.
thanks
> that seems to "take a nap". Has anyone seen this before? Win2k3 Ent, SQL
2000
> Ent.
I forgot one thing, Win2k3 has SP1, and SQL server has SP3 applied.
- Gabor
sqlsql
Cluster problems?
Every now and then (about once a week) our SQL server cluster
(active/passive) becomes unresponsive, and the following events are logged:
Type: Error
Event ID: 17052
Source: MSSQLSERVER
User: N/A
Generated: 8/7/2005 7:58:33 AM
Category: Failover
Message: [sqsrvres] CheckQueryProcessorAlive: sqlexecdirect failed
Data: 9C 42 00 40 01 00 00 00 0B 00 00 00 44 00 41 00 54 00 41 00 42 00 41
00 53 00 45 00 30 00 31 00 00 00 00 00 00 00
Type: Error
Event ID: 17052
Source: MSSQLSERVER
User: N/A
Generated: 8/7/2005 7:58:33 AM
Category: Failover
Message: [sqsrvres] printODBCError: sqlstate = HYT00; native error = 0;
message = [Microsoft][ODBC SQL Server Driver]Timeout expired
Data: 9C 42 00 40 01 00 00 00 0B 00 00 00 44 00 41 00 54 00 41 00 42 00 41
00 53 00 45 00 30 00 31 00 00 00 00 00 00 00
Type: Error
Event ID: 17052
Source: MSSQLSERVER
User: N/A
Generated: 8/7/2005 7:58:33 AM
Category: Failover
Message: [sqsrvres] OnlineThread: QP is not online.
Data: 9C 42 00 40 01 00 00 00 0B 00 00 00 44 00 41 00 54 00 41 00 42 00 41
00 53 00 45 00 30 00 31 00 00 00 00 00 00 00
SQL server errorlog contains these errors:
2005-08-07 07:52:16 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE HYT00]
2005-08-07 07:52:16 - ! [382] Logon to server '(local)' failed (JobManager)
2005-08-07 07:52:19 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE HYT00]
2005-08-07 07:52:19 - ! [382] Logon to server '(local)' failed (JobManager)
2005-08-07 07:53:27 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE HYT00]
2005-08-07 07:53:27 - ! [382] Logon to server '(local)' failed (JobManager)
2005-08-07 07:53:47 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE HYT00]
2005-08-07 07:53:47 - ! [382] Logon to server '(local)' failed (JobManager)
2005-08-07 07:54:27 - ! [298] SQLServer Error: 11, General network error.
Check your network documentation. [SQLSTATE 08001]
2005-08-07 07:54:27 - ! [298] SQLServer Error: 65534, ConnectionOpen
(PreLoginHandshake()). [SQLSTATE 01000]
2005-08-07 07:54:27 - ! [382] Logon to server '(local)' failed (JobManager)
2005-08-07 07:54:27 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE HYT00]
2005-08-07 07:54:27 - ! [382] Logon to server '(local)' failed (JobManager)
2005-08-07 07:55:05 - ! [298] SQLServer Error: 11, General network error.
Check your network documentation. [SQLSTATE 08001]
2005-08-07 07:55:05 - ! [298] SQLServer Error: 65534, ConnectionOpen
(PreLoginHandshake()). [SQLSTATE 01000]
2005-08-07 07:57:03 - ! [298] SQLServer Error: 11, General network error.
Check your network documentation. [SQLSTATE 08001]
2005-08-07 07:57:03 - ! [298] SQLServer Error: 65534, ConnectionOpen
(PreLoginHandshake()). [SQLSTATE 01000]
2005-08-07 07:57:03 - ! [382] Logon to server '(local)' failed (JobManager)
During this time, connections are terminated and SQL server does not allow
legitimate accounts to log in. it last for a couple of minutes. The server is
clearly not overloaded, and it doesn't have any specific jobs or anything to
do at this time. I would like to exclude network problems too, because the
machine is otherwise responsive and fine. it's just the SQL server service
that seems to "take a nap". Has anyone seen this before? Win2k3 Ent, SQL 2000
Ent.
thanks> that seems to "take a nap". Has anyone seen this before? Win2k3 Ent, SQL
2000
> Ent.
I forgot one thing, Win2k3 has SP1, and SQL server has SP3 applied.
- Gabor
(active/passive) becomes unresponsive, and the following events are logged:
Type: Error
Event ID: 17052
Source: MSSQLSERVER
User: N/A
Generated: 8/7/2005 7:58:33 AM
Category: Failover
Message: [sqsrvres] CheckQueryProcessorAlive: sqlexecdirect failed
Data: 9C 42 00 40 01 00 00 00 0B 00 00 00 44 00 41 00 54 00 41 00 42 00 41
00 53 00 45 00 30 00 31 00 00 00 00 00 00 00
Type: Error
Event ID: 17052
Source: MSSQLSERVER
User: N/A
Generated: 8/7/2005 7:58:33 AM
Category: Failover
Message: [sqsrvres] printODBCError: sqlstate = HYT00; native error = 0;
message = [Microsoft][ODBC SQL Server Driver]Timeout expired
Data: 9C 42 00 40 01 00 00 00 0B 00 00 00 44 00 41 00 54 00 41 00 42 00 41
00 53 00 45 00 30 00 31 00 00 00 00 00 00 00
Type: Error
Event ID: 17052
Source: MSSQLSERVER
User: N/A
Generated: 8/7/2005 7:58:33 AM
Category: Failover
Message: [sqsrvres] OnlineThread: QP is not online.
Data: 9C 42 00 40 01 00 00 00 0B 00 00 00 44 00 41 00 54 00 41 00 42 00 41
00 53 00 45 00 30 00 31 00 00 00 00 00 00 00
SQL server errorlog contains these errors:
2005-08-07 07:52:16 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE HYT00]
2005-08-07 07:52:16 - ! [382] Logon to server '(local)' failed (JobManager)
2005-08-07 07:52:19 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE HYT00]
2005-08-07 07:52:19 - ! [382] Logon to server '(local)' failed (JobManager)
2005-08-07 07:53:27 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE HYT00]
2005-08-07 07:53:27 - ! [382] Logon to server '(local)' failed (JobManager)
2005-08-07 07:53:47 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE HYT00]
2005-08-07 07:53:47 - ! [382] Logon to server '(local)' failed (JobManager)
2005-08-07 07:54:27 - ! [298] SQLServer Error: 11, General network error.
Check your network documentation. [SQLSTATE 08001]
2005-08-07 07:54:27 - ! [298] SQLServer Error: 65534, ConnectionOpen
(PreLoginHandshake()). [SQLSTATE 01000]
2005-08-07 07:54:27 - ! [382] Logon to server '(local)' failed (JobManager)
2005-08-07 07:54:27 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE HYT00]
2005-08-07 07:54:27 - ! [382] Logon to server '(local)' failed (JobManager)
2005-08-07 07:55:05 - ! [298] SQLServer Error: 11, General network error.
Check your network documentation. [SQLSTATE 08001]
2005-08-07 07:55:05 - ! [298] SQLServer Error: 65534, ConnectionOpen
(PreLoginHandshake()). [SQLSTATE 01000]
2005-08-07 07:57:03 - ! [298] SQLServer Error: 11, General network error.
Check your network documentation. [SQLSTATE 08001]
2005-08-07 07:57:03 - ! [298] SQLServer Error: 65534, ConnectionOpen
(PreLoginHandshake()). [SQLSTATE 01000]
2005-08-07 07:57:03 - ! [382] Logon to server '(local)' failed (JobManager)
During this time, connections are terminated and SQL server does not allow
legitimate accounts to log in. it last for a couple of minutes. The server is
clearly not overloaded, and it doesn't have any specific jobs or anything to
do at this time. I would like to exclude network problems too, because the
machine is otherwise responsive and fine. it's just the SQL server service
that seems to "take a nap". Has anyone seen this before? Win2k3 Ent, SQL 2000
Ent.
thanks> that seems to "take a nap". Has anyone seen this before? Win2k3 Ent, SQL
2000
> Ent.
I forgot one thing, Win2k3 has SP1, and SQL server has SP3 applied.
- Gabor
Cluster problems?
Every now and then (about once a week) our SQL server cluster
(active/passive) becomes unresponsive, and the following events are logged:
Type: Error
Event ID: 17052
Source: MSSQLSERVER
User: N/A
Generated: 8/7/2005 7:58:33 AM
Category: Failover
Message: [sqsrvres] CheckQueryProcessorAlive: sqlexecdirect failed
Data: 9C 42 00 40 01 00 00 00 0B 00 00 00 44 00 41 00 54 00 41 00 42 00 41
00 53 00 45 00 30 00 31 00 00 00 00 00 00 00
Type: Error
Event ID: 17052
Source: MSSQLSERVER
User: N/A
Generated: 8/7/2005 7:58:33 AM
Category: Failover
Message: [sqsrvres] printODBCError: sqlstate = HYT00; native error = 0;
message = [Microsoft][ODBC SQL Server Driver]Timeout expired
Data: 9C 42 00 40 01 00 00 00 0B 00 00 00 44 00 41 00 54 00 41 00 42 00 41
00 53 00 45 00 30 00 31 00 00 00 00 00 00 00
Type: Error
Event ID: 17052
Source: MSSQLSERVER
User: N/A
Generated: 8/7/2005 7:58:33 AM
Category: Failover
Message: [sqsrvres] OnlineThread: QP is not online.
Data: 9C 42 00 40 01 00 00 00 0B 00 00 00 44 00 41 00 54 00 41 00 42 00 41
00 53 00 45 00 30 00 31 00 00 00 00 00 00 00
SQL server errorlog contains these errors:
2005-08-07 07:52:16 - ! [165] ODBC Error: 0, Timeout expired [SQLSTA
TE HYT00]
2005-08-07 07:52:16 - ! [382] Logon to server '(local)' failed (JobManag
er)
2005-08-07 07:52:19 - ! [165] ODBC Error: 0, Timeout expired [SQLSTA
TE HYT00]
2005-08-07 07:52:19 - ! [382] Logon to server '(local)' failed (JobManag
er)
2005-08-07 07:53:27 - ! [165] ODBC Error: 0, Timeout expired [SQLSTA
TE HYT00]
2005-08-07 07:53:27 - ! [382] Logon to server '(local)' failed (JobManag
er)
2005-08-07 07:53:47 - ! [165] ODBC Error: 0, Timeout expired [SQLSTA
TE HYT00]
2005-08-07 07:53:47 - ! [382] Logon to server '(local)' failed (JobManag
er)
2005-08-07 07:54:27 - ! [298] SQLServer Error: 11, General network error
.
Check your network documentation. [SQLSTATE 08001]
2005-08-07 07:54:27 - ! [298] SQLServer Error: 65534, ConnectionOpen
(PreLoginHandshake()). [SQLSTATE 01000]
2005-08-07 07:54:27 - ! [382] Logon to server '(local)' failed (JobManag
er)
2005-08-07 07:54:27 - ! [165] ODBC Error: 0, Timeout expired [SQLSTA
TE HYT00]
2005-08-07 07:54:27 - ! [382] Logon to server '(local)' failed (JobManag
er)
2005-08-07 07:55:05 - ! [298] SQLServer Error: 11, General network error
.
Check your network documentation. [SQLSTATE 08001]
2005-08-07 07:55:05 - ! [298] SQLServer Error: 65534, ConnectionOpen
(PreLoginHandshake()). [SQLSTATE 01000]
2005-08-07 07:57:03 - ! [298] SQLServer Error: 11, General network error
.
Check your network documentation. [SQLSTATE 08001]
2005-08-07 07:57:03 - ! [298] SQLServer Error: 65534, ConnectionOpen
(PreLoginHandshake()). [SQLSTATE 01000]
2005-08-07 07:57:03 - ! [382] Logon to server '(local)' failed (JobManag
er)
During this time, connections are terminated and SQL server does not allow
legitimate accounts to log in. it last for a couple of minutes. The server i
s
clearly not overloaded, and it doesn't have any specific jobs or anything to
do at this time. I would like to exclude network problems too, because the
machine is otherwise responsive and fine. it's just the SQL server service
that seems to "take a nap". Has anyone seen this before? Win2k3 Ent, SQL 200
0
Ent.
thanks> that seems to "take a nap". Has anyone seen this before? Win2k3 Ent, SQL
2000
> Ent.
I forgot one thing, Win2k3 has SP1, and SQL server has SP3 applied.
- Gabor
(active/passive) becomes unresponsive, and the following events are logged:
Type: Error
Event ID: 17052
Source: MSSQLSERVER
User: N/A
Generated: 8/7/2005 7:58:33 AM
Category: Failover
Message: [sqsrvres] CheckQueryProcessorAlive: sqlexecdirect failed
Data: 9C 42 00 40 01 00 00 00 0B 00 00 00 44 00 41 00 54 00 41 00 42 00 41
00 53 00 45 00 30 00 31 00 00 00 00 00 00 00
Type: Error
Event ID: 17052
Source: MSSQLSERVER
User: N/A
Generated: 8/7/2005 7:58:33 AM
Category: Failover
Message: [sqsrvres] printODBCError: sqlstate = HYT00; native error = 0;
message = [Microsoft][ODBC SQL Server Driver]Timeout expired
Data: 9C 42 00 40 01 00 00 00 0B 00 00 00 44 00 41 00 54 00 41 00 42 00 41
00 53 00 45 00 30 00 31 00 00 00 00 00 00 00
Type: Error
Event ID: 17052
Source: MSSQLSERVER
User: N/A
Generated: 8/7/2005 7:58:33 AM
Category: Failover
Message: [sqsrvres] OnlineThread: QP is not online.
Data: 9C 42 00 40 01 00 00 00 0B 00 00 00 44 00 41 00 54 00 41 00 42 00 41
00 53 00 45 00 30 00 31 00 00 00 00 00 00 00
SQL server errorlog contains these errors:
2005-08-07 07:52:16 - ! [165] ODBC Error: 0, Timeout expired [SQLSTA
TE HYT00]
2005-08-07 07:52:16 - ! [382] Logon to server '(local)' failed (JobManag
er)
2005-08-07 07:52:19 - ! [165] ODBC Error: 0, Timeout expired [SQLSTA
TE HYT00]
2005-08-07 07:52:19 - ! [382] Logon to server '(local)' failed (JobManag
er)
2005-08-07 07:53:27 - ! [165] ODBC Error: 0, Timeout expired [SQLSTA
TE HYT00]
2005-08-07 07:53:27 - ! [382] Logon to server '(local)' failed (JobManag
er)
2005-08-07 07:53:47 - ! [165] ODBC Error: 0, Timeout expired [SQLSTA
TE HYT00]
2005-08-07 07:53:47 - ! [382] Logon to server '(local)' failed (JobManag
er)
2005-08-07 07:54:27 - ! [298] SQLServer Error: 11, General network error
.
Check your network documentation. [SQLSTATE 08001]
2005-08-07 07:54:27 - ! [298] SQLServer Error: 65534, ConnectionOpen
(PreLoginHandshake()). [SQLSTATE 01000]
2005-08-07 07:54:27 - ! [382] Logon to server '(local)' failed (JobManag
er)
2005-08-07 07:54:27 - ! [165] ODBC Error: 0, Timeout expired [SQLSTA
TE HYT00]
2005-08-07 07:54:27 - ! [382] Logon to server '(local)' failed (JobManag
er)
2005-08-07 07:55:05 - ! [298] SQLServer Error: 11, General network error
.
Check your network documentation. [SQLSTATE 08001]
2005-08-07 07:55:05 - ! [298] SQLServer Error: 65534, ConnectionOpen
(PreLoginHandshake()). [SQLSTATE 01000]
2005-08-07 07:57:03 - ! [298] SQLServer Error: 11, General network error
.
Check your network documentation. [SQLSTATE 08001]
2005-08-07 07:57:03 - ! [298] SQLServer Error: 65534, ConnectionOpen
(PreLoginHandshake()). [SQLSTATE 01000]
2005-08-07 07:57:03 - ! [382] Logon to server '(local)' failed (JobManag
er)
During this time, connections are terminated and SQL server does not allow
legitimate accounts to log in. it last for a couple of minutes. The server i
s
clearly not overloaded, and it doesn't have any specific jobs or anything to
do at this time. I would like to exclude network problems too, because the
machine is otherwise responsive and fine. it's just the SQL server service
that seems to "take a nap". Has anyone seen this before? Win2k3 Ent, SQL 200
0
Ent.
thanks> that seems to "take a nap". Has anyone seen this before? Win2k3 Ent, SQL
2000
> Ent.
I forgot one thing, Win2k3 has SP1, and SQL server has SP3 applied.
- Gabor
CLuster problem
Hi,
I realized an active/passive Windows Cluster from two IBM xSeries346 with
Windows 2003 Enterprise Edition SP1 (patched..) and I use like a shared disk
an IBM EXP400 (certified..).
When Active server go down, passive server can't do automatically the
failover, the second server can't see shared disks..
any help?
thank's a lot
andrea
I can't tell you specifically what, but I recently heard of an issue where
teh drive letters for the shared droves were not "configured" correctly in
the SAN utilities.
Does the group go to the passive node and just sit there, or does it fail
back to the original active node? If on the Passive node, can you see the
drive in "My Computer"?
"Andrea Racca" wrote:
> Hi,
> I realized an active/passive Windows Cluster from two IBM xSeries346 with
> Windows 2003 Enterprise Edition SP1 (patched..) and I use like a shared disk
> an IBM EXP400 (certified..).
> When Active server go down, passive server can't do automatically the
> failover, the second server can't see shared disks..
> any help?
> thank's a lot
> andrea
>
>
sqlsql
I realized an active/passive Windows Cluster from two IBM xSeries346 with
Windows 2003 Enterprise Edition SP1 (patched..) and I use like a shared disk
an IBM EXP400 (certified..).
When Active server go down, passive server can't do automatically the
failover, the second server can't see shared disks..
any help?
thank's a lot
andrea
I can't tell you specifically what, but I recently heard of an issue where
teh drive letters for the shared droves were not "configured" correctly in
the SAN utilities.
Does the group go to the passive node and just sit there, or does it fail
back to the original active node? If on the Passive node, can you see the
drive in "My Computer"?
"Andrea Racca" wrote:
> Hi,
> I realized an active/passive Windows Cluster from two IBM xSeries346 with
> Windows 2003 Enterprise Edition SP1 (patched..) and I use like a shared disk
> an IBM EXP400 (certified..).
> When Active server go down, passive server can't do automatically the
> failover, the second server can't see shared disks..
> any help?
> thank's a lot
> andrea
>
>
sqlsql
Sunday, March 25, 2012
Cluster name with multiple IP addresses?
Can multiple IP addresses be assigned to a cluster and/or virtual name?
I have a 2-node Active/Passive cluster on a switched (not routed) network.
Each node has 3 NICs, each on its own subnet;
a) public/client access - 192.168.10.0
b) private/cluster traffic - 10.0.0.0
c) data backup network - 192.168.20.0
The cluster name "SQLCLST" and the virtual machine name "SQLSVR" have been
defined with IP addresses on the public/client network.
My backup software is cluster aware but because the traffic is separated via
switched network, I need the cluster and/or virtual machine name to respond
to IP addresses on two different subnets. Is this possible? Did this make
sense? ;)
TIA
It is not an uncommon request, nor is it too difficult. Once you have the
NICs and networks defined in the cluser configuration, you run the SQL setup
wizard to add the networks to SQL Server. To use them effectively, look
into connection-specific suffixes. That way you can force traffic to a
particular network.
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP
"Structured Chaos" <jeffery_tyree@.yahoo.com> wrote in message
news:%23Y%23s8Mv0HHA.5380@.TK2MSFTNGP04.phx.gbl...
> Can multiple IP addresses be assigned to a cluster and/or virtual name?
> I have a 2-node Active/Passive cluster on a switched (not routed) network.
> Each node has 3 NICs, each on its own subnet;
> a) public/client access - 192.168.10.0
> b) private/cluster traffic - 10.0.0.0
> c) data backup network - 192.168.20.0
> The cluster name "SQLCLST" and the virtual machine name "SQLSVR" have been
> defined with IP addresses on the public/client network.
> My backup software is cluster aware but because the traffic is separated
> via switched network, I need the cluster and/or virtual machine name to
> respond to IP addresses on two different subnets. Is this possible? Did
> this make sense? ;)
> TIA
>
|||Thanks for the quick info. Apparently it is a little more difficult than
that, heheh
I did not see any dialog/screen that allowed for the addition of new
network - only to modify node membership.
I have a ticket opened with MS. They have escalated it stating that they
don't even know if SQL will support this configuration and are attempting to
duplicate it in their labs. The MS SQL Data Engine Team manager stated they
may even have to look at the code...
Should you happen to have any detailed steps on making this work, I'd
appreciate it and apparently MS would too! LOL
"Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
news:OQYwDPx0HHA.1184@.TK2MSFTNGP04.phx.gbl...
> It is not an uncommon request, nor is it too difficult. Once you have the
> NICs and networks defined in the cluser configuration, you run the SQL
> setup wizard to add the networks to SQL Server. To use them effectively,
> look into connection-specific suffixes. That way you can force traffic to
> a particular network.
> --
> Geoff N. Hiten
> Senior SQL Infrastructure Consultant
> Microsoft SQL Server MVP
>
>
> "Structured Chaos" <jeffery_tyree@.yahoo.com> wrote in message
> news:%23Y%23s8Mv0HHA.5380@.TK2MSFTNGP04.phx.gbl...
>
|||OK, you are not trying to stack multiple IP addresses on a single NIC, you
are using a unique IP address for each NIC. That isn't a problem.
The problem comes from having the same DNS alias (network name) respond on
two different subnets. That is a networking issue, not a clustering issue.
I would use connection-specific domain suffixes to differentiate the
networks. Also, I would use DNS SRV records to abstract the names. I.E.
MySQLCluster points to the IP and port of the normal public NIC.
MySQLClusterBackup points to the IP and port on the backup LAN.
I have used this setup in the past and it works just fine.
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP
"Structured Chaos" <jeffery_tyree@.yahoo.com> wrote in message
news:Ooh45iT2HHA.2752@.TK2MSFTNGP06.phx.gbl...
> Thanks for the quick info. Apparently it is a little more difficult than
> that, heheh
> I did not see any dialog/screen that allowed for the addition of new
> network - only to modify node membership.
> I have a ticket opened with MS. They have escalated it stating that they
> don't even know if SQL will support this configuration and are attempting
> to duplicate it in their labs. The MS SQL Data Engine Team manager stated
> they may even have to look at the code...
> Should you happen to have any detailed steps on making this work, I'd
> appreciate it and apparently MS would too! LOL
>
> "Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
> news:OQYwDPx0HHA.1184@.TK2MSFTNGP04.phx.gbl...
>
I have a 2-node Active/Passive cluster on a switched (not routed) network.
Each node has 3 NICs, each on its own subnet;
a) public/client access - 192.168.10.0
b) private/cluster traffic - 10.0.0.0
c) data backup network - 192.168.20.0
The cluster name "SQLCLST" and the virtual machine name "SQLSVR" have been
defined with IP addresses on the public/client network.
My backup software is cluster aware but because the traffic is separated via
switched network, I need the cluster and/or virtual machine name to respond
to IP addresses on two different subnets. Is this possible? Did this make
sense? ;)
TIA
It is not an uncommon request, nor is it too difficult. Once you have the
NICs and networks defined in the cluser configuration, you run the SQL setup
wizard to add the networks to SQL Server. To use them effectively, look
into connection-specific suffixes. That way you can force traffic to a
particular network.
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP
"Structured Chaos" <jeffery_tyree@.yahoo.com> wrote in message
news:%23Y%23s8Mv0HHA.5380@.TK2MSFTNGP04.phx.gbl...
> Can multiple IP addresses be assigned to a cluster and/or virtual name?
> I have a 2-node Active/Passive cluster on a switched (not routed) network.
> Each node has 3 NICs, each on its own subnet;
> a) public/client access - 192.168.10.0
> b) private/cluster traffic - 10.0.0.0
> c) data backup network - 192.168.20.0
> The cluster name "SQLCLST" and the virtual machine name "SQLSVR" have been
> defined with IP addresses on the public/client network.
> My backup software is cluster aware but because the traffic is separated
> via switched network, I need the cluster and/or virtual machine name to
> respond to IP addresses on two different subnets. Is this possible? Did
> this make sense? ;)
> TIA
>
|||Thanks for the quick info. Apparently it is a little more difficult than
that, heheh
I did not see any dialog/screen that allowed for the addition of new
network - only to modify node membership.
I have a ticket opened with MS. They have escalated it stating that they
don't even know if SQL will support this configuration and are attempting to
duplicate it in their labs. The MS SQL Data Engine Team manager stated they
may even have to look at the code...
Should you happen to have any detailed steps on making this work, I'd
appreciate it and apparently MS would too! LOL
"Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
news:OQYwDPx0HHA.1184@.TK2MSFTNGP04.phx.gbl...
> It is not an uncommon request, nor is it too difficult. Once you have the
> NICs and networks defined in the cluser configuration, you run the SQL
> setup wizard to add the networks to SQL Server. To use them effectively,
> look into connection-specific suffixes. That way you can force traffic to
> a particular network.
> --
> Geoff N. Hiten
> Senior SQL Infrastructure Consultant
> Microsoft SQL Server MVP
>
>
> "Structured Chaos" <jeffery_tyree@.yahoo.com> wrote in message
> news:%23Y%23s8Mv0HHA.5380@.TK2MSFTNGP04.phx.gbl...
>
|||OK, you are not trying to stack multiple IP addresses on a single NIC, you
are using a unique IP address for each NIC. That isn't a problem.
The problem comes from having the same DNS alias (network name) respond on
two different subnets. That is a networking issue, not a clustering issue.
I would use connection-specific domain suffixes to differentiate the
networks. Also, I would use DNS SRV records to abstract the names. I.E.
MySQLCluster points to the IP and port of the normal public NIC.
MySQLClusterBackup points to the IP and port on the backup LAN.
I have used this setup in the past and it works just fine.
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP
"Structured Chaos" <jeffery_tyree@.yahoo.com> wrote in message
news:Ooh45iT2HHA.2752@.TK2MSFTNGP06.phx.gbl...
> Thanks for the quick info. Apparently it is a little more difficult than
> that, heheh
> I did not see any dialog/screen that allowed for the addition of new
> network - only to modify node membership.
> I have a ticket opened with MS. They have escalated it stating that they
> don't even know if SQL will support this configuration and are attempting
> to duplicate it in their labs. The MS SQL Data Engine Team manager stated
> they may even have to look at the code...
> Should you happen to have any detailed steps on making this work, I'd
> appreciate it and apparently MS would too! LOL
>
> "Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
> news:OQYwDPx0HHA.1184@.TK2MSFTNGP04.phx.gbl...
>
Cluster licencing
I have a question regarding licencing on a sql server active/passive cluster. If we have more than 1 instance of the sql server do we have to have to buy another licence for each additional instance?
A Single-instance cluster requires licensing for a single host node.
Multi-instance clustering requires licensing for all host nodes. I am
assuming you are licensing per-processor.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Robert" <anonymous@.discussions.microsoft.com> wrote in message
news:B92B51F4-2C4F-4A66-B53D-1DCAE282D8D8@.microsoft.com...
> I have a question regarding licencing on a sql server active/passive
cluster. If we have more than 1 instance of the sql server do we have to
have to buy another licence for each additional instance?
|||So is it true to say.
Server based license
If you have Active/Passive, and you have 4 instances, each in it's own cluster group, but on the same two nodes, you have to purchase 4 sets licenses. One for each instance.
I thought (from reading the 6.5 and 7.0 documentation) that you licensed the node, and in a 2 node cluster, regardless of active/passive or active/active you'd need to purchase 2 licenses (+ relevant CALs).
However, according to a Microsoft consultance (who's gone away to confirm) you only need to buy the license for the active node.
Sorry if this adds to the confusion.
|||Since you are clustering, you need Enterprise Edition. EE license allows
multiple instances on a host computer for the same processor license. The
exception for a licensing is when you are in single-instance cluster. Then
you only need to license one hose node's worth of processors. If you have
more than one instance, you must license ALL processors in the cluster.
Again, check with your local MS rep to get the exact wording.
(If you think this is confusing, you should try to figure out MSDE and
client tools licensing.)
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Beverley" <Bev.Brindle@.barclays.co.uk> wrote in message
news:8C12096A-8761-4589-82A3-C8B1E360E2B2@.microsoft.com...
> So is it true to say.
> Server based license
> If you have Active/Passive, and you have 4 instances, each in it's own
cluster group, but on the same two nodes, you have to purchase 4 sets
licenses. One for each instance.
> I thought (from reading the 6.5 and 7.0 documentation) that you licensed
the node, and in a 2 node cluster, regardless of active/passive or
active/active you'd need to purchase 2 licenses (+ relevant CALs).
> However, according to a Microsoft consultance (who's gone away to confirm)
you only need to buy the license for the active node.
> Sorry if this adds to the confusion.
|||Sorry to keep going on about this, but were putting strategic infrastructure in place, and I want to make sure that we are adequatley licensed.
So with clustering can you use EE Server License, or is Processor License compulsory.
And if EE Server Based is OK, does it apply to each instance (e.g. Server License x No Instances)
Im differentiating between Server and Processor on the basis that if your using Server you have to purchase CALs, but not if your using Processor.
We've purchased 60,000 CALs, so were going to use Server for all SQL unless its userbase is WWW based. What would we need to do for clustered SQL? We're intending a maxumim of 4 instances per cluster, over a 2 node active / passive cluster.
|||Again, the answer is "It Depends". You can use EE Server based with either
device or user CALs. EE allows multiple instances on a single host with one
license. The 'single-instance cluster exception' is actually a grant to use
the licenses on a failover node at no additional charge.
Here is an excerpt from the SQL licensing FAQ that seems to apply:
--snip--
Q. How does licensing work for computers that run SQL Server 2000
Enterprise Edition in failover scenarios?
A. Failover support, where servers are clustered together and set to
pick up each others' processing duties if one computer should fail, is
available only in SQL Server 2000 Enterprise Edition, just as it was with
SQL Server 7.0. Failover support can be configured in one of two ways:
a.. Active/active. In the active/active configuration, all servers
in the cluster regularly process information, but one or more take on the
workload of a failed server.
b.. Active/passive. In the active/passive configuration, one or more
computers in the cluster do not regularly process information but rather
passively wait to pick up the workload when an active server fails. All
active servers in a cluster must be fully licensed, according to either the
Per Processor licensing model or the Server/CAL licensing model. However, if
a server is strictly passive, working only while an active server has
failed, no additional licenses are needed for that passive server. The only
exception to this rule is if the cluster is licensed using Processor
licenses and the number of processors on the passive server exceeds the
number of processors on the active server. In these cases, additional
Processor licenses must be purchased for the additional processors on the
passive server.
--snip--
You can read the entire FAQ here:
http://www.microsoft.com/sql/howtobuy/faq.asp
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Beverley" <Bev.Brindle@.barclays.co.uk> wrote in message
news:AA19071B-9CBD-4B06-97A6-3B692301BF21@.microsoft.com...
> Sorry to keep going on about this, but were putting strategic
infrastructure in place, and I want to make sure that we are adequatley
licensed.
> So with clustering can you use EE Server License, or is Processor License
compulsory.
> And if EE Server Based is OK, does it apply to each instance (e.g. Server
License x No Instances)
> Im differentiating between Server and Processor on the basis that if your
using Server you have to purchase CALs, but not if your using Processor.
> We've purchased 60,000 CALs, so were going to use Server for all SQL
unless its userbase is WWW based. What would we need to do for clustered
SQL? We're intending a maxumim of 4 instances per cluster, over a 2 node
active / passive cluster.
>
begin 666 ts.gif
J1TE&.#EA`0`!`( ``````/___R'Y! $`````+ `````!``$```(!1 `[
`
end
|||Thanks for the clarity
A Single-instance cluster requires licensing for a single host node.
Multi-instance clustering requires licensing for all host nodes. I am
assuming you are licensing per-processor.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Robert" <anonymous@.discussions.microsoft.com> wrote in message
news:B92B51F4-2C4F-4A66-B53D-1DCAE282D8D8@.microsoft.com...
> I have a question regarding licencing on a sql server active/passive
cluster. If we have more than 1 instance of the sql server do we have to
have to buy another licence for each additional instance?
|||So is it true to say.
Server based license
If you have Active/Passive, and you have 4 instances, each in it's own cluster group, but on the same two nodes, you have to purchase 4 sets licenses. One for each instance.
I thought (from reading the 6.5 and 7.0 documentation) that you licensed the node, and in a 2 node cluster, regardless of active/passive or active/active you'd need to purchase 2 licenses (+ relevant CALs).
However, according to a Microsoft consultance (who's gone away to confirm) you only need to buy the license for the active node.
Sorry if this adds to the confusion.
|||Since you are clustering, you need Enterprise Edition. EE license allows
multiple instances on a host computer for the same processor license. The
exception for a licensing is when you are in single-instance cluster. Then
you only need to license one hose node's worth of processors. If you have
more than one instance, you must license ALL processors in the cluster.
Again, check with your local MS rep to get the exact wording.
(If you think this is confusing, you should try to figure out MSDE and
client tools licensing.)
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Beverley" <Bev.Brindle@.barclays.co.uk> wrote in message
news:8C12096A-8761-4589-82A3-C8B1E360E2B2@.microsoft.com...
> So is it true to say.
> Server based license
> If you have Active/Passive, and you have 4 instances, each in it's own
cluster group, but on the same two nodes, you have to purchase 4 sets
licenses. One for each instance.
> I thought (from reading the 6.5 and 7.0 documentation) that you licensed
the node, and in a 2 node cluster, regardless of active/passive or
active/active you'd need to purchase 2 licenses (+ relevant CALs).
> However, according to a Microsoft consultance (who's gone away to confirm)
you only need to buy the license for the active node.
> Sorry if this adds to the confusion.
|||Sorry to keep going on about this, but were putting strategic infrastructure in place, and I want to make sure that we are adequatley licensed.
So with clustering can you use EE Server License, or is Processor License compulsory.
And if EE Server Based is OK, does it apply to each instance (e.g. Server License x No Instances)
Im differentiating between Server and Processor on the basis that if your using Server you have to purchase CALs, but not if your using Processor.
We've purchased 60,000 CALs, so were going to use Server for all SQL unless its userbase is WWW based. What would we need to do for clustered SQL? We're intending a maxumim of 4 instances per cluster, over a 2 node active / passive cluster.
|||Again, the answer is "It Depends". You can use EE Server based with either
device or user CALs. EE allows multiple instances on a single host with one
license. The 'single-instance cluster exception' is actually a grant to use
the licenses on a failover node at no additional charge.
Here is an excerpt from the SQL licensing FAQ that seems to apply:
--snip--
Q. How does licensing work for computers that run SQL Server 2000
Enterprise Edition in failover scenarios?
A. Failover support, where servers are clustered together and set to
pick up each others' processing duties if one computer should fail, is
available only in SQL Server 2000 Enterprise Edition, just as it was with
SQL Server 7.0. Failover support can be configured in one of two ways:
a.. Active/active. In the active/active configuration, all servers
in the cluster regularly process information, but one or more take on the
workload of a failed server.
b.. Active/passive. In the active/passive configuration, one or more
computers in the cluster do not regularly process information but rather
passively wait to pick up the workload when an active server fails. All
active servers in a cluster must be fully licensed, according to either the
Per Processor licensing model or the Server/CAL licensing model. However, if
a server is strictly passive, working only while an active server has
failed, no additional licenses are needed for that passive server. The only
exception to this rule is if the cluster is licensed using Processor
licenses and the number of processors on the passive server exceeds the
number of processors on the active server. In these cases, additional
Processor licenses must be purchased for the additional processors on the
passive server.
--snip--
You can read the entire FAQ here:
http://www.microsoft.com/sql/howtobuy/faq.asp
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Beverley" <Bev.Brindle@.barclays.co.uk> wrote in message
news:AA19071B-9CBD-4B06-97A6-3B692301BF21@.microsoft.com...
> Sorry to keep going on about this, but were putting strategic
infrastructure in place, and I want to make sure that we are adequatley
licensed.
> So with clustering can you use EE Server License, or is Processor License
compulsory.
> And if EE Server Based is OK, does it apply to each instance (e.g. Server
License x No Instances)
> Im differentiating between Server and Processor on the basis that if your
using Server you have to purchase CALs, but not if your using Processor.
> We've purchased 60,000 CALs, so were going to use Server for all SQL
unless its userbase is WWW based. What would we need to do for clustered
SQL? We're intending a maxumim of 4 instances per cluster, over a 2 node
active / passive cluster.
>
begin 666 ts.gif
J1TE&.#EA`0`!`( ``````/___R'Y! $`````+ `````!``$```(!1 `[
`
end
|||Thanks for the clarity
cluster installation.
Hi ,
I have cluster with 2 nodes (sql 2000 on win 2003 ) and i want to install
active/passive configuration .
for that configuration for my understanding i need named instanced let say
SQLPROD and my vitual server name
is SQLPROD so the name instance will be SQLPROD\SQLPROD this is all very
clear but i do not know
which ip address to specifiy in installation of the sql server when he ask
for ip for virtual sql server.
SQLPROD has an ip address
The IP addr will be what you assign it. You can't use an existing IP, don't
try using the Cluster's IP addr, the install won't let you. The IP addr you
assign must also be in the public address subnet for the cluster.
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
http://www.msmvps.com/clustering - Blog
"w2system5" <none@.none.com> wrote in message
news:cpgtcb$cbg$1@.news2.netvision.net.il...
> Hi ,
> I have cluster with 2 nodes (sql 2000 on win 2003 ) and i want to install
> active/passive configuration .
> for that configuration for my understanding i need named instanced let say
> SQLPROD and my vitual server name
> is SQLPROD so the name instance will be SQLPROD\SQLPROD this is all very
> clear but i do not know
> which ip address to specifiy in installation of the sql server when he ask
> for ip for virtual sql server.
> SQLPROD has an ip address
>
|||It's asking for a new IP Address to use for SQL Server. In total you will
need four:
- Physical node A
- Physical node B
- Virtual Cluster
- Virtual SQL
"w2system5" <none@.none.com> wrote in message
news:cpgtcb$cbg$1@.news2.netvision.net.il...
> Hi ,
> I have cluster with 2 nodes (sql 2000 on win 2003 ) and i want to install
> active/passive configuration .
> for that configuration for my understanding i need named instanced let say
> SQLPROD and my vitual server name
> is SQLPROD so the name instance will be SQLPROD\SQLPROD this is all very
> clear but i do not know
> which ip address to specifiy in installation of the sql server when he ask
> for ip for virtual sql server.
> SQLPROD has an ip address
>
|||You will also need a heartbeat IP for each node. This IP can be
whatever you want.
For example:
192.168.1.1 - Node 1 Heartbeat
192.168.1.2 - Node 2 Heartbeat
Thanks,
Peter
On Thu, 13 Jan 2005 11:40:19 -0000, "Christian Bolton [MSFT]"
<christian.online@.microsoft.com> wrote:
>It's asking for a new IP Address to use for SQL Server. In total you will
>need four:
>- Physical node A
>- Physical node B
>- Virtual Cluster
>- Virtual SQL
>"w2system5" <none@.none.com> wrote in message
>news:cpgtcb$cbg$1@.news2.netvision.net.il...
>
I have cluster with 2 nodes (sql 2000 on win 2003 ) and i want to install
active/passive configuration .
for that configuration for my understanding i need named instanced let say
SQLPROD and my vitual server name
is SQLPROD so the name instance will be SQLPROD\SQLPROD this is all very
clear but i do not know
which ip address to specifiy in installation of the sql server when he ask
for ip for virtual sql server.
SQLPROD has an ip address
The IP addr will be what you assign it. You can't use an existing IP, don't
try using the Cluster's IP addr, the install won't let you. The IP addr you
assign must also be in the public address subnet for the cluster.
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
http://www.msmvps.com/clustering - Blog
"w2system5" <none@.none.com> wrote in message
news:cpgtcb$cbg$1@.news2.netvision.net.il...
> Hi ,
> I have cluster with 2 nodes (sql 2000 on win 2003 ) and i want to install
> active/passive configuration .
> for that configuration for my understanding i need named instanced let say
> SQLPROD and my vitual server name
> is SQLPROD so the name instance will be SQLPROD\SQLPROD this is all very
> clear but i do not know
> which ip address to specifiy in installation of the sql server when he ask
> for ip for virtual sql server.
> SQLPROD has an ip address
>
|||It's asking for a new IP Address to use for SQL Server. In total you will
need four:
- Physical node A
- Physical node B
- Virtual Cluster
- Virtual SQL
"w2system5" <none@.none.com> wrote in message
news:cpgtcb$cbg$1@.news2.netvision.net.il...
> Hi ,
> I have cluster with 2 nodes (sql 2000 on win 2003 ) and i want to install
> active/passive configuration .
> for that configuration for my understanding i need named instanced let say
> SQLPROD and my vitual server name
> is SQLPROD so the name instance will be SQLPROD\SQLPROD this is all very
> clear but i do not know
> which ip address to specifiy in installation of the sql server when he ask
> for ip for virtual sql server.
> SQLPROD has an ip address
>
|||You will also need a heartbeat IP for each node. This IP can be
whatever you want.
For example:
192.168.1.1 - Node 1 Heartbeat
192.168.1.2 - Node 2 Heartbeat
Thanks,
Peter
On Thu, 13 Jan 2005 11:40:19 -0000, "Christian Bolton [MSFT]"
<christian.online@.microsoft.com> wrote:
>It's asking for a new IP Address to use for SQL Server. In total you will
>need four:
>- Physical node A
>- Physical node B
>- Virtual Cluster
>- Virtual SQL
>"w2system5" <none@.none.com> wrote in message
>news:cpgtcb$cbg$1@.news2.netvision.net.il...
>
Tuesday, March 20, 2012
Cluster does not restart SQL group after network failure
All,
We have just rebuilt a SQL 7.0/NT cluster with Windows 2003/SQL2000 in an
active/passive configuration using 2 nodes. During the course of testing it
we had a general network failure in which the network was unavailable. The
virtual SQL and Windows IP address resources went down and did not come up
automatically once the network was available again. The nodes are configured
for automatic failback.
I can't imagine that in the 2 1/2 years the original cluster was running
that we never once had the network go down, but I do know that during that
time I never had a outage where I had to manually move the cluster group
(which causes the cluster to re-initialize both resources and brings
everything back to normal).
I'm thinking that maybe I'm missing a dependency somewhere or something's
changed between NT and 2003 that I'm not accounting for. Anyone seen this or
have any tips? Thanks in advance!
-Dan
Nope, that is pretty much expected behavior. The cluster manager will try
and restart the resources on each possible node until the retry count is
exhausted. Unfortunately, until the network resource is restored, no node
has the ability to run the SQL group. With the physical network port
offline, the IP address(es) will not come online. Nothing dependant on them
will come online, including the Network Name and the SQL Server. If the
network comes back before the retry timeout and count is exhausted, the
cluster will bring the system online. Otherwise it stays down.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Dan" <Dan@.discussions.microsoft.com> wrote in message
news:74592016-0B61-4834-8C28-1AD1B864B688@.microsoft.com...
> All,
> We have just rebuilt a SQL 7.0/NT cluster with Windows 2003/SQL2000 in
an
> active/passive configuration using 2 nodes. During the course of testing
it
> we had a general network failure in which the network was unavailable.
The
> virtual SQL and Windows IP address resources went down and did not come up
> automatically once the network was available again. The nodes are
configured
> for automatic failback.
> I can't imagine that in the 2 1/2 years the original cluster was running
> that we never once had the network go down, but I do know that during that
> time I never had a outage where I had to manually move the cluster group
> (which causes the cluster to re-initialize both resources and brings
> everything back to normal).
> I'm thinking that maybe I'm missing a dependency somewhere or something's
> changed between NT and 2003 that I'm not accounting for. Anyone seen this
or
> have any tips? Thanks in advance!
> -Dan
|||Geoff,
Thanks for the post! I guess I'll just have to make sure the retry &
timeout are set high.
"Geoff N. Hiten" wrote:
> Nope, that is pretty much expected behavior. The cluster manager will try
> and restart the resources on each possible node until the retry count is
> exhausted. Unfortunately, until the network resource is restored, no node
> has the ability to run the SQL group. With the physical network port
> offline, the IP address(es) will not come online. Nothing dependant on them
> will come online, including the Network Name and the SQL Server. If the
> network comes back before the retry timeout and count is exhausted, the
> cluster will bring the system online. Otherwise it stays down.
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
> "Dan" <Dan@.discussions.microsoft.com> wrote in message
> news:74592016-0B61-4834-8C28-1AD1B864B688@.microsoft.com...
> an
> it
> The
> configured
> or
>
>
|||Be careful adjusting those numbers. TOo high can cause just as many
problems as too low. Given the frequency of the network outage and the fact
that something like that will NEVER go unnoticed, I would not change
anything. The cluster failover is designed to reduce the typical 30-45
minute human reponse time for a down server. You shouldn't expect the
clustering software do deal with anything beyond that scope. Adjusting the
parameters to try and expand that coverage will only expose a gap somewhere
else. Just document a cluster check as part of your network failure
recovery procedure and you will be fine.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Dan" <Dan@.discussions.microsoft.com> wrote in message
news:34AB2749-41BF-4A68-8E55-04AEAAE75C38@.microsoft.com...[vbcol=seagreen]
> Geoff,
> Thanks for the post! I guess I'll just have to make sure the retry &
> timeout are set high.
> "Geoff N. Hiten" wrote:
try[vbcol=seagreen]
node[vbcol=seagreen]
them[vbcol=seagreen]
in[vbcol=seagreen]
testing[vbcol=seagreen]
come up[vbcol=seagreen]
running[vbcol=seagreen]
that[vbcol=seagreen]
group[vbcol=seagreen]
something's[vbcol=seagreen]
this[vbcol=seagreen]
We have just rebuilt a SQL 7.0/NT cluster with Windows 2003/SQL2000 in an
active/passive configuration using 2 nodes. During the course of testing it
we had a general network failure in which the network was unavailable. The
virtual SQL and Windows IP address resources went down and did not come up
automatically once the network was available again. The nodes are configured
for automatic failback.
I can't imagine that in the 2 1/2 years the original cluster was running
that we never once had the network go down, but I do know that during that
time I never had a outage where I had to manually move the cluster group
(which causes the cluster to re-initialize both resources and brings
everything back to normal).
I'm thinking that maybe I'm missing a dependency somewhere or something's
changed between NT and 2003 that I'm not accounting for. Anyone seen this or
have any tips? Thanks in advance!
-Dan
Nope, that is pretty much expected behavior. The cluster manager will try
and restart the resources on each possible node until the retry count is
exhausted. Unfortunately, until the network resource is restored, no node
has the ability to run the SQL group. With the physical network port
offline, the IP address(es) will not come online. Nothing dependant on them
will come online, including the Network Name and the SQL Server. If the
network comes back before the retry timeout and count is exhausted, the
cluster will bring the system online. Otherwise it stays down.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Dan" <Dan@.discussions.microsoft.com> wrote in message
news:74592016-0B61-4834-8C28-1AD1B864B688@.microsoft.com...
> All,
> We have just rebuilt a SQL 7.0/NT cluster with Windows 2003/SQL2000 in
an
> active/passive configuration using 2 nodes. During the course of testing
it
> we had a general network failure in which the network was unavailable.
The
> virtual SQL and Windows IP address resources went down and did not come up
> automatically once the network was available again. The nodes are
configured
> for automatic failback.
> I can't imagine that in the 2 1/2 years the original cluster was running
> that we never once had the network go down, but I do know that during that
> time I never had a outage where I had to manually move the cluster group
> (which causes the cluster to re-initialize both resources and brings
> everything back to normal).
> I'm thinking that maybe I'm missing a dependency somewhere or something's
> changed between NT and 2003 that I'm not accounting for. Anyone seen this
or
> have any tips? Thanks in advance!
> -Dan
|||Geoff,
Thanks for the post! I guess I'll just have to make sure the retry &
timeout are set high.
"Geoff N. Hiten" wrote:
> Nope, that is pretty much expected behavior. The cluster manager will try
> and restart the resources on each possible node until the retry count is
> exhausted. Unfortunately, until the network resource is restored, no node
> has the ability to run the SQL group. With the physical network port
> offline, the IP address(es) will not come online. Nothing dependant on them
> will come online, including the Network Name and the SQL Server. If the
> network comes back before the retry timeout and count is exhausted, the
> cluster will bring the system online. Otherwise it stays down.
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
> "Dan" <Dan@.discussions.microsoft.com> wrote in message
> news:74592016-0B61-4834-8C28-1AD1B864B688@.microsoft.com...
> an
> it
> The
> configured
> or
>
>
|||Be careful adjusting those numbers. TOo high can cause just as many
problems as too low. Given the frequency of the network outage and the fact
that something like that will NEVER go unnoticed, I would not change
anything. The cluster failover is designed to reduce the typical 30-45
minute human reponse time for a down server. You shouldn't expect the
clustering software do deal with anything beyond that scope. Adjusting the
parameters to try and expand that coverage will only expose a gap somewhere
else. Just document a cluster check as part of your network failure
recovery procedure and you will be fine.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Dan" <Dan@.discussions.microsoft.com> wrote in message
news:34AB2749-41BF-4A68-8E55-04AEAAE75C38@.microsoft.com...[vbcol=seagreen]
> Geoff,
> Thanks for the post! I guess I'll just have to make sure the retry &
> timeout are set high.
> "Geoff N. Hiten" wrote:
try[vbcol=seagreen]
node[vbcol=seagreen]
them[vbcol=seagreen]
in[vbcol=seagreen]
testing[vbcol=seagreen]
come up[vbcol=seagreen]
running[vbcol=seagreen]
that[vbcol=seagreen]
group[vbcol=seagreen]
something's[vbcol=seagreen]
this[vbcol=seagreen]
Cluster backup
Quick question...
2 node active/passive (excuse the terminology...) cluster.
My network admin wants to have my SQL backups (performed via. maint. plan
nightly) stored on the quorum drive.
We are also performing log shipping at 15 minute intervals to an offsite
server.
I think storing the backups on the quorum drive is a bad idea as if the disk
array dies completely, we have no backup.
Also, would that scheme not necessitate adding the quorum drive as a
resource to the SQL Server?
Comments and thoughts please.
Thanks in advance.
B.
You are correct, its a bad idea
The Quorum drive would have to be a
dependency for SQL. Which would mean one group for basically everything. If
the backups filled the disk, the cluster would not be happy.
A good idea is use the MP to a disk, and then backup to some kind of tape.
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
http://msmvps.com/clustering - Blog
"Tam O'Shanter" <Tam@.Oshanter.com> wrote in message
news:b6prd.6024491$6p.961500@.news.easynews.com...
> Quick question...
> 2 node active/passive (excuse the terminology...) cluster.
> My network admin wants to have my SQL backups (performed via. maint. plan
> nightly) stored on the quorum drive.
> We are also performing log shipping at 15 minute intervals to an offsite
> server.
> I think storing the backups on the quorum drive is a bad idea as if the
> disk
> array dies completely, we have no backup.
> Also, would that scheme not necessitate adding the quorum drive as a
> resource to the SQL Server?
> Comments and thoughts please.
> Thanks in advance.
> B.
>
>
|||Thanks Rodney,
Validation of what I thought.
Would you suggest backing up to a local disk on one of the nodes? Or rather,
having the MP write to a UNC on another machine in the environment
(management server etc..).
I think the UNC is the way to go, but I'd be interested in your thoughts.
Every morning the bak's would be moved from the backup location to an
external firewire drive and physically removed from the facility. This
setup, in conjunction with a logshp (15 min. intervals) to an offsite box
seems like my best option.
Comments?
Thanks again.
B.
"Rodney R. Fournier [MVP]" <rod@.die.spam.die.nw-america.com> wrote in
message news:ORI$OI%231EHA.1192@.tk2msftngp13.phx.gbl...
> You are correct, its a bad idea The Quorum drive would have to be a
> dependency for SQL. Which would mean one group for basically everything.
If[vbcol=seagreen]
> the backups filled the disk, the cluster would not be happy.
> A good idea is use the MP to a disk, and then backup to some kind of tape.
> Cheers,
> Rod
> MVP - Windows Server - Clustering
> http://www.nw-america.com - Clustering
> http://msmvps.com/clustering - Blog
> "Tam O'Shanter" <Tam@.Oshanter.com> wrote in message
> news:b6prd.6024491$6p.961500@.news.easynews.com...
plan
>
|||Tam, you have a problem. You can't backup SQL using the MP to a UNC, though
the last time I tried was years ago. I also don't like the idea of local
node backups. Can you add a disk to the array? Or does the current array
have space already? Remember with the MP you can delete old backups to keep
the space minimal.
Rod
"Tam O'Shanter" <Tam@.Oshanter.com> wrote in message
news:kXprd.3931798$yk.598061@.news.easynews.com...
> Thanks Rodney,
> Validation of what I thought.
> Would you suggest backing up to a local disk on one of the nodes? Or
> rather,
> having the MP write to a UNC on another machine in the environment
> (management server etc..).
> I think the UNC is the way to go, but I'd be interested in your thoughts.
> Every morning the bak's would be moved from the backup location to an
> external firewire drive and physically removed from the facility. This
> setup, in conjunction with a logshp (15 min. intervals) to an offsite box
> seems like my best option.
> Comments?
> Thanks again.
> B.
> "Rodney R. Fournier [MVP]" <rod@.die.spam.die.nw-america.com> wrote in
> message news:ORI$OI%231EHA.1192@.tk2msftngp13.phx.gbl...
> If
> plan
>
|||Yes, you can backup to a UNC. I do it all the time. There is even a
community KB article on how to do backup to a UNC share. Personally, I
think it is one of the best ways to back up a system.
HowTo: Backup to UNC name using Database Maintenance Wizard
http://support.microsoft.com/?kbid=555128
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Rodney R. Fournier [MVP]" <rod@.die.spam.die.nw-america.com> wrote in
message news:u9yvudB2EHA.2568@.TK2MSFTNGP10.phx.gbl...
> Tam, you have a problem. You can't backup SQL using the MP to a UNC,
though
> the last time I tried was years ago. I also don't like the idea of local
> node backups. Can you add a disk to the array? Or does the current array
> have space already? Remember with the MP you can delete old backups to
keep[vbcol=seagreen]
> the space minimal.
> Rod
> "Tam O'Shanter" <Tam@.Oshanter.com> wrote in message
> news:kXprd.3931798$yk.598061@.news.easynews.com...
thoughts.[vbcol=seagreen]
box[vbcol=seagreen]
everything.[vbcol=seagreen]
the
>
|||Excellent. I will file that away for future use Maybe it was 7.0 or 6.5
or 4.21 or 4.2, I have been using SQL for a long time. What I don't like
about UNC is that any network glitch or outage can potentially kill the
backup.
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
http://msmvps.com/clustering - Blog
"Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
news:O845A2H2EHA.2568@.TK2MSFTNGP11.phx.gbl...
> Yes, you can backup to a UNC. I do it all the time. There is even a
> community KB article on how to do backup to a UNC share. Personally, I
> think it is one of the best ways to back up a system.
> HowTo: Backup to UNC name using Database Maintenance Wizard
> http://support.microsoft.com/?kbid=555128
>
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
> "Rodney R. Fournier [MVP]" <rod@.die.spam.die.nw-america.com> wrote in
> message news:u9yvudB2EHA.2568@.TK2MSFTNGP10.phx.gbl...
> though
> keep
> thoughts.
> box
> everything.
> the
>
|||Yep. You can also easily overwhelm a network. I use a dedicated link with
a connection-specific domain suffix to segment the backup traffic from the
normal SQL traffic. I also tune the file share to maximize write
capability. I just upgraded the backup host server (which is also my tape
host server) to handle the load.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Rodney R. Fournier [MVP]" <rod@.die.spam.die.nw-america.com> wrote in
message news:%23kJFlsI2EHA.2572@.tk2msftngp13.phx.gbl...[vbcol=seagreen]
> Excellent. I will file that away for future use Maybe it was 7.0 or 6.5
> or 4.21 or 4.2, I have been using SQL for a long time. What I don't like
> about UNC is that any network glitch or outage can potentially kill the
> backup.
> Cheers,
> Rod
> MVP - Windows Server - Clustering
> http://www.nw-america.com - Clustering
> http://msmvps.com/clustering - Blog
> "Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
> news:O845A2H2EHA.2568@.TK2MSFTNGP11.phx.gbl...
local[vbcol=seagreen]
array[vbcol=seagreen]
This[vbcol=seagreen]
a[vbcol=seagreen]
maint.[vbcol=seagreen]
if[vbcol=seagreen]
a
>
|||We use the Tivoli suite of products...Tivoli storage manager for the OS, and
Tivoli data protection for SQL. We cart all back ups off the servers in case
there is a drive failure. As long as your cluster is active / passive, it's
not too intense to set up and use, but active / active gets a bit trickier.
both nodes need to be able to authenticate to the back up server as each othr
on active / active....we have 2 such clusters running this way, and 5 more
active/ passives.
"Geoff N. Hiten" wrote:
> Yep. You can also easily overwhelm a network. I use a dedicated link with
> a connection-specific domain suffix to segment the backup traffic from the
> normal SQL traffic. I also tune the file share to maximize write
> capability. I just upgraded the backup host server (which is also my tape
> host server) to handle the load.
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
> "Rodney R. Fournier [MVP]" <rod@.die.spam.die.nw-america.com> wrote in
> message news:%23kJFlsI2EHA.2572@.tk2msftngp13.phx.gbl...
> local
> array
> This
> a
> maint.
> if
> a
>
>
sqlsql
2 node active/passive (excuse the terminology...) cluster.
My network admin wants to have my SQL backups (performed via. maint. plan
nightly) stored on the quorum drive.
We are also performing log shipping at 15 minute intervals to an offsite
server.
I think storing the backups on the quorum drive is a bad idea as if the disk
array dies completely, we have no backup.
Also, would that scheme not necessitate adding the quorum drive as a
resource to the SQL Server?
Comments and thoughts please.
Thanks in advance.
B.
You are correct, its a bad idea
The Quorum drive would have to be adependency for SQL. Which would mean one group for basically everything. If
the backups filled the disk, the cluster would not be happy.
A good idea is use the MP to a disk, and then backup to some kind of tape.
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
http://msmvps.com/clustering - Blog
"Tam O'Shanter" <Tam@.Oshanter.com> wrote in message
news:b6prd.6024491$6p.961500@.news.easynews.com...
> Quick question...
> 2 node active/passive (excuse the terminology...) cluster.
> My network admin wants to have my SQL backups (performed via. maint. plan
> nightly) stored on the quorum drive.
> We are also performing log shipping at 15 minute intervals to an offsite
> server.
> I think storing the backups on the quorum drive is a bad idea as if the
> disk
> array dies completely, we have no backup.
> Also, would that scheme not necessitate adding the quorum drive as a
> resource to the SQL Server?
> Comments and thoughts please.
> Thanks in advance.
> B.
>
>
|||Thanks Rodney,
Validation of what I thought.
Would you suggest backing up to a local disk on one of the nodes? Or rather,
having the MP write to a UNC on another machine in the environment
(management server etc..).
I think the UNC is the way to go, but I'd be interested in your thoughts.
Every morning the bak's would be moved from the backup location to an
external firewire drive and physically removed from the facility. This
setup, in conjunction with a logshp (15 min. intervals) to an offsite box
seems like my best option.
Comments?
Thanks again.
B.
"Rodney R. Fournier [MVP]" <rod@.die.spam.die.nw-america.com> wrote in
message news:ORI$OI%231EHA.1192@.tk2msftngp13.phx.gbl...
> You are correct, its a bad idea
The Quorum drive would have to be a> dependency for SQL. Which would mean one group for basically everything.
If[vbcol=seagreen]
> the backups filled the disk, the cluster would not be happy.
> A good idea is use the MP to a disk, and then backup to some kind of tape.
> Cheers,
> Rod
> MVP - Windows Server - Clustering
> http://www.nw-america.com - Clustering
> http://msmvps.com/clustering - Blog
> "Tam O'Shanter" <Tam@.Oshanter.com> wrote in message
> news:b6prd.6024491$6p.961500@.news.easynews.com...
plan
>
|||Tam, you have a problem. You can't backup SQL using the MP to a UNC, though
the last time I tried was years ago. I also don't like the idea of local
node backups. Can you add a disk to the array? Or does the current array
have space already? Remember with the MP you can delete old backups to keep
the space minimal.
Rod
"Tam O'Shanter" <Tam@.Oshanter.com> wrote in message
news:kXprd.3931798$yk.598061@.news.easynews.com...
> Thanks Rodney,
> Validation of what I thought.
> Would you suggest backing up to a local disk on one of the nodes? Or
> rather,
> having the MP write to a UNC on another machine in the environment
> (management server etc..).
> I think the UNC is the way to go, but I'd be interested in your thoughts.
> Every morning the bak's would be moved from the backup location to an
> external firewire drive and physically removed from the facility. This
> setup, in conjunction with a logshp (15 min. intervals) to an offsite box
> seems like my best option.
> Comments?
> Thanks again.
> B.
> "Rodney R. Fournier [MVP]" <rod@.die.spam.die.nw-america.com> wrote in
> message news:ORI$OI%231EHA.1192@.tk2msftngp13.phx.gbl...
> If
> plan
>
|||Yes, you can backup to a UNC. I do it all the time. There is even a
community KB article on how to do backup to a UNC share. Personally, I
think it is one of the best ways to back up a system.
HowTo: Backup to UNC name using Database Maintenance Wizard
http://support.microsoft.com/?kbid=555128
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Rodney R. Fournier [MVP]" <rod@.die.spam.die.nw-america.com> wrote in
message news:u9yvudB2EHA.2568@.TK2MSFTNGP10.phx.gbl...
> Tam, you have a problem. You can't backup SQL using the MP to a UNC,
though
> the last time I tried was years ago. I also don't like the idea of local
> node backups. Can you add a disk to the array? Or does the current array
> have space already? Remember with the MP you can delete old backups to
keep[vbcol=seagreen]
> the space minimal.
> Rod
> "Tam O'Shanter" <Tam@.Oshanter.com> wrote in message
> news:kXprd.3931798$yk.598061@.news.easynews.com...
thoughts.[vbcol=seagreen]
box[vbcol=seagreen]
everything.[vbcol=seagreen]
the
>
|||Excellent. I will file that away for future use
Maybe it was 7.0 or 6.5or 4.21 or 4.2, I have been using SQL for a long time. What I don't like
about UNC is that any network glitch or outage can potentially kill the
backup.
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
http://msmvps.com/clustering - Blog
"Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
news:O845A2H2EHA.2568@.TK2MSFTNGP11.phx.gbl...
> Yes, you can backup to a UNC. I do it all the time. There is even a
> community KB article on how to do backup to a UNC share. Personally, I
> think it is one of the best ways to back up a system.
> HowTo: Backup to UNC name using Database Maintenance Wizard
> http://support.microsoft.com/?kbid=555128
>
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
> "Rodney R. Fournier [MVP]" <rod@.die.spam.die.nw-america.com> wrote in
> message news:u9yvudB2EHA.2568@.TK2MSFTNGP10.phx.gbl...
> though
> keep
> thoughts.
> box
> everything.
> the
>
|||Yep. You can also easily overwhelm a network. I use a dedicated link with
a connection-specific domain suffix to segment the backup traffic from the
normal SQL traffic. I also tune the file share to maximize write
capability. I just upgraded the backup host server (which is also my tape
host server) to handle the load.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Rodney R. Fournier [MVP]" <rod@.die.spam.die.nw-america.com> wrote in
message news:%23kJFlsI2EHA.2572@.tk2msftngp13.phx.gbl...[vbcol=seagreen]
> Excellent. I will file that away for future use
Maybe it was 7.0 or 6.5> or 4.21 or 4.2, I have been using SQL for a long time. What I don't like
> about UNC is that any network glitch or outage can potentially kill the
> backup.
> Cheers,
> Rod
> MVP - Windows Server - Clustering
> http://www.nw-america.com - Clustering
> http://msmvps.com/clustering - Blog
> "Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
> news:O845A2H2EHA.2568@.TK2MSFTNGP11.phx.gbl...
local[vbcol=seagreen]
array[vbcol=seagreen]
This[vbcol=seagreen]
a[vbcol=seagreen]
maint.[vbcol=seagreen]
if[vbcol=seagreen]
a
>
|||We use the Tivoli suite of products...Tivoli storage manager for the OS, and
Tivoli data protection for SQL. We cart all back ups off the servers in case
there is a drive failure. As long as your cluster is active / passive, it's
not too intense to set up and use, but active / active gets a bit trickier.
both nodes need to be able to authenticate to the back up server as each othr
on active / active....we have 2 such clusters running this way, and 5 more
active/ passives.
"Geoff N. Hiten" wrote:
> Yep. You can also easily overwhelm a network. I use a dedicated link with
> a connection-specific domain suffix to segment the backup traffic from the
> normal SQL traffic. I also tune the file share to maximize write
> capability. I just upgraded the backup host server (which is also my tape
> host server) to handle the load.
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
> "Rodney R. Fournier [MVP]" <rod@.die.spam.die.nw-america.com> wrote in
> message news:%23kJFlsI2EHA.2572@.tk2msftngp13.phx.gbl...
> local
> array
> This
> a
> maint.
> if
> a
>
>
sqlsql
Monday, March 19, 2012
Cluster - 2000/2005 side-by-side install
I have a two node active/passive win2003/sql 2000 cluster. Can I do a side-by-side install of a sql2005 named instance on this cluster? This is for a test environment were for a limited time (6 months) I need to provide both a sql2000 and sql2005 environment and I would rather not purchase additional hardware.
This is a perfectly valid multi-instance cluster configuration. The new SQL 2005 installation will need its own IP address, disk resource(s), and network name. This will create a second virtual server for the SQL 2005 instance. Once you uninstall the SQL 2000 instance, you can re-assigne the disk resources to the new SQL 2005 instance. You cannot install the SQL 2005 instance in the existing SQL 2000 virtual server.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"AlanH" <AlanH@.community.nospam> wrote in message news:eQXXv6e%23FHA.2472@.TK2MSFTNGP12.phx.gbl...
I have a two node active/passive win2003/sql 2000 cluster. Can I do a side-by-side install of a sql2005 named instance on this cluster? This is for a test environment were for a limited time (6 months) I need to provide both a sql2000 and sql2005 environment and I would rather not purchase additional hardware.
|||In your last line when you say that "You cannot install the SQL2005 instance in the existing SQL2000 virtual server" do you mean the existing cluster group where sql2000 resides?
Also, if the answer to that is yes (meaning I cannot just install sql2005 in my current group), what are my options for sharing the current disk resources or reconfiguring the current disk resources so that I can give the new cluster_group for sql2005 some disk resources.
Thanks in advance...
"Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message news:Of0GDfg%23FHA.208@.tk2msftngp13.phx.gbl...
This is a perfectly valid multi-instance cluster configuration. The new SQL 2005 installation will need its own IP address, disk resource(s), and network name. This will create a second virtual server for the SQL 2005 instance. Once you uninstall the SQL 2000 instance, you can re-assigne the disk resources to the new SQL 2005 instance. You cannot install the SQL 2005 instance in the existing SQL 2000 virtual server.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"AlanH" <AlanH@.community.nospam> wrote in message news:eQXXv6e%23FHA.2472@.TK2MSFTNGP12.phx.gbl...
I have a two node active/passive win2003/sql 2000 cluster. Can I do a side-by-side install of a sql2005 named instance on this cluster? This is for a test environment were for a limited time (6 months) I need to provide both a sql2000 and sql2005 environment and I would rather not purchase additional hardware.
|||The statement is correct. One group = one virtual server = one instance.
You will either need to add more shared disk(s) to your cluster or remove SQL from some existing disk resources. Disk resources cannot be shared in multiple groups. As such, they can only be used by one virtual server/instance at a time.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"AlanH" <AlanH@.community.nospam> wrote in message news:eq7YDyq%23FHA.3804@.TK2MSFTNGP14.phx.gbl...
In your last line when you say that "You cannot install the SQL2005 instance in the existing SQL2000 virtual server" do you mean the existing cluster group where sql2000 resides?
Also, if the answer to that is yes (meaning I cannot just install sql2005 in my current group), what are my options for sharing the current disk resources or reconfiguring the current disk resources so that I can give the new cluster_group for sql2005 some disk resources.
Thanks in advance...
"Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message news:Of0GDfg%23FHA.208@.tk2msftngp13.phx.gbl...
This is a perfectly valid multi-instance cluster configuration. The new SQL 2005 installation will need its own IP address, disk resource(s), and network name. This will create a second virtual server for the SQL 2005 instance. Once you uninstall the SQL 2000 instance, you can re-assigne the disk resources to the new SQL 2005 instance. You cannot install the SQL 2005 instance in the existing SQL 2000 virtual server.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"AlanH" <AlanH@.community.nospam> wrote in message news:eQXXv6e%23FHA.2472@.TK2MSFTNGP12.phx.gbl...
I have a two node active/passive win2003/sql 2000 cluster. Can I do a side-by-side install of a sql2005 named instance on this cluster? This is for a test environment were for a limited time (6 months) I need to provide both a sql2000 and sql2005 environment and I would rather not purchase additional hardware.
|||That's what I thought... Thanks!
"Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message news:uqMvcYt%23FHA.1336@.TK2MSFTNGP10.phx.gbl...
The statement is correct. One group = one virtual server = one instance.
You will either need to add more shared disk(s) to your cluster or remove SQL from some existing disk resources. Disk resources cannot be shared in multiple groups. As such, they can only be used by one virtual server/instance at a time.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"AlanH" <AlanH@.community.nospam> wrote in message news:eq7YDyq%23FHA.3804@.TK2MSFTNGP14.phx.gbl...
In your last line when you say that "You cannot install the SQL2005 instance in the existing SQL2000 virtual server" do you mean the existing cluster group where sql2000 resides?
Also, if the answer to that is yes (meaning I cannot just install sql2005 in my current group), what are my options for sharing the current disk resources or reconfiguring the current disk resources so that I can give the new cluster_group for sql2005 some disk resources.
Thanks in advance...
"Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message news:Of0GDfg%23FHA.208@.tk2msftngp13.phx.gbl...
This is a perfectly valid multi-instance cluster configuration. The new SQL 2005 installation will need its own IP address, disk resource(s), and network name. This will create a second virtual server for the SQL 2005 instance. Once you uninstall the SQL 2000 instance, you can re-assigne the disk resources to the new SQL 2005 instance. You cannot install the SQL 2005 instance in the existing SQL 2000 virtual server.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"AlanH" <AlanH@.community.nospam> wrote in message news:eQXXv6e%23FHA.2472@.TK2MSFTNGP12.phx.gbl...
I have a two node active/passive win2003/sql 2000 cluster. Can I do a side-by-side install of a sql2005 named instance on this cluster? This is for a test environment were for a limited time (6 months) I need to provide both a sql2000 and sql2005 environment and I would rather not purchase additional hardware.
This is a perfectly valid multi-instance cluster configuration. The new SQL 2005 installation will need its own IP address, disk resource(s), and network name. This will create a second virtual server for the SQL 2005 instance. Once you uninstall the SQL 2000 instance, you can re-assigne the disk resources to the new SQL 2005 instance. You cannot install the SQL 2005 instance in the existing SQL 2000 virtual server.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"AlanH" <AlanH@.community.nospam> wrote in message news:eQXXv6e%23FHA.2472@.TK2MSFTNGP12.phx.gbl...
I have a two node active/passive win2003/sql 2000 cluster. Can I do a side-by-side install of a sql2005 named instance on this cluster? This is for a test environment were for a limited time (6 months) I need to provide both a sql2000 and sql2005 environment and I would rather not purchase additional hardware.
|||In your last line when you say that "You cannot install the SQL2005 instance in the existing SQL2000 virtual server" do you mean the existing cluster group where sql2000 resides?
Also, if the answer to that is yes (meaning I cannot just install sql2005 in my current group), what are my options for sharing the current disk resources or reconfiguring the current disk resources so that I can give the new cluster_group for sql2005 some disk resources.
Thanks in advance...
"Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message news:Of0GDfg%23FHA.208@.tk2msftngp13.phx.gbl...
This is a perfectly valid multi-instance cluster configuration. The new SQL 2005 installation will need its own IP address, disk resource(s), and network name. This will create a second virtual server for the SQL 2005 instance. Once you uninstall the SQL 2000 instance, you can re-assigne the disk resources to the new SQL 2005 instance. You cannot install the SQL 2005 instance in the existing SQL 2000 virtual server.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"AlanH" <AlanH@.community.nospam> wrote in message news:eQXXv6e%23FHA.2472@.TK2MSFTNGP12.phx.gbl...
I have a two node active/passive win2003/sql 2000 cluster. Can I do a side-by-side install of a sql2005 named instance on this cluster? This is for a test environment were for a limited time (6 months) I need to provide both a sql2000 and sql2005 environment and I would rather not purchase additional hardware.
|||The statement is correct. One group = one virtual server = one instance.
You will either need to add more shared disk(s) to your cluster or remove SQL from some existing disk resources. Disk resources cannot be shared in multiple groups. As such, they can only be used by one virtual server/instance at a time.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"AlanH" <AlanH@.community.nospam> wrote in message news:eq7YDyq%23FHA.3804@.TK2MSFTNGP14.phx.gbl...
In your last line when you say that "You cannot install the SQL2005 instance in the existing SQL2000 virtual server" do you mean the existing cluster group where sql2000 resides?
Also, if the answer to that is yes (meaning I cannot just install sql2005 in my current group), what are my options for sharing the current disk resources or reconfiguring the current disk resources so that I can give the new cluster_group for sql2005 some disk resources.
Thanks in advance...
"Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message news:Of0GDfg%23FHA.208@.tk2msftngp13.phx.gbl...
This is a perfectly valid multi-instance cluster configuration. The new SQL 2005 installation will need its own IP address, disk resource(s), and network name. This will create a second virtual server for the SQL 2005 instance. Once you uninstall the SQL 2000 instance, you can re-assigne the disk resources to the new SQL 2005 instance. You cannot install the SQL 2005 instance in the existing SQL 2000 virtual server.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"AlanH" <AlanH@.community.nospam> wrote in message news:eQXXv6e%23FHA.2472@.TK2MSFTNGP12.phx.gbl...
I have a two node active/passive win2003/sql 2000 cluster. Can I do a side-by-side install of a sql2005 named instance on this cluster? This is for a test environment were for a limited time (6 months) I need to provide both a sql2000 and sql2005 environment and I would rather not purchase additional hardware.
|||That's what I thought... Thanks!
"Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message news:uqMvcYt%23FHA.1336@.TK2MSFTNGP10.phx.gbl...
The statement is correct. One group = one virtual server = one instance.
You will either need to add more shared disk(s) to your cluster or remove SQL from some existing disk resources. Disk resources cannot be shared in multiple groups. As such, they can only be used by one virtual server/instance at a time.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"AlanH" <AlanH@.community.nospam> wrote in message news:eq7YDyq%23FHA.3804@.TK2MSFTNGP14.phx.gbl...
In your last line when you say that "You cannot install the SQL2005 instance in the existing SQL2000 virtual server" do you mean the existing cluster group where sql2000 resides?
Also, if the answer to that is yes (meaning I cannot just install sql2005 in my current group), what are my options for sharing the current disk resources or reconfiguring the current disk resources so that I can give the new cluster_group for sql2005 some disk resources.
Thanks in advance...
"Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message news:Of0GDfg%23FHA.208@.tk2msftngp13.phx.gbl...
This is a perfectly valid multi-instance cluster configuration. The new SQL 2005 installation will need its own IP address, disk resource(s), and network name. This will create a second virtual server for the SQL 2005 instance. Once you uninstall the SQL 2000 instance, you can re-assigne the disk resources to the new SQL 2005 instance. You cannot install the SQL 2005 instance in the existing SQL 2000 virtual server.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"AlanH" <AlanH@.community.nospam> wrote in message news:eQXXv6e%23FHA.2472@.TK2MSFTNGP12.phx.gbl...
I have a two node active/passive win2003/sql 2000 cluster. Can I do a side-by-side install of a sql2005 named instance on this cluster? This is for a test environment were for a limited time (6 months) I need to provide both a sql2000 and sql2005 environment and I would rather not purchase additional hardware.
Subscribe to:
Posts (Atom)