csm setup for active/backup sql server

[zhichao]

Hi

There are two sql servers to be in active/backup mode.

The users' requirement are:

1. The csm should direct all traffics to server1. When server1 is down, it should direct to server2 and stay with server2.

2. Even if server1 is back, it should still stay with server2.

This is to prevend database corruption.

Any idea how to do these?

I am thinking to use:

1. weight 0 on server2 to make it backup. (I tried backup server command, but it did not work... And CCO does not have good docu on this)

2. use sticky with network mask /0 to make all users always stay with one active server and never preempt.

Any other suggestion?

[m.singer]

I think the method suggested by you is appropriate and i think it will work. By doing so you can configure in such a way that even if server goes down the other server which is configured as backup will takeover...Try this it should work.

[zhichao]

Yes. the Method works!