|
Home > Archive > SQL Anywhere Mobile > November 2005 > the best way to make log in remote database smaller size?
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 |
the best way to make log in remote database smaller size?
|
|
| Sunshine 2005-11-23, 7:24 am |
| Hi all
I have a PDA device running PPC2003 and I develop an application using ASA
for CE that synchronizing with consolidated ASA.
As we know, ASA log of remote database will become bigger and bigger as
application running.
I know I can backup database(TRANSACTION
LOG TRUNCATE ),but I want to get
more effective way to do it .
Could you give me more suggestion?
Thanks a lot!
By the way, Do log file size will become smaller than before backup
database?
I do it , but find there is no chance.
Thanks again!
| |
| Reg Domaratzki \(iAnywhere Solutions\) 2005-11-23, 9:30 am |
| The following document describes how to manage log file growth in when using
SQL Remote. The concepts are the same for dbmlsync (including the -x switch
on dbmlsync). I think I'll update the doc to cover dbmlsync shortly.
http://www.sybase.com/detail?id=1012988
--
Reg Domaratzki, Sybase iAnywhere Solutions
Sybase Certified Professional - Sybase ASA Developer Version 8
Please reply only to the newsgroup
iAnywhere Developer Community : http://www.ianywhere.com/developer
iAnywhere Documentation : http://www.ianywhere.com/developer/product_manuals
ASA Patches and EBFs : http://downloads.sybase.com/swx/sdmain.stm
-> Choose SQL Anywhere Studio
-> Set filter to "Display ALL platforms IN ALL MONTHS"
"Sunshine" <lijinhui@gmail.com> wrote in message
news:43841c81@forums
-1-dub...
> Hi all
> I have a PDA device running PPC2003 and I develop an application using ASA
> for CE that synchronizing with consolidated ASA.
> As we know, ASA log of remote database will become bigger and bigger as
> application running.
> I know I can backup database(TRANSACTION
LOG TRUNCATE ),but I want to get
> more effective way to do it .
> Could you give me more suggestion?
> Thanks a lot!
>
> By the way, Do log file size will become smaller than before backup
> database?
> I do it , but find there is no chance.
> Thanks again!
>
>
|
|
|
|
|