Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2004
    Location
    Mumbai
    Posts
    15

    Unanswered: Replication help

    I have set 2 way homogeneous ASE to ASE replication .

    I have inserted about 20000 records in a table in the database db1 ,

    I have received a transaction log full error , I cannot truncate the log because the database has data and log mixed on the device . The partitions have also filled up and the queue is also almost full .

    I altered the database on a different device and the transaction has resumed on the primary but due to the queues n partitions being full the replication is not happening. I have added another partition as well but of no use . Is there a way to have the data replicated without loosing the inserted data on the primary , if not how can I flush the inbound queue's in the primary , so that I can resume another replication.


    Thanks for any help in advance.

  2. #2
    Join Date
    Nov 2002
    Location
    Switzerland
    Posts
    524
    To unblock your primary, you need to stop the replication :

    Code:
    exec sp_stop_rep_agent yourDB
    if it's not enough

    Code:
    dbcc settrunc ('ltm', 'ignore')
    PS : to avoid this type of problem, please use separate log devices !
    F. Celaia
    DBA Sybase/DB2/Oracle/MS-SQL

Posting Permissions

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