Get Data Moving 1
Results 1 to 2 of 2

Thread: Attunity Stream on cluster and restoring from backup

  1. #1
    Maksim Golovkin is offline Junior Member
    Join Date
    Feb 2007
    Location
    Moscow/Kaluga
    Age
    35
    Posts
    6
    Rep Power
    0

    Attunity Stream on cluster and restoring from backup

    1. How to configure Attunity if SQL Server source machine is a Windows
    fail-over cluster (2 machines with 1 attached storage)?
    2. What happens with Attunity Stream when database is to be restored from
    backup?
    Data Integration Consultant
    S&T International, Moscow, Russia

  2. #2
    Join Date
    Sep 2006
    Posts
    233
    Rep Power
    10
    1. How to configure Attunity if SQL Server source machine is a Windows fail-over cluster (2 machines with 1 attached storage)?

    The Attunity CDC for SQL Server employ a special service (TLOG Miner or LGR for short) that extract changes from the active log to a transient storage from which the CDC agent reads. Only one LGR instance can open and write to the transient storage.

    If SQL Server is configured on a fail-over cluster then the fail-over process that starts the SQL Server instance on the backup node should also start the LGR service on the backup node. If it important, following a fail-over, to let the LGR process process enough time to process all transactions up to the failure point before starting to truncate logs and backing them up.


    2. What happens with Attunity Stream when database is to be restored from
    backup?

    Since the backup usually refers to an earlier time, the LGR process has already processed and moved events past the point of the backup and once the database is restored, the target database becomes out of sync with the source one. Following a restore from backup, the recommended approach is to refresh the target database and then start the CDC processes.
    By Dror Harari

    To Find Out more About Attunity Technology:
    Attunity
    or:
    Contact Us

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •