Is there any way to save the transaction log history through an
unload? I am upgrading our database to Sybase 11 but after unloading
using the "-an" flag it seems that the log file is cleared of recent
transactions and reset. Our users would like to still view the
recent transactions history prior to the upgrade. Is there a way to
save the recent transactions through an unload?

Thanks in advance,

Mike

You probably want to use the ** -ar ** switch instead.
Depending upon requirements (replication/synchronization)
the log sequence required may need this switch or
the manual rebuild equivalent.

You would normally only use the -an switch if you don't care
about the transaction log history as much.

"Jonesy" <jones.t.michael (AT) gmail (DOT) com> wrote

Thanks for the reply, Nick.

I tried the "-ar" flag as well but it too erases the transaction log
for me. As stated in the Sybase help, the "-ar" flag will only save
the transaction log if it detects that the database is used in
replication (ours isn't,), otherwise the log is deleted.

I'm beginning to think this jsn't possible.

Thanks for the reply, Nick.

I tried the "-ar" flag as well but it too erases the transaction log
for me. As stated in the Sybase help, the "-ar" flag will only save
the transaction log if it detects that the database is used in
replication (ours isn't,), otherwise the log is deleted.

I'm beginning to think this jsn't possible.

Thanks for the reply, Nick.

I tried the "-ar" flag as well but it too erases the transaction log
for me. As stated in the Sybase help, the "-ar" flag will only save
the transaction log if it detects that the database is used in
replication (ours isn't,), otherwise the log is deleted.

I'm beginning to think this jsn't possible.

Jonesy,

note that you are free to do a backup with rename log just before the
database upgrade. That way you can (as always) decide for yourself how
many older transaction log files and how much transaction log data
remains available.
AFAIK, in order to read pre-V11 transaction logs with the V11 DBTRAN,
you will have to install the so-called "Pre-10 physical store library" -
cf. the docs article "Deploying database utilities"

http://dcx.sybase.com/index.php#http...ase-tools.html

HTH
Volker

Jonesy wrote:

Jonesy wrote:
On the assumption that you have shut down the database cleanly, you
should be able to simply rename the transaction log to another name
before you perform the dbunload.

--
Reg Domaratzki, Sybase iAnywhere Solutions
Please reply only to the newsgroup

Documentation : Exercise your WRITE @DocCommentXchange: DCX.sybase.com
SQL Anywhere Patches and EBFs : http://downloads.sybase.com/swd/base.do
-> Choose SQL Anywhere
-> Optionally set filter to "Display ALL platforms IN ALL MONTHS"

Saving a backup of the old log seems like a reasonable solution to the
problem.

As always, the advice on these message boards has been invaluable.

Thanks again,

Mike