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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-06-14 : 10:27:50
|
| jr writes "Hi,I have a question about sql server 2000 clustering.We have windows2000 advance cluster setup. And i just wanted to install sql server 2000 clustering. One thing i don't understand, why do we need virtual ip number for sql server?Con't we use same windows2000 cluster ip?thanks in advance.jr" |
|
|
bm1000
Starting Member
37 Posts |
Posted - 2002-06-14 : 11:39:10
|
| You need an ip to use the virtual SQL server resources. The cluster ip is used if you need to access cluster resources. I have only helped to set up a SQL Server cluster. We configured all of the disk resources that the SQL Server was going to use as being owned by the SQL Server. Whenever a failover occurs the disk resources for database files and transaction logs move to the new node as a unit. Having connected to the server using the cluster name, not the virtual SQL Server name, all of the disks were unavailable when the takeover to the new node occurred. Unasked for advice: don't even think of using a cluster in production unless you have a cluster in development so that you can test software fixes, service packs, device drivers, etc... |
 |
|
|
|
|
|
sql 2000 clustering