Hi, I'm mirroring my SQL Anywhere database using the "old" way of...-xp partner=(ENG=mtrs16b....etc.

In that case how do i set mtrs16b as "primary"?? In the new instructions, i see how to do it using the SQL statements, but how do i do it using the cmd commands? Thanks so much. Aron

asked 25 Dec '13, 13:26

arony's gravatar image

accept rate: 0%

You need to specify preferred=yes on the -xp command line option on the server which is the preferred primary server. i.e.

-xp partner=(ENG=mtrs16b;preferred=yes...
permanent link

answered 25 Dec '13, 17:29

Mark%20Culp's gravatar image

Mark Culp
accept rate: 41%

For information on how the deprecated -xp partner syntax worked, you will need to look at the SQL Anywhere 11 documentation: http://dcx.sybase.com/index.html#1100/en/sqlanywhere_en11/help_top_index.htm

(02 Jan '14, 09:45) Ian McHardy
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:


question asked: 25 Dec '13, 13:26

question was seen: 1,892 times

last updated: 02 Jan '14, 09:45