SQL Anywhere database replication - Only cleans up mirrored logs

Author

Only cleans up mirrored logs

Andrew Braunstein

2005-10-27, 7:41 am

Hi. We are seeing the following on one of our servers (running on Windows
Server 2003 w/8.0.2.4433):

The database is running mirrored logs. The mirrored log directory has a
current log file, as well as a log file one day back. However, the primary
database directory has log files going back to June (one per day). I have
verified that all the children database are current (at least within the
past 24 hours). Therefore I believe the contents of the mirror log
directory is correct. I realize I could clean them up manually, but why are
the primary log files not getting cleaned up automatically?

Just as few more pieces of information:

1) The database and dbremote run as services
2) We run a dbbackup job each evening that renames and restarts the
transaction log
3) delete old logs is on
4) This was working for several years, up until mid June.

--
Andrew Braunstein

Rob Waywell

2005-10-27, 7:41 am

What is your full dbremote command line?

--
-----------------------------------------------
Robert Waywell
Sybase Adaptive Server Anywhere Developer - Version 8
Sybase Certified Professional

Sybase's iAnywhere Solutions

Please respond ONLY to newsgroup

EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all

To Submit Bug Reports:
http://case-express.sybase.com/cx/c...sc?CASETYPE=Bug

SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288

Whitepapers, TechDocs, and bug fixes are all available through the iAnywhere
Developer Community at www.ianywhere.com/developer
"Andrew Braunstein" < abraunstein@healthwy
se.com> wrote in message
news:43546db2@forums
-2-dub...
> Hi. We are seeing the following on one of our servers (running on Windows
> Server 2003 w/8.0.2.4433):
>
> The database is running mirrored logs. The mirrored log directory has a
> current log file, as well as a log file one day back. However, the
> primary database directory has log files going back to June (one per day).
> I have verified that all the children database are current (at least
> within the past 24 hours). Therefore I believe the contents of the mirror
> log directory is correct. I realize I could clean them up manually, but
> why are the primary log files not getting cleaned up automatically?
>
> Just as few more pieces of information:
>
> 1) The database and dbremote run as services
> 2) We run a dbbackup job each evening that renames and restarts the
> transaction log
> 3) delete old logs is on
> 4) This was working for several years, up until mid June.
>
> --
> Andrew Braunstein
>
>

Reg Domaratzki $iAnywhere Solutions$

2005-10-27, 7:41 am

Can you also please post the output from dbinfo run against the database
that dbremote connects to.

--
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"

"Rob Waywell" <rwaywell@no_spam.ianywhere.com> wrote in message
news:43551792$1@foru
ms-2-dub...
> What is your full dbremote command line?
>
> --
> -----------------------------------------------
> Robert Waywell
> Sybase Adaptive Server Anywhere Developer - Version 8
> Sybase Certified Professional
>
> Sybase's iAnywhere Solutions
>
> Please respond ONLY to newsgroup
>
> EBF's and Patches: http://downloads.sybase.com
> choose SQL Anywhere Studio >> change 'time frame' to all
>
> To Submit Bug Reports:
>
http://case-express.sybase.com/cx/c...sc?CASETYPE=Bug
>
> SQL Anywhere Studio Supported Platforms and Support Status
> http://my.sybase.com/detail?id=1002288
>
> Whitepapers, TechDocs, and bug fixes are all available through the
iAnywhere
> Developer Community at www.ianywhere.com/developer
> "Andrew Braunstein" < abraunstein@healthwy
se.com> wrote in message
> news:43546db2@forums
-2-dub...
Windows[color=darkre
d]
day).[color=darkred]
mirror[color=darkred
]
>
>

Sponsored Links