Home > Archive > SQL Anywhere Mobile > November 2005 > Synch and log renamed









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Synch and log renamed
Fantom

2005-11-17, 3:25 am

When i use dbmlsync, my transaction log is renamed to xxxxxxxx.log and
create new empty log. After ten run dbmlsync i have ten logs xxxxxxxx.log
and one active log. This is necessary ? May i delete this ten logs ? Can i
work within this new logs ? How ?

Fantom

Breck Carter [TeamSybase]

2005-11-17, 9:24 am

On 16 Nov 2005 23:29:58 -0800, "Fantom"
<szczukot@skasujto.poczta.onet.pl> wrote:

>When i use dbmlsync, my transaction log is renamed to xxxxxxxx.log and
>create new empty log. After ten run dbmlsync i have ten logs xxxxxxxx.log
>and one active log. This is necessary ? May i delete this ten logs ? Can i
>work within this new logs ? How ?
>
>Fantom


Run this on your remote database:

SET OPTION PUBLIC.DELETE_OLD_LOGS = 'ON';

Then the next run of dbmlsync will delete any old log files it doesn't
need. If it doesn't delete any, then you may have a subscription that
hasn't been synchronized for a while.

Breck



--
SQL Anywhere Studio 9 Developer's Guide
Buy the book: http://www.amazon.com/exec/obidos/A...7/risingroad-20
bcarter@risingroad.com
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com
Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com