Tuesday, February 14, 2012

Clustered sql binn directory

Hi I do not have any experience of clustered servers
I have some software that needs some dll's placed into the directory below
which an extended strored proc uses to verify and run internal code.
C:\Program Files\Microsoft SQL Server\MSSQL<instancename>\Binn
this works perfect on single Sql server instances or named instances
If two servers are set as clustered and both are active. Does anyone know
how the structure of the sql binn directories are laid out. If I have an
extened proc that checks a dll in the sql instance binn directory where or
how is this named for clustered servers.
Or has anyone used extended procs with clustered servers?
thanks for any advice
Sammy
I use extended stored procedures with clustered SQL regularly. The SQL
clustered and non-clustered binary structure is exactly the same. They only
difference is the structure is paralleled on each node. Therefore, you have
to place the appropriate DLL in the same directory on all the nodes.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Sammy" <Sammy@.discussions.microsoft.com> wrote in message
news:EF42B68E-1D9B-4D2C-91D7-74273953E5CD@.microsoft.com...
> Hi I do not have any experience of clustered servers
> I have some software that needs some dll's placed into the directory
> below
> which an extended strored proc uses to verify and run internal code.
> C:\Program Files\Microsoft SQL Server\MSSQL<instancename>\Binn
> this works perfect on single Sql server instances or named instances
>
> If two servers are set as clustered and both are active. Does anyone know
> how the structure of the sql binn directories are laid out. If I have an
> extened proc that checks a dll in the sql instance binn directory where or
> how is this named for clustered servers.
> Or has anyone used extended procs with clustered servers?
> thanks for any advice
> Sammy
>
>
>
>

No comments:

Post a Comment