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.

AttachDBFileName - refers to previous log file

Hello,
I'm using the AttachDBFilename option in the SQL connection string to attach
a database to a SQLExpress instance on another machine.
The is an error though, it seems to want to refer to a log file on the
machine the .mdf was originally created on. The error is as follows:
Could not attach file 'C:\Program Files\Strategic Systems\Time
Master\TimeMasterDat.mdf' as database 'TimeMaster'.
File activation failure. The physical file name "D:\Visual Studio 2005
Projects\Strategic\Applications\TimeMaster\Databas e\Strategic.TimeMaster.Database.SQL2005\TimeMaster Dat_log.LDF" may be incorrect
How can I get the attach to avoid referring to this log file?
Answered in
http://forums.microsoft.com/forums/ShowPost.aspx?PostID=1081110&SiteID=1
HTH, Jens K. Suessmeyer.
http://www.sqlserver2005.de

AttachDBFileName - refers to previous log file

Hello,
I'm using the AttachDBFilename option in the SQL connection string to attach
a database to a SQLExpress instance on another machine.
The is an error though, it seems to want to refer to a log file on the
machine the .mdf was originally created on. The error is as follows:
Could not attach file 'C:\Program Files\Strategic Systems\Time
Master\TimeMasterDat.mdf' as database 'TimeMaster'.
File activation failure. The physical file name "D:\Visual Studio 2005
Projects\Strategic\Applications\TimeMast
er\Database\Strategic.TimeMaster.Dat
abase.SQL2005\TimeMasterDat_log.LDF" may be incorrect
How can I get the attach to avoid referring to this log file?Answered in
http://forums.microsoft.com/forums/...081110&SiteID=1
HTH, Jens K. Suessmeyer.
http://www.sqlserver2005.de
--