Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in August and this forum will be retired.

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?


Thanks Aron

asked 30 Dec '13, 18:00

arony's gravatar image

accept rate: 0%

Which version and build number are you using?

(30 Dec '13, 21:19) Mark Culp

I believe its 16.0.0 build 1691. How do i check to make sure?

(31 Dec '13, 14:32) arony

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


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

permanent link

answered 02 Jan '14, 11:01

Ian%20McHardy's gravatar image

Ian McHardy
accept rate: 40%

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: 30 Dec '13, 18:00

question was seen: 1,914 times

last updated: 02 Jan '14, 11:01