The forum will be down for maintenance at some point from Friday, November 16 at 19:00 EDT until Sunday, November 18 at 23:59 EDT. Downtime will be minimized but the exact timing is unknown.

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: 40%

For information on how the deprecated -xp partner syntax worked, you will need to look at the SQL Anywhere 11 documentation:

(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]( "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: 910 times

last updated: 02 Jan '14, 09:45