Cluster upgrade/migration issue advice.

Hey all,

We have a simple two-node x86 failover cluster attached to a SAN on which SQL Server 2005 runs. We recently bought two new x64 boxes to upgrade the cluster. My original plan was to just add the new nodes to the existing cluster and then remove the old nodes from the cluster, but I just found out that you can't mix architecture types in a cluster.

So far, it seems our choices are:

1) Install x86 Windows 2003 Server on the new nodes, losing performance.
2) Make a new cluster and migrate the data, possibly imposing downtime.

Anyone have any suggestions?You may be able to "swing" the LUNs from one cluster to the other, without much trouble. This depends on a number of factors, so you should contact your SAN vendor to see if it is feasible. If it is, then you build the 64-bit cluster, swing the LUNs over, attach all the DBs to the 64-bit instance of SQL Server, and then change all the applications that pointed to the old cluster. One caution, though, you should definitely take a real nice backup of all the databases, before you do the LUN switch, since you could potentially lose all of your databases to an inadvertent FORMAT command.|||Yeah, I think that's going to be the option we go with, since we can attach the new servers to the old LUNs, but that will involve some downtime.

I suppose we could replicate the dbs to a third server, update the important connections to point to the replicated server, do the move, point the connections to the new cluster.

Ugh.

Cluster quirum drive size

I need a sql failover cluster box with 10 instances, how big the quorum
drive size that I need --estimate
Thanks
Your Quorum drive does not need much space
minimum 500MB, 1GB will work fine
Rgds,
Edwin.
"mecn" <mecn2002@.yahoo.com> wrote in message
news:e$wj5JvaHHA.1240@.TK2MSFTNGP04.phx.gbl...
> I need a sql failover cluster box with 10 instances, how big the quorum
> drive size that I need --estimate
> Thanks
>
|||Our quorum drives are sized to 640MB.
Linchi
"mecn" wrote:

> I need a sql failover cluster box with 10 instances, how big the quorum
> drive size that I need --estimate
> Thanks
>
>
sqlsql

Cluster not visible to external IP

Hello
We have SQL 2000 with two servers clustered (one is a failover) to have one
named SQL server. This is fine internally, but external VPN connections
can't reach this server (all other machines are reachable). Permissions not
an issue.
Anyone have any ideas on where to start/look?
ThanksVPN connections will have to be enabled to the underlying node IPs, not the
virtual server IPs.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"PB" <hoopitup@.gmail.com> wrote in message
news:OdM$Zy47FHA.1148@.tk2msftngp13.phx.gbl...
> Hello
> We have SQL 2000 with two servers clustered (one is a failover) to have
> one named SQL server. This is fine internally, but external VPN
> connections can't reach this server (all other machines are reachable).
> Permissions not an issue.
> Anyone have any ideas on where to start/look?
> Thanks
>|||We are using the cluster name rather than IP. Will try the actual node name
now, but the only thing then is there is no failover protection.
"Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
news:OkktM047FHA.3224@.TK2MSFTNGP09.phx.gbl...
> VPN connections will have to be enabled to the underlying node IPs, not
> the virtual server IPs.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
> "PB" <hoopitup@.gmail.com> wrote in message
> news:OdM$Zy47FHA.1148@.tk2msftngp13.phx.gbl...
>|||When a client (in this case the firewall) receives an IP packet from a
virtual instance, the sender IP address is the node's physical address, not
the virtual address. You can still connect via virtual IP for name and ARP
resolution, but you will have to enable VPN access via the physical node
addresses.
GNH
"PB" <hoopitup@.gmail.com> wrote in message
news:eUtFO347FHA.1248@.TK2MSFTNGP14.phx.gbl...
> We are using the cluster name rather than IP. Will try the actual node
> name now, but the only thing then is there is no failover protection.
> "Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
> news:OkktM047FHA.3224@.TK2MSFTNGP09.phx.gbl...
>

Cluster not visible to external IP

Hello
We have SQL 2000 with two servers clustered (one is a failover) to have one
named SQL server. This is fine internally, but external VPN connections
can't reach this server (all other machines are reachable). Permissions not
an issue.
Anyone have any ideas on where to start/look?
ThanksVPN connections will have to be enabled to the underlying node IPs, not the
virtual server IPs.
--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"PB" <hoopitup@.gmail.com> wrote in message
news:OdM$Zy47FHA.1148@.tk2msftngp13.phx.gbl...
> Hello
> We have SQL 2000 with two servers clustered (one is a failover) to have
> one named SQL server. This is fine internally, but external VPN
> connections can't reach this server (all other machines are reachable).
> Permissions not an issue.
> Anyone have any ideas on where to start/look?
> Thanks
>|||We are using the cluster name rather than IP. Will try the actual node name
now, but the only thing then is there is no failover protection.
"Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
news:OkktM047FHA.3224@.TK2MSFTNGP09.phx.gbl...
> VPN connections will have to be enabled to the underlying node IPs, not
> the virtual server IPs.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
> "PB" <hoopitup@.gmail.com> wrote in message
> news:OdM$Zy47FHA.1148@.tk2msftngp13.phx.gbl...
>> Hello
>> We have SQL 2000 with two servers clustered (one is a failover) to have
>> one named SQL server. This is fine internally, but external VPN
>> connections can't reach this server (all other machines are reachable).
>> Permissions not an issue.
>> Anyone have any ideas on where to start/look?
>> Thanks
>|||When a client (in this case the firewall) receives an IP packet from a
virtual instance, the sender IP address is the node's physical address, not
the virtual address. You can still connect via virtual IP for name and ARP
resolution, but you will have to enable VPN access via the physical node
addresses.
GNH
"PB" <hoopitup@.gmail.com> wrote in message
news:eUtFO347FHA.1248@.TK2MSFTNGP14.phx.gbl...
> We are using the cluster name rather than IP. Will try the actual node
> name now, but the only thing then is there is no failover protection.
> "Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
> news:OkktM047FHA.3224@.TK2MSFTNGP09.phx.gbl...
>> VPN connections will have to be enabled to the underlying node IPs, not
>> the virtual server IPs.
>> --
>> Geoff N. Hiten
>> Senior Database Administrator
>> Microsoft SQL Server MVP
>>
>> "PB" <hoopitup@.gmail.com> wrote in message
>> news:OdM$Zy47FHA.1148@.tk2msftngp13.phx.gbl...
>> Hello
>> We have SQL 2000 with two servers clustered (one is a failover) to have
>> one named SQL server. This is fine internally, but external VPN
>> connections can't reach this server (all other machines are reachable).
>> Permissions not an issue.
>> Anyone have any ideas on where to start/look?
>> Thanks
>>
>sqlsql

Cluster not visible to external IP

Hello
We have SQL 2000 with two servers clustered (one is a failover) to have one
named SQL server. This is fine internally, but external VPN connections
can't reach this server (all other machines are reachable). Permissions not
an issue.
Anyone have any ideas on where to start/look?
Thanks
VPN connections will have to be enabled to the underlying node IPs, not the
virtual server IPs.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"PB" <hoopitup@.gmail.com> wrote in message
news:OdM$Zy47FHA.1148@.tk2msftngp13.phx.gbl...
> Hello
> We have SQL 2000 with two servers clustered (one is a failover) to have
> one named SQL server. This is fine internally, but external VPN
> connections can't reach this server (all other machines are reachable).
> Permissions not an issue.
> Anyone have any ideas on where to start/look?
> Thanks
>
|||We are using the cluster name rather than IP. Will try the actual node name
now, but the only thing then is there is no failover protection.
"Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
news:OkktM047FHA.3224@.TK2MSFTNGP09.phx.gbl...
> VPN connections will have to be enabled to the underlying node IPs, not
> the virtual server IPs.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
> "PB" <hoopitup@.gmail.com> wrote in message
> news:OdM$Zy47FHA.1148@.tk2msftngp13.phx.gbl...
>
|||When a client (in this case the firewall) receives an IP packet from a
virtual instance, the sender IP address is the node's physical address, not
the virtual address. You can still connect via virtual IP for name and ARP
resolution, but you will have to enable VPN access via the physical node
addresses.
GNH
"PB" <hoopitup@.gmail.com> wrote in message
news:eUtFO347FHA.1248@.TK2MSFTNGP14.phx.gbl...
> We are using the cluster name rather than IP. Will try the actual node
> name now, but the only thing then is there is no failover protection.
> "Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
> news:OkktM047FHA.3224@.TK2MSFTNGP09.phx.gbl...
>

Cluster Node Tuning

Hi,
I have a 2 node failover cluster running SQL2000 EE with SP4. Each node has
8GB of RAM, and each node is the preferred owner of one of the two SQL Server
instances, each of which are AWE enabled and have min and max server memory
set to 3GB. PAE and /3GB switch are also enabled on each node. Storage is
via FC direct attached SAN. My question:
Under System Properties/Advanced/Performance Options:
1. Should I set Processor Scheduling to Programs or Background Services?
2. Should I set Memory Usage to Programs or System Cache?
Thank you!
John
1. Background Services
2. Programs
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"JT" <Jthayer@.online.nospam> wrote in message
news:F0EE0BDB-79DE-4E7D-BE5E-6D9F9DF95C5D@.microsoft.com...
> Hi,
> I have a 2 node failover cluster running SQL2000 EE with SP4. Each node
> has
> 8GB of RAM, and each node is the preferred owner of one of the two SQL
> Server
> instances, each of which are AWE enabled and have min and max server
> memory
> set to 3GB. PAE and /3GB switch are also enabled on each node. Storage
> is
> via FC direct attached SAN. My question:
> Under System Properties/Advanced/Performance Options:
> 1. Should I set Processor Scheduling to Programs or Background Services?
> 2. Should I set Memory Usage to Programs or System Cache?
> Thank you!
> --
> John
|||Thanks Mike. That's what I had.
John
"Mike Epprecht (SQL MVP)" wrote:

> 1. Background Services
> 2. Programs
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "JT" <Jthayer@.online.nospam> wrote in message
> news:F0EE0BDB-79DE-4E7D-BE5E-6D9F9DF95C5D@.microsoft.com...
>
>

Cluster Node Tuning

Hi,
I have a 2 node failover cluster running SQL2000 EE with SP4. Each node has
8GB of RAM, and each node is the preferred owner of one of the two SQL Server
instances, each of which are AWE enabled and have min and max server memory
set to 3GB. PAE and /3GB switch are also enabled on each node. Storage is
via FC direct attached SAN. My question:
Under System Properties/Advanced/Performance Options:
1. Should I set Processor Scheduling to Programs or Background Services?
2. Should I set Memory Usage to Programs or System Cache?
Thank you!
--
John1. Background Services
2. Programs
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"JT" <Jthayer@.online.nospam> wrote in message
news:F0EE0BDB-79DE-4E7D-BE5E-6D9F9DF95C5D@.microsoft.com...
> Hi,
> I have a 2 node failover cluster running SQL2000 EE with SP4. Each node
> has
> 8GB of RAM, and each node is the preferred owner of one of the two SQL
> Server
> instances, each of which are AWE enabled and have min and max server
> memory
> set to 3GB. PAE and /3GB switch are also enabled on each node. Storage
> is
> via FC direct attached SAN. My question:
> Under System Properties/Advanced/Performance Options:
> 1. Should I set Processor Scheduling to Programs or Background Services?
> 2. Should I set Memory Usage to Programs or System Cache?
> Thank you!
> --
> John|||Thanks Mike. That's what I had.
--
John
"Mike Epprecht (SQL MVP)" wrote:
> 1. Background Services
> 2. Programs
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "JT" <Jthayer@.online.nospam> wrote in message
> news:F0EE0BDB-79DE-4E7D-BE5E-6D9F9DF95C5D@.microsoft.com...
> > Hi,
> > I have a 2 node failover cluster running SQL2000 EE with SP4. Each node
> > has
> > 8GB of RAM, and each node is the preferred owner of one of the two SQL
> > Server
> > instances, each of which are AWE enabled and have min and max server
> > memory
> > set to 3GB. PAE and /3GB switch are also enabled on each node. Storage
> > is
> > via FC direct attached SAN. My question:
> > Under System Properties/Advanced/Performance Options:
> > 1. Should I set Processor Scheduling to Programs or Background Services?
> > 2. Should I set Memory Usage to Programs or System Cache?
> >
> > Thank you!
> > --
> > John
>
>

Cluster Node Tuning

Hi,
I have a 2 node failover cluster running SQL2000 EE with SP4. Each node has
8GB of RAM, and each node is the preferred owner of one of the two SQL Serve
r
instances, each of which are AWE enabled and have min and max server memory
set to 3GB. PAE and /3GB switch are also enabled on each node. Storage is
via FC direct attached SAN. My question:
Under System Properties/Advanced/Performance Options:
1. Should I set Processor Scheduling to Programs or Background Services?
2. Should I set Memory Usage to Programs or System Cache?
Thank you!
--
John1. Background Services
2. Programs
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"JT" <Jthayer@.online.nospam> wrote in message
news:F0EE0BDB-79DE-4E7D-BE5E-6D9F9DF95C5D@.microsoft.com...
> Hi,
> I have a 2 node failover cluster running SQL2000 EE with SP4. Each node
> has
> 8GB of RAM, and each node is the preferred owner of one of the two SQL
> Server
> instances, each of which are AWE enabled and have min and max server
> memory
> set to 3GB. PAE and /3GB switch are also enabled on each node. Storage
> is
> via FC direct attached SAN. My question:
> Under System Properties/Advanced/Performance Options:
> 1. Should I set Processor Scheduling to Programs or Background Services?
> 2. Should I set Memory Usage to Programs or System Cache?
> Thank you!
> --
> John|||Thanks Mike. That's what I had.
--
John
"Mike Epprecht (SQL MVP)" wrote:

> 1. Background Services
> 2. Programs
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "JT" <Jthayer@.online.nospam> wrote in message
> news:F0EE0BDB-79DE-4E7D-BE5E-6D9F9DF95C5D@.microsoft.com...
>
>

Cluster issue

I'm having an issue with a two node cluster. We're using failover clustering
in SQL 2000 but everytime the first node fails it doesn't automatically
failover to the second node. Are there any KB articles dealing with this?
I've searched but can't seem to find what I'm looking for. Thanks in advance.
http://www.microsoft.com/technet/arc.../mscstswp.mspx
MG
"Nicholas" wrote:

> I'm having an issue with a two node cluster. We're using failover clustering
> in SQL 2000 but everytime the first node fails it doesn't automatically
> failover to the second node. Are there any KB articles dealing with this?
> I've searched but can't seem to find what I'm looking for. Thanks in advance.
|||You need to look at the SQL Server and System Event Application logs to see
what resource is not coming online and why. There are many reasons why a
cluster won't fail over, so finding the exact cause is the first step. If
you have troubleshooting time, you can manually (using the Cluster
Administrator tool) take the SQL group offline, move it to the other node,
and bring each resource online one at a time to see exactly where it fails.
Post your results and we will go from there.
Geoff N. Hiten
Microsoft SQL Server MVP
"Nicholas" <Nicholas@.discussions.microsoft.com> wrote in message
news:509577DA-5060-4B80-A61D-28981BED4233@.microsoft.com...
> I'm having an issue with a two node cluster. We're using failover
> clustering
> in SQL 2000 but everytime the first node fails it doesn't automatically
> failover to the second node. Are there any KB articles dealing with this?
> I've searched but can't seem to find what I'm looking for. Thanks in
> advance.
|||Thanks. Didn't think to check TechNet for some reason.
"MGeles" wrote:
[vbcol=seagreen]
> http://www.microsoft.com/technet/arc.../mscstswp.mspx
> --
> MG
>
> "Nicholas" wrote:
sqlsql

Cluster issue

I'm having an issue with a two node cluster. We're using failover clustering
in SQL 2000 but everytime the first node fails it doesn't automatically
failover to the second node. Are there any KB articles dealing with this?
I've searched but can't seem to find what I'm looking for. Thanks in advance.http://www.microsoft.com/technet/archive/winntas/support/mscstswp.mspx
--
MG
"Nicholas" wrote:
> I'm having an issue with a two node cluster. We're using failover clustering
> in SQL 2000 but everytime the first node fails it doesn't automatically
> failover to the second node. Are there any KB articles dealing with this?
> I've searched but can't seem to find what I'm looking for. Thanks in advance.|||You need to look at the SQL Server and System Event Application logs to see
what resource is not coming online and why. There are many reasons why a
cluster won't fail over, so finding the exact cause is the first step. If
you have troubleshooting time, you can manually (using the Cluster
Administrator tool) take the SQL group offline, move it to the other node,
and bring each resource online one at a time to see exactly where it fails.
Post your results and we will go from there.
Geoff N. Hiten
Microsoft SQL Server MVP
"Nicholas" <Nicholas@.discussions.microsoft.com> wrote in message
news:509577DA-5060-4B80-A61D-28981BED4233@.microsoft.com...
> I'm having an issue with a two node cluster. We're using failover
> clustering
> in SQL 2000 but everytime the first node fails it doesn't automatically
> failover to the second node. Are there any KB articles dealing with this?
> I've searched but can't seem to find what I'm looking for. Thanks in
> advance.|||Thanks. Didn't think to check TechNet for some reason.
"MGeles" wrote:
> http://www.microsoft.com/technet/archive/winntas/support/mscstswp.mspx
> --
> MG
>
> "Nicholas" wrote:
> > I'm having an issue with a two node cluster. We're using failover clustering
> > in SQL 2000 but everytime the first node fails it doesn't automatically
> > failover to the second node. Are there any KB articles dealing with this?
> > I've searched but can't seem to find what I'm looking for. Thanks in advance.

Cluster issue

I'm having an issue with a two node cluster. We're using failover clustering
in SQL 2000 but everytime the first node fails it doesn't automatically
failover to the second node. Are there any KB articles dealing with this?
I've searched but can't seem to find what I'm looking for. Thanks in advance
.http://www.microsoft.com/technet/ar...t/mscstswp.mspx
--
MG
"Nicholas" wrote:
[vbcol=seagreen]
> I'm having an issue with a two node cluster. We're using failover clusteri
ng
> in SQL 2000 but everytime the first node fails it doesn't automatically
> failover to the second node. Are there any KB articles dealing with this?
> I've searched but can't seem to find what I'm looking for. Thanks in advance.[/vbc
ol]|||You need to look at the SQL Server and System Event Application logs to see
what resource is not coming online and why. There are many reasons why a
cluster won't fail over, so finding the exact cause is the first step. If
you have troubleshooting time, you can manually (using the Cluster
Administrator tool) take the SQL group offline, move it to the other node,
and bring each resource online one at a time to see exactly where it fails.
Post your results and we will go from there.
Geoff N. Hiten
Microsoft SQL Server MVP
"Nicholas" <Nicholas@.discussions.microsoft.com> wrote in message
news:509577DA-5060-4B80-A61D-28981BED4233@.microsoft.com...
> I'm having an issue with a two node cluster. We're using failover
> clustering
> in SQL 2000 but everytime the first node fails it doesn't automatically
> failover to the second node. Are there any KB articles dealing with this?
> I've searched but can't seem to find what I'm looking for. Thanks in
> advance.|||Thanks. Didn't think to check technet for some reason.
"MGeles" wrote:
[vbcol=seagreen]
> http://www.microsoft.com/technet/ar...t/mscstswp.mspx
> --
> MG
>
> "Nicholas" wrote:
>

Cluster Installation Failure

Thanks in advance for any help.
A SQL 2005 Failover Clustering installation (from the RTM disks) failed on
Database Services. Please see messages below. Windows cluster server name
is COMDEVDB01 (Windows 2003), primary node = COMDEVCLU01, secondary node =
COMDEVCLU02. SQL cluster virtual name = COMDEVSQLCLU, named instance =
COMDEVPROD. I installed from COMDEVCLU01. Should I install from COMDEVDB01
while COMDEVCLU01 is the active node (i.e., I will be on COMDEVCLU01)?
Earlier install failed on SQLBrowser errors and rolled back. Before the
cluster install two non-clustered SQL 2005 named instances had been installed
on COMDEVCLU01 and SP2 had been applied (both current versions = 3152).
After the SQLBrowser failure I installed a non-clustered SQL 2005 named
instance on COMDEVCLU02 with Database Services and Integration Services (also
version 3152). After that, the cluster install on COMDEVCLU01 failed with
these errors but did not rollback.
Should I try to install SP2 for the SQL cluster from COMDEVCLU01?
Can I "complete" this installation (save it) or will I have to uninstall and
re-install?
Should I uninstall all SQL Server instances on COMDEVCLU01 and install the
clustered instance first?
summary.txt message:
Machine : COMDEVCLU01
Product : Microsoft SQL Server 2005
Product Version : 9.00.1399.06
Install : Failed
Log File : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files\SQLSetup0006_COMDEVCLU01_SQL.l og
Last Action : ComponentUpgrade
Error String : The setup has encountered an error while Upgrading
Components. The error: -2147019873
Error message: The group or resource is not in the correct state to perform
the requested operation.
Error Number : 29550
SQLSetup0006_COMDEVCLU01_SQL.log message:
MSI (s) (AC:14) [15:52:23:016]: Product: Microsoft SQL Server 2005 - Update
'Hotfix 3024 for SQL Server Database Services 2005 ENU (KB000000)' could not
be installed. Error code 1603.
MichaelA_CCGA
Michael:
I will be posting a similar question to yours entitled "Failed SQL Cluster
Advice." That hopefully will get answered as well.
In the meantime you mentioned RTM Disks. Are these CDs and did your install
fail when you put in Disk 2 "Tools" This is my issue and I have googled to
find that this is a known issue and the resolution is copy both disks to a
common path.
Was this your issue as well?
Thanks, emagidson
"MichaelA_CCGA" wrote:

> Thanks in advance for any help.
> A SQL 2005 Failover Clustering installation (from the RTM disks) failed on
> Database Services. Please see messages below. Windows cluster server name
> is COMDEVDB01 (Windows 2003), primary node = COMDEVCLU01, secondary node =
> COMDEVCLU02. SQL cluster virtual name = COMDEVSQLCLU, named instance =
> COMDEVPROD. I installed from COMDEVCLU01. Should I install from COMDEVDB01
> while COMDEVCLU01 is the active node (i.e., I will be on COMDEVCLU01)?
> Earlier install failed on SQLBrowser errors and rolled back. Before the
> cluster install two non-clustered SQL 2005 named instances had been installed
> on COMDEVCLU01 and SP2 had been applied (both current versions = 3152).
> After the SQLBrowser failure I installed a non-clustered SQL 2005 named
> instance on COMDEVCLU02 with Database Services and Integration Services (also
> version 3152). After that, the cluster install on COMDEVCLU01 failed with
> these errors but did not rollback.
> Should I try to install SP2 for the SQL cluster from COMDEVCLU01?
> Can I "complete" this installation (save it) or will I have to uninstall and
> re-install?
> Should I uninstall all SQL Server instances on COMDEVCLU01 and install the
> clustered instance first?
> summary.txt message:
> ----
> Machine : COMDEVCLU01
> Product : Microsoft SQL Server 2005
> Product Version : 9.00.1399.06
> Install : Failed
> Log File : C:\Program Files\Microsoft SQL Server\90\Setup
> Bootstrap\LOG\Files\SQLSetup0006_COMDEVCLU01_SQL.l og
> Last Action : ComponentUpgrade
> Error String : The setup has encountered an error while Upgrading
> Components. The error: -2147019873
> Error message: The group or resource is not in the correct state to perform
> the requested operation.
> Error Number : 29550
> ----
> SQLSetup0006_COMDEVCLU01_SQL.log message:
> ----
> MSI (s) (AC:14) [15:52:23:016]: Product: Microsoft SQL Server 2005 - Update
> 'Hotfix 3024 for SQL Server Database Services 2005 ENU (KB000000)' could not
> be installed. Error code 1603.
> --
> MichaelA_CCGA
|||Sorry I dropped out of the discussion but I wanted to post the question
before I took a few days off and I'm just now catching up. I have printed
your exchange with Geoff and I will review that in more detail.
I did not have the "2nd CD" problem but the information about uninstalling
may prove very useful.
Thanks again, and I'll check back in tomorrow or Thursday.
MichaelA_CCGA
"EMagidson" wrote:
[vbcol=seagreen]
> Michael:
> I will be posting a similar question to yours entitled "Failed SQL Cluster
> Advice." That hopefully will get answered as well.
> In the meantime you mentioned RTM Disks. Are these CDs and did your install
> fail when you put in Disk 2 "Tools" This is my issue and I have googled to
> find that this is a known issue and the resolution is copy both disks to a
> common path.
> Was this your issue as well?
> Thanks, emagidson
> "MichaelA_CCGA" wrote:

Cluster Failovers and activation

So is there something I'm supposed to configure to allow activation to fire after a cluster failover. We have had three where I have noticed that activation does not automatically fire back up. i have to alter the queue to get it going. None of the values on sys.service_queues imply that is disabled, but messages just keep stacking up into the queue and are not being dealt with. Once I alter the queue to turn activation on; everything takes off and starts working normaly.

Obviously, this is less than desireable for an environment that requires High availability.

Regards

After failover when the queue is not being activated:

1. Do you see any Broker:Activation events in the profiler when messages are enqueued?

2. What is the state of the queue monitor? (sys.dm_broker_queue_monitors)

3. Are there any failures reported in the ERRORLOG?

Thanks,
Rushi

Cluster Failover - Setting Affinity

Hi Folks:
How do you script-o-matically set processor affinity on SQL after a
cluster failure?
The purpose is that I'll be failing to a machine with a different
amount of CPU's (4 instead of 8). I want to control what SQL
instances take what amounts of processor.
Is this even possible?
Thanks!
Not that this will help any, but Datacenter allows for this from the Process
Control program
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
"The Researcher" <the_re_searcher@.hotmail.com> wrote in message
news:59fe996a.0408300823.1bfbe5d2@.posting.google.c om...
> Hi Folks:
> How do you script-o-matically set processor affinity on SQL after a
> cluster failure?
> The purpose is that I'll be failing to a machine with a different
> amount of CPU's (4 instead of 8). I want to control what SQL
> instances take what amounts of processor.
> Is this even possible?
> Thanks!
|||... then I wonder if you can do it in WSRM in Win2k3 that allows you to set
percentages etc on processors - it seems to be derived from the Process
Control Tool in Datacenter ?
Andy.
"Rodney R. Fournier [MVP]" <rod@.die.spam.die.nw-america.com> wrote in
message news:eHgTAWrjEHA.1656@.TK2MSFTNGP09.phx.gbl...
> Not that this will help any, but Datacenter allows for this from the
Process
> Control program
> Cheers,
> Rod
> MVP - Windows Server - Clustering
> http://www.nw-america.com - Clustering
> "The Researcher" <the_re_searcher@.hotmail.com> wrote in message
> news:59fe996a.0408300823.1bfbe5d2@.posting.google.c om...
>
|||Excellent idea Andy! WSRM is not do processors affinity though. It does do
these things:
Set CPU and memory allocation policies on applications. This includes
selecting processes to be managed, and setting resource usage targets or
limits.
Manage CPU utilization (percent CPU in use).
Limit the process working set size (physical resident pages in use).
Manage committed memory (pagefile usage).
Apply policies to users or groups on a Terminal Services application
server.
Apply policies on a date/time schedule.
Generate, store, view, and export resource utilization accounting
records for management, service level agreement (SLA) tracking, and
charge-back purposes.
see
http://www.microsoft.com/windowsserv...fastfacts.mspx
for more on WSRM.
Its a great package and free for EE and DC editions.
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
"Andy Ball" <andy.ball@.remove4spam_greenfell.com> wrote in message
news:O%23xgKBFkEHA.324@.TK2MSFTNGP11.phx.gbl...
> ... then I wonder if you can do it in WSRM in Win2k3 that allows you to
> set
> percentages etc on processors - it seems to be derived from the Process
> Control Tool in Datacenter ?
> Andy.
> "Rodney R. Fournier [MVP]" <rod@.die.spam.die.nw-america.com> wrote in
> message news:eHgTAWrjEHA.1656@.TK2MSFTNGP09.phx.gbl...
> Process
>
|||Dang English language and spell chuckers! WSRM is not do processors affinity
though - Should be WSRM does not do processors affinity.
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
"Rodney R. Fournier [MVP]" <rod@.die.spam.die.nw-america.com> wrote in
message news:uunBBKJkEHA.3712@.TK2MSFTNGP15.phx.gbl...
> Excellent idea Andy! WSRM is not do processors affinity though. It does do
> these things:
> Set CPU and memory allocation policies on applications. This includes
> selecting processes to be managed, and setting resource usage targets or
> limits.
> Manage CPU utilization (percent CPU in use).
> Limit the process working set size (physical resident pages in
> use).
> Manage committed memory (pagefile usage).
> Apply policies to users or groups on a Terminal Services
> application server.
> Apply policies on a date/time schedule.
> Generate, store, view, and export resource utilization accounting
> records for management, service level agreement (SLA) tracking, and
> charge-back purposes.
>
> see
> http://www.microsoft.com/windowsserv...fastfacts.mspx
> for more on WSRM.
> Its a great package and free for EE and DC editions.
> Cheers,
> Rod
> MVP - Windows Server - Clustering
> http://www.nw-america.com - Clustering
> "Andy Ball" <andy.ball@.remove4spam_greenfell.com> wrote in message
> news:O%23xgKBFkEHA.324@.TK2MSFTNGP11.phx.gbl...
>
|||"Rodney R. Fournier [MVP]" <rod@.die.spam.die.nw-america.com> wrote in message news:<eHgTAWrjEHA.1656@.TK2MSFTNGP09.phx.gbl>...
> Not that this will help any, but Datacenter allows for this from the Process
> Control program
ehr, I just checked with the WSRM site and found the following snippet:
It is not recommended that you use WSRM CPU affinity for SQL Server 2000.
That being said, it doesn't appear as though that's going to work.
Any other suggestions?
Thx
sqlsql

Cluster Failover

Each morning I find that 1 of my servers has failed across and I'm
getting the following error:
Does anyone have any ideas'
Many Thanks
Event Type: Error
Event Source: ClusSvc
Event Category: Startup/Shutdown
Event ID: 1234
Date: 06/09/2006
Time: 09:09:18
User: N/A
Computer: NXNHPSQLSRV1
Description:
The Cluster service account does not have the following required user
rights:
Act as part of the operating system
These user rights were granted to the Cluster service account during
cluster setup and must not be removed.
User Action
Assign these rights to the Cluster service account. One way to do this
is to use Local Security Settings (Secpol.msc). Another way is to edit
the Group Policy object that is associated with the Cluster service
account's user object in Active Directory.
If you have already assigned these rights to the Cluster service
account, and the user rights appear to be removed, a Group Policy
object might be removing the rights. Check with your domain
administrator to find out if this is happening.Hi
Have you checked the rights? I assume it is a domain account that you are
using for the cluster service account?
John
<Joe.Mobley@.nationalexpress.com> wrote in message
news:1157531034.223893.106160@.b28g2000cwb.googlegroups.com...
> Each morning I find that 1 of my servers has failed across and I'm
> getting the following error:
> Does anyone have any ideas'
> Many Thanks
> Event Type: Error
> Event Source: ClusSvc
> Event Category: Startup/Shutdown
> Event ID: 1234
> Date: 06/09/2006
> Time: 09:09:18
> User: N/A
> Computer: NXNHPSQLSRV1
> Description:
> The Cluster service account does not have the following required user
> rights:
> Act as part of the operating system
> These user rights were granted to the Cluster service account during
> cluster setup and must not be removed.
> User Action
> Assign these rights to the Cluster service account. One way to do this
> is to use Local Security Settings (Secpol.msc). Another way is to edit
> the Group Policy object that is associated with the Cluster service
> account's user object in Active Directory.
> If you have already assigned these rights to the Cluster service
> account, and the user rights appear to be removed, a Group Policy
> object might be removing the rights. Check with your domain
> administrator to find out if this is happening.
>|||It's probably time to work with your server admin folks to see what else are
being modified. Nobody should be revoking privileges like this from service
accounts. Whether it's modified systematically via some group policy or
manually by someone mucking around, you've got a potentially big problem.
Linchi
"Joe.Mobley@.nationalexpress.com" wrote:

> Each morning I find that 1 of my servers has failed across and I'm
> getting the following error:
> Does anyone have any ideas'
> Many Thanks
> Event Type: Error
> Event Source: ClusSvc
> Event Category: Startup/Shutdown
> Event ID: 1234
> Date: 06/09/2006
> Time: 09:09:18
> User: N/A
> Computer: NXNHPSQLSRV1
> Description:
> The Cluster service account does not have the following required user
> rights:
> Act as part of the operating system
> These user rights were granted to the Cluster service account during
> cluster setup and must not be removed.
> User Action
> Assign these rights to the Cluster service account. One way to do this
> is to use Local Security Settings (Secpol.msc). Another way is to edit
> the Group Policy object that is associated with the Cluster service
> account's user object in Active Directory.
> If you have already assigned these rights to the Cluster service
> account, and the user rights appear to be removed, a Group Policy
> object might be removing the rights. Check with your domain
> administrator to find out if this is happening.
>|||Sounds like a GP issue -removing rights from the cluster service account.
Check with the Domain admins about providing a static profile to the cluster
service account.
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
<Joe.Mobley@.nationalexpress.com> wrote in message
news:1157531034.223893.106160@.b28g2000cwb.googlegroups.com...
> Each morning I find that 1 of my servers has failed across and I'm
> getting the following error:
> Does anyone have any ideas'
> Many Thanks
> Event Type: Error
> Event Source: ClusSvc
> Event Category: Startup/Shutdown
> Event ID: 1234
> Date: 06/09/2006
> Time: 09:09:18
> User: N/A
> Computer: NXNHPSQLSRV1
> Description:
> The Cluster service account does not have the following required user
> rights:
> Act as part of the operating system
> These user rights were granted to the Cluster service account during
> cluster setup and must not be removed.
> User Action
> Assign these rights to the Cluster service account. One way to do this
> is to use Local Security Settings (Secpol.msc). Another way is to edit
> the Group Policy object that is associated with the Cluster service
> account's user object in Active Directory.
> If you have already assigned these rights to the Cluster service
> account, and the user rights appear to be removed, a Group Policy
> object might be removing the rights. Check with your domain
> administrator to find out if this is happening.
>

Cluster Failover

Each morning I find that 1 of my servers has failed across and I'm
getting the following error:
Does anyone have any ideas'
Many Thanks
Event Type: Error
Event Source: ClusSvc
Event Category: Startup/Shutdown
Event ID: 1234
Date: 06/09/2006
Time: 09:09:18
User: N/A
Computer: NXNHPSQLSRV1
Description:
The Cluster service account does not have the following required user
rights:
Act as part of the operating system
These user rights were granted to the Cluster service account during
cluster setup and must not be removed.
User Action
Assign these rights to the Cluster service account. One way to do this
is to use Local Security Settings (Secpol.msc). Another way is to edit
the Group Policy object that is associated with the Cluster service
account's user object in Active Directory.
If you have already assigned these rights to the Cluster service
account, and the user rights appear to be removed, a Group Policy
object might be removing the rights. Check with your domain
administrator to find out if this is happening.Hi
Have you checked the rights? I assume it is a domain account that you are
using for the cluster service account?
John
<Joe.Mobley@.nationalexpress.com> wrote in message
news:1157531034.223893.106160@.b28g2000cwb.googlegroups.com...
> Each morning I find that 1 of my servers has failed across and I'm
> getting the following error:
> Does anyone have any ideas'
> Many Thanks
> Event Type: Error
> Event Source: ClusSvc
> Event Category: Startup/Shutdown
> Event ID: 1234
> Date: 06/09/2006
> Time: 09:09:18
> User: N/A
> Computer: NXNHPSQLSRV1
> Description:
> The Cluster service account does not have the following required user
> rights:
> Act as part of the operating system
> These user rights were granted to the Cluster service account during
> cluster setup and must not be removed.
> User Action
> Assign these rights to the Cluster service account. One way to do this
> is to use Local Security Settings (Secpol.msc). Another way is to edit
> the Group Policy object that is associated with the Cluster service
> account's user object in Active Directory.
> If you have already assigned these rights to the Cluster service
> account, and the user rights appear to be removed, a Group Policy
> object might be removing the rights. Check with your domain
> administrator to find out if this is happening.
>|||It's probably time to work with your server admin folks to see what else are
being modified. Nobody should be revoking privileges like this from service
accounts. Whether it's modified systematically via some group policy or
manually by someone mucking around, you've got a potentially big problem.
Linchi
"Joe.Mobley@.nationalexpress.com" wrote:
> Each morning I find that 1 of my servers has failed across and I'm
> getting the following error:
> Does anyone have any ideas'
> Many Thanks
> Event Type: Error
> Event Source: ClusSvc
> Event Category: Startup/Shutdown
> Event ID: 1234
> Date: 06/09/2006
> Time: 09:09:18
> User: N/A
> Computer: NXNHPSQLSRV1
> Description:
> The Cluster service account does not have the following required user
> rights:
> Act as part of the operating system
> These user rights were granted to the Cluster service account during
> cluster setup and must not be removed.
> User Action
> Assign these rights to the Cluster service account. One way to do this
> is to use Local Security Settings (Secpol.msc). Another way is to edit
> the Group Policy object that is associated with the Cluster service
> account's user object in Active Directory.
> If you have already assigned these rights to the Cluster service
> account, and the user rights appear to be removed, a Group Policy
> object might be removing the rights. Check with your domain
> administrator to find out if this is happening.
>|||Sounds like a GP issue -removing rights from the cluster service account.
Check with the Domain admins about providing a static profile to the cluster
service account.
--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
<Joe.Mobley@.nationalexpress.com> wrote in message
news:1157531034.223893.106160@.b28g2000cwb.googlegroups.com...
> Each morning I find that 1 of my servers has failed across and I'm
> getting the following error:
> Does anyone have any ideas'
> Many Thanks
> Event Type: Error
> Event Source: ClusSvc
> Event Category: Startup/Shutdown
> Event ID: 1234
> Date: 06/09/2006
> Time: 09:09:18
> User: N/A
> Computer: NXNHPSQLSRV1
> Description:
> The Cluster service account does not have the following required user
> rights:
> Act as part of the operating system
> These user rights were granted to the Cluster service account during
> cluster setup and must not be removed.
> User Action
> Assign these rights to the Cluster service account. One way to do this
> is to use Local Security Settings (Secpol.msc). Another way is to edit
> the Group Policy object that is associated with the Cluster service
> account's user object in Active Directory.
> If you have already assigned these rights to the Cluster service
> account, and the user rights appear to be removed, a Group Policy
> object might be removing the rights. Check with your domain
> administrator to find out if this is happening.
>

Cluster Failover

What happens to a running query when SQL instance failover? Will the query fail?yes

Cluster Failover

We have a 3rd party vendor application that runs on IIS and connects to a
back end SQL Cluster. Sometimes a user will try and run a commission report
and the SQL server takes a big hit on the CPU's (Dual 2.0 Ghz Xeon's) and I
will get a error in MOM 2005 that the "Server Performance Thresholds
SQLSERVR Process > 90% CPU for 15 minutes" Of course the end user will try
and run it two or three more times taking up more resources.
If I do a fail over to the other SQL server in the cluster the CPU's will
drop down to their normal ranges and everything works fine.
My question is when performing the "failover" that 10 - 15 seconds it takes
to do this what happens to any data that is trying to write to the database?
Is it lost? And can this cause corruption in the database itself?
Thanks!
Failovers don't cause corruption. Rather, any active transactions are
rolled back when the backup node takes over from the primary node.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
..
"Scopus69" <Scopus69@.nospam.postalias> wrote in message
news:DF8080ED-0DF2-42C7-B1DA-4D9375D0B2EA@.microsoft.com...
We have a 3rd party vendor application that runs on IIS and connects to a
back end SQL Cluster. Sometimes a user will try and run a commission report
and the SQL server takes a big hit on the CPU's (Dual 2.0 Ghz Xeon's) and I
will get a error in MOM 2005 that the "Server Performance Thresholds
SQLSERVR Process > 90% CPU for 15 minutes" Of course the end user will try
and run it two or three more times taking up more resources.
If I do a fail over to the other SQL server in the cluster the CPU's will
drop down to their normal ranges and everything works fine.
My question is when performing the "failover" that 10 - 15 seconds it takes
to do this what happens to any data that is trying to write to the database?
Is it lost? And can this cause corruption in the database itself?
Thanks!
|||When you mean "rolled back" the transactions are basically held in cache
until the backup server has taken complete control? Is that correct?
One user received the following error during failover in their web session:
[DBNETLIB][ConnectionRead (recv()).]General network error. Check your
network documentation. in Microsoft OLE DB Provider for SQL Server
Is this a concern or only the period before the failover is complete?
Thanks!
"Tom Moreau" wrote:

> Failovers don't cause corruption. Rather, any active transactions are
> rolled back when the backup node takes over from the primary node.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> SQL Server MVP
> Toronto, ON Canada
> ..
> "Scopus69" <Scopus69@.nospam.postalias> wrote in message
> news:DF8080ED-0DF2-42C7-B1DA-4D9375D0B2EA@.microsoft.com...
> We have a 3rd party vendor application that runs on IIS and connects to a
> back end SQL Cluster. Sometimes a user will try and run a commission report
> and the SQL server takes a big hit on the CPU's (Dual 2.0 Ghz Xeon's) and I
> will get a error in MOM 2005 that the "Server Performance Thresholds
> SQLSERVR Process > 90% CPU for 15 minutes" Of course the end user will try
> and run it two or three more times taking up more resources.
> If I do a fail over to the other SQL server in the cluster the CPU's will
> drop down to their normal ranges and everything works fine.
> My question is when performing the "failover" that 10 - 15 seconds it takes
> to do this what happens to any data that is trying to write to the database?
> Is it lost? And can this cause corruption in the database itself?
> Thanks!
>
>
|||Not exactly. Anything in cache evaporates. Transactions are written to the
transaction log. If a COMMIT record is not written, then when SQL Server
comes up, all of the work done thus far in that transaction is backed out.
This is true whether you are using a cluster or not.
The network errors go away once SQL Server has come back up again. Clean
apps will try to reconnect.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
"Scopus69" <Scopus69@.nospam.postalias> wrote in message
news:49B44171-B185-463B-833E-E4190AD923A9@.microsoft.com...
When you mean "rolled back" the transactions are basically held in cache
until the backup server has taken complete control? Is that correct?
One user received the following error during failover in their web session:
[DBNETLIB][ConnectionRead (recv()).]General network error. Check your
network documentation. in Microsoft OLE DB Provider for SQL Server
Is this a concern or only the period before the failover is complete?
Thanks!
"Tom Moreau" wrote:

> Failovers don't cause corruption. Rather, any active transactions are
> rolled back when the backup node takes over from the primary node.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> SQL Server MVP
> Toronto, ON Canada
> ..
> "Scopus69" <Scopus69@.nospam.postalias> wrote in message
> news:DF8080ED-0DF2-42C7-B1DA-4D9375D0B2EA@.microsoft.com...
> We have a 3rd party vendor application that runs on IIS and connects to a
> back end SQL Cluster. Sometimes a user will try and run a commission
> report
> and the SQL server takes a big hit on the CPU's (Dual 2.0 Ghz Xeon's) and
> I
> will get a error in MOM 2005 that the "Server Performance Thresholds
> SQLSERVR Process > 90% CPU for 15 minutes" Of course the end user will
> try
> and run it two or three more times taking up more resources.
> If I do a fail over to the other SQL server in the cluster the CPU's will
> drop down to their normal ranges and everything works fine.
> My question is when performing the "failover" that 10 - 15 seconds it
> takes
> to do this what happens to any data that is trying to write to the
> database?
> Is it lost? And can this cause corruption in the database itself?
> Thanks!
>
>

CLR integration & clustering....question

If I've got a small CLR procedure that I'm now using thanks to 2005,
and I'm running on a failover cluster....do I need to have the DLL
available on both nodes of the cluster at the same path? So when I
fail over, the SQL Assembly knows where to go find it?"Corey Bunch" <unc27932@.yahoo.com> wrote in message
news:1137791687.994902.215830@.f14g2000cwb.googlegroups.com...
> If I've got a small CLR procedure that I'm now using thanks to 2005,
> and I'm running on a failover cluster....do I need to have the DLL
> available on both nodes of the cluster at the same path? So when I
> fail over, the SQL Assembly knows where to go find it?
>
CLR Assemblies are stored in the databse, not the filesystem.
So they are shared by both nodes.
David|||I see - so once you load them using Create Assembly, their put in a
system table somewhere and loaded & accessed from there & not the
filesystem?|||"Corey Bunch" <unc27932@.yahoo.com> wrote in message
news:1137792522.275215.162630@.g14g2000cwa.googlegroups.com...
>I see - so once you load them using Create Assembly, their put in a
> system table somewhere and loaded & accessed from there & not the
> filesystem?
>
Correct. Also this keeps assemblies in different databses from stepping on
each other.
David|||You can see them in the sys.assemblies catalog view (and the actual content
in binary format in the content column of sys.assembly_files). For a list of
the functions/procedures etc they export you can have a look at
sys.assembly_modules
HTH,
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
"Corey Bunch" <unc27932@.yahoo.com> wrote in message
news:1137792522.275215.162630@.g14g2000cwa.googlegroups.com...
>I see - so once you load them using Create Assembly, their put in a
> system table somewhere and loaded & accessed from there & not the
> filesystem?
>|||Thanks - this is great info...
Jasper Smith wrote:[vbcol=seagreen]
> You can see them in the sys.assemblies catalog view (and the actual conten
t
> in binary format in the content column of sys.assembly_files). For a list
of
> the functions/procedures etc they export you can have a look at
> sys.assembly_modules
> --
> HTH,
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
>
> "Corey Bunch" <unc27932@.yahoo.com> wrote in message
> news:1137792522.275215.162630@.g14g2000cwa.googlegroups.com...

CLR integration & clustering....question

If I've got a small CLR procedure that I'm now using thanks to 2005,
and I'm running on a failover cluster....do I need to have the DLL
available on both nodes of the cluster at the same path? So when I
fail over, the SQL Assembly knows where to go find it?
"Corey Bunch" <unc27932@.yahoo.com> wrote in message
news:1137791687.994902.215830@.f14g2000cwb.googlegr oups.com...
> If I've got a small CLR procedure that I'm now using thanks to 2005,
> and I'm running on a failover cluster....do I need to have the DLL
> available on both nodes of the cluster at the same path? So when I
> fail over, the SQL Assembly knows where to go find it?
>
CLR Assemblies are stored in the databse, not the filesystem.
So they are shared by both nodes.
David
|||I see - so once you load them using Create Assembly, their put in a
system table somewhere and loaded & accessed from there & not the
filesystem?
|||"Corey Bunch" <unc27932@.yahoo.com> wrote in message
news:1137792522.275215.162630@.g14g2000cwa.googlegr oups.com...
>I see - so once you load them using Create Assembly, their put in a
> system table somewhere and loaded & accessed from there & not the
> filesystem?
>
Correct. Also this keeps assemblies in different databses from stepping on
each other.
David
|||You can see them in the sys.assemblies catalog view (and the actual content
in binary format in the content column of sys.assembly_files). For a list of
the functions/procedures etc they export you can have a look at
sys.assembly_modules
HTH,
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
"Corey Bunch" <unc27932@.yahoo.com> wrote in message
news:1137792522.275215.162630@.g14g2000cwa.googlegr oups.com...
>I see - so once you load them using Create Assembly, their put in a
> system table somewhere and loaded & accessed from there & not the
> filesystem?
>
|||Thanks - this is great info...
Jasper Smith wrote:[vbcol=seagreen]
> You can see them in the sys.assemblies catalog view (and the actual content
> in binary format in the content column of sys.assembly_files). For a list of
> the functions/procedures etc they export you can have a look at
> sys.assembly_modules
> --
> HTH,
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
>
> "Corey Bunch" <unc27932@.yahoo.com> wrote in message
> news:1137792522.275215.162630@.g14g2000cwa.googlegr oups.com...