================================================== ==
SQL Anywhere Network Server Version 11.0.1.2308 Advanced edition
16 logical processor(s) on 4 physical processor(s) detected.
Running Windows 2003 Build 3790 Service Pack 2 on X86 (X86_64)
Server built for X86 processor architecture
25165824K of memory used for caching
Physical memory allocated for images: 24883928K
Address space allocated: 1237664K
Using a maximum page size of 8192 bytes
================================================== ==

In -xp database option:

autofailover = Specifies whether the mirror server automatically takes over as the primary server when the original primary server goes down.
This option does not apply to synchronous mode.

Is it possible to set up database mirror system using synchronous (sync) mode but do not allow auto fail over if the primary server go down?

Thanks in advance for your help.

Best regards,
Rachan Terrell

No, there is no way to do this at present; the mirror will try to take ownership
of the database if the primary server goes down and the arbiter and mirror agree
that the mirror is up-to-date. It's not clear why you would want to do otherwise.

You could mark one of the servers as the preferred server so that it will take
ownership of the database when it becomes available again.

SQL Anywhere Developer Community:
http://www.sybase.com/developer/libr...ere-techcorner


SQL Anywhere Blog Center: http://www.sybase.com/sqlanyblogs




Rachan Terrell wrote:

Bruce,



Thank you very much for your input. We plan to use the Mirror server as
reporting server which the user could run adhoc TSQL. Some time the user
issued Cartesian joins or hash and merge joins which contributed to
excessive run times on the Mirror server and before we would fail over we
could terminate these users on the Mirror and inform them not to use the
Mirror after we manually fail over. This is one of the reasons why we would
like to not having the autofailover occurs.



But anyway currently we have been playing with this setting on both the
Primary and the Mirror:



mode=page;autofailover=NO;preferred=NO



And it seems to perform the way we need but we just start testing and would
not know if this will work the way we would like to use it.



Best regards,

Rachan Terrell



"Bruce Hay" <h_a_y_@_i_a_n_y_w_h_e_r_e_d_o_t_c_o_m> wrote