I have a Active/Passive cluster and have installed the SQL 2005.
What I would like to know, before I proceed with my configurations (since it
is my first time in a cluster environment) is whether I will need to attach
the database (lets call it DBX) to SQL Server on both the servers seperately,
or do i only have to attach the database DBX to SQL Server on the active
machine.
Like i said this is my first time so i want to be very sure before i proceed.

You don't attach the database to any node. Rather, you attach it to the SQL
Server instance regardless which node the instance may be running at the
time. In general, a SQL Server operation doesn't care where the SQL instance
is running.

Linchi

"iqv1" wrote:

thanks for you advice Linchi... I will try that

"Linchi Shea" wrote:

Keep in mind that SQL Server will only be active on one node at a time. The
disks will only be visible from this active node; so, that is where you must
place the database files.

Then, as Linchi stated, you must run the attach process through the SQL
Server instance, just like you would on a stand-alone system.

You connect to the SQL Server instance through the failover cluster server
name dedicated for SQL Server, not specific node names.

Sincerely,


Anthony Thomas


--

"iqv1" <iqv1 (AT) discussions (DOT) microsoft.com> wrote

Hello!

I suppose that you know the answer on my question.

The matter is that we have Active/Passive cluster and SQL Server running on
it. I want to deploy clr procedure. I have already created dll and make
script which creates assembly in database, but I don't know do I need to
implement this script on both servers or I can implement it on active node
only.


"Linchi Shea" wrote:

Igor,

Since the assembly is created in the database, then you should only need to
deploy to the SQL Server. (You can even script it out of the database and
get a big binary string of the DLL in your script.)

You should not need to care which cluster node it is running on.

RLF

"Igor" <Igor (AT) discussions (DOT) microsoft.com> wrote