Attaching previous database to new installation

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:

> 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.
|||thanks for you advice Linchi... I will try that
"Linchi Shea" wrote:
[vbcol=seagreen]
> 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:
|||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@.discussions.microsoft.com> wrote in message
news:81F95D4E-ACAE-4C99-9144-A91D963A83BD@.microsoft.com...[vbcol=seagreen]
> thanks for you advice Linchi... I will try that
> "Linchi Shea" wrote:
SQL[vbcol=seagreen]
instance[vbcol=seagreen]
(since it[vbcol=seagreen]
attach[vbcol=seagreen]
seperately,[vbcol=seagreen]
active[vbcol=seagreen]
proceed.