cancel
Showing results for 
Search instead for 
Did you mean: 

Change log file settings

huber1
Participant
0 Kudos
1,571

Hi

As a result of running Schema Analysis > Run in SQL Central, I tried to move the database log file (Hades.log) to another volume as suggested. I use this command

/Applications/SQLAnywhere17/System/bin64/dblog -t "/Volumes//SQLAnywhere17Logs/Hades.log" "/Applications/SQLAnywhere17/databases/Hades.db"

I get these lines in the terminal:

SQL Anywhere Transaction Log Utility Version 17.0.4.2129 "/Applications/SQLAnywhere17/databases/Hades.db" was using log file "Hades.log" "/Applications/SQLAnywhere17/databases/Hades.db" is using no log mirror file

But when I start the database, the log file is still created at the place where the db file is located.

Any hint why it's not putting the log file to the specified volume?

And can I be sure that if the database log file is still at the same location, the database is in he same state as before running the command, i. e. nothing has changed?

SQL Anywhere 17.0.4.2129 macOS El Capitan Java 1.8.0_151

TIA, Robert

Accepted Solutions (0)

Answers (0)