SQL Anywhere Mobile - transaction log rename [9.0.2.3137]

Author

transaction log rename [9.0.2.3137]

Lars Henrik Fritz

2005-10-27, 8:20 am

HiI'm using a transaction log rename option efter a backup event every
night.
Are soon about to separate my database in to 2 databases. 1 for
production and 1 for warehouse. For this purpose we will use "CALL
xp_cmdshell('dbmlsyn
c.exe -c dsn=odbc_remote_chan
ge -o dbmlsync.out -
v -e SendColumnNames=ON -uo');" to synch the production with the
warehouse every night.

A problem seems to occur when the transaction log is renamed since
the Synchronisation fails with the following error.
"E. 10/04 13:49:00. Found duplicate or partial transaction logs and
file name: " C:\dbproduktion\0510
01AA.LOG""

My system is: Windows 2000
My version is: ASA 9.0.2.3137

Is there a way to rename logfiles "SAFE"?Lars Henrik

Reg Domaratzki \(iAnywhere Solutions\)

2005-10-27, 8:20 am

You need to make sure that the transaction logs from your two database are
stored in different directories. dbmlsync has no way to determine which
database a renamed transaction log belongs to, so it assumes that ALL the
transaction logs in the directory you specify ( or the directory where the
active transaction log resides if you don't specify a value ) belong to the
database that is currently synchronizing. This can lead to the error you
are seeing, so it's important to keep renamed transaction logs from
different databases in separate directories.

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

"Lars Henrik Fritz" <lh.fritz@x-change.se> wrote in message
news:434292b7@forums
-2-dub...
> HiI'm using a transaction log rename option efter a backup event every
> night.
> Are soon about to separate my database in to 2 databases. 1 for
> production and 1 for warehouse. For this purpose we will use "CALL
> xp_cmdshell('dbmlsyn
c.exe -c dsn=odbc_remote_chan
ge -o dbmlsync.out -
> v -e SendColumnNames=ON -uo');" to synch the production with the
> warehouse every night.
>
> A problem seems to occur when the transaction log is renamed since
> the Synchronisation fails with the following error.
> "E. 10/04 13:49:00. Found duplicate or partial transaction logs and
> file name: " C:\dbproduktion\0510
01AA.LOG""
>
> My system is: Windows 2000
> My version is: ASA 9.0.2.3137
>
> Is there a way to rename logfiles "SAFE"?Lars Henrik
>
>

Lars Henrik Fritz

2005-10-27, 8:20 am

Thanks,

Lars Henrik
"Reg Domaratzki (iAnywhere Solutions)" <FirstName.LastName@ianywhere.com>
skrev i meddelandet news:4342aebe@forums
-1-dub...
> You need to make sure that the transaction logs from your two database are
> stored in different directories. dbmlsync has no way to determine which
> database a renamed transaction log belongs to, so it assumes that ALL the
> transaction logs in the directory you specify ( or the directory where the
> active transaction log resides if you don't specify a value ) belong to
the
> database that is currently synchronizing. This can lead to the error you
> are seeing, so it's important to keep renamed transaction logs from
> different databases in separate directories.
>
> --
> 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"
>
>
> "Lars Henrik Fritz" <lh.fritz@x-change.se> wrote in message
> news:434292b7@forums
-2-dub...
>
>

Sponsored Links