Recovering Master Database In a Active/Passive Cluster

I have a SQL 2K SP3 on WIN 2K ADV SP4. Please advise how to recover the master database in an active - passive cluster.
I have done this before in a non-cluster environment. What if any differnece in a cluster environment?.
Thanks.
What do you mean by recover the master database? If you mean rebuild you
can look at the following article:
HOWTO: Rebuild the MASTER Database on a Virtual SQL Server 2000 Instance
http://support.microsoft.com/?id=298568
Rand
This posting is provided "as is" with no warranties and confers no rights.
sql

Recover Database from MDF/LDF Files

Hi,
I have only a pair of mdf/ldf files for a database, and want to recover to a new instance of SQL Server 2000. Please advise the procedure to perform this. Thanks a lot,
Jake
Jake,
you need to reattach the database. The syntax for this is as follows:
EXEC sp_attach_db @.dbname = 'pubs',
@.filename1 = 'c:\Program Files\Microsoft SQL Server\MSSQL\Data\pubs.mdf',
@.filename2 = 'c:\Program Files\Microsoft SQL Server\MSSQL\Data\pubs_log.ldf'
HTH,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||Paul, I need to do the same thing but I'm using SQL Server Management Studio
from the June CTP of SQL Server 2005. My MDF and LDF files were created in
SQL Server 2000 MSDE. Can you tell me how execute the reattachment from the
Management Studio interface?
I'd be very grateful for any help. Thanks.
Peter
"Paul Ibison" wrote:

> Jake,
> you need to reattach the database. The syntax for this is as follows:
> EXEC sp_attach_db @.dbname = 'pubs',
> @.filename1 = 'c:\Program Files\Microsoft SQL Server\MSSQL\Data\pubs.mdf',
> @.filename2 = 'c:\Program Files\Microsoft SQL Server\MSSQL\Data\pubs_log.ldf'
> HTH,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p
|||Peter,
sorry but my VMWare has timed out, so I don't currently have access to the
CTP. Probably best to post up in the beta newsgroups.
Cheers,
Paul Ibison
|||Thanks anyway Paul
Peter
"Paul Ibison" wrote:

> Peter,
> sorry but my VMWare has timed out, so I don't currently have access to the
> CTP. Probably best to post up in the beta newsgroups.
> Cheers,
> Paul Ibison
>
>