cancel
Showing results for 
Search instead for 
Did you mean: 

specifying "preferred=yes" when mirroring.

Former Member
2,163

Hi, I'm trying to specify the primary server by using the below syntax, but it does not accept it. Did I get the syntax correct?

partner=(ENG=mtrs16a;preferred=yes;LINKS=tcpip...

Thanks Aron

Accepted Solutions (0)

Answers (1)

Answers (1)

ian_mchardy
Product and Topic Expert
Product and Topic Expert
0 Kudos

To verify the server version, either take a look at the console log file (it is listed at the beginning on server started). The console log file is specified by the server -o option. Alternately, run "dbsrv16 -v".

On the preferred partner, I believe you need:

-xp partner=(ENG=mtrs16a;LINKS=tcpip...);preferred=yes

See http://dcx.sybase.com/index.html#1100/en/dbadmin_en11/dbserver-s-4186144.html*d4e13626.

Frankly, it would likely be easier for you to use the non-deprecated CREATE MIRROR SERVER statements, since the current documentation uses these statements.