Skip to Content
avatar image
Former Member

How to Setup Replication Server ASE

Hi Experts,

I want to replicated ASE DB to stand by server

Os WIndows

DB Sybase

I created the Standby instance from the Production Server Instance with same SID I need to replicate the DB to the Stand BY Instance Please any provide me a solution how to replicate the DB to Stnadby.

Regards

Sunil

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Dec 05, 2017 at 11:59 AM

    Hi Sunil,

    Check this KBA, it has all the offerings of HA

    1650511 - SYB: High Availability Offerings with SAP Adaptive Server Enterprise

    Regards

    Kiran K Adharapuram

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 12, 2017 at 05:46 PM

    The "1650511 - SYB: High Availability Offerings with SAP Adaptive Server Enterprise" link didn't work for me.

    The typical thing to do is setup warm standby replication in a Sybase replication server. Unfortunately, the replication server isn't a simple turn key operation. You'll probably have to take classes to get up to speed. Also, the repserver requires extra licenses (although a warm standby repserver license is included for free with the new Edge Edition of Sybase ASE, replaces Small Business Edition. See https://www.sap.com/documents/2016/06/0cb0ed17-767c-0010-82c7-eda71af511fa.html#)

    A partial solution is to use ASE clustering to tolerate CPU/memory type failures. But it doesn't help with disk failures. And requires special licenses.

    If data update rates are low, you could use transaction log dumps or new differential (also called incremental) dumps (dumps all changes since the last full backup. Don't have to worry about transaction logs filling up)

    Add comment
    10|10000 characters needed characters exceeded