Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 clusters

Author  Topic 

laddu
Constraint Violating Yak Guru

332 Posts

Posted - 2007-11-30 : 02:50:19
I need to install sql server 2005 server and foglight on 2 node active/passive cluster.



do i need to install on both nodes ?

after install how can i find which is active node?

how can i findout the virtual name/IP ?



do i need to create DBMP's on both the nodes ?



how can i do cluster failover?





I am completely new SQL server, please let me know



laddu

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2007-11-30 : 03:57:56
How much do you know about clusters?

When you install SQL 2005, you have the option of installing it on a cluster, from there it is simple.

A good place to start is www.itidiots.com, they have a podcast on setting up a cluster for SQL.
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-12-02 : 00:27:17
You have to specify ip address for virtual sql during installation, check resources in cluster admin.
Go to Top of Page
   

- Advertisement -