I have a database with db file on D: drive and Transaction log on E: drive. For some test I want to use a copy of this database done with dbbackup. Dbbackup copies both file db and log into one target directory. But leave the transaction log name on original path. I cannot start this database because transaction log file Name is stored in db file with full path of the live db on E: drive. If I try to change the name an error occurs telling me the database needs recovery because it looks in transaction log file form the live database. I can use dblog to remove transaction log but not the name but in this case I lose the changes done after last check point. Is there some other possibility? |
Just to understand: DBLOG -t new-transaction-log-path fails when run against the backup copy of the database file? Because IMHO that should work (and I would set a relative path then or just the transaction log name without a path)... What does DBLOG without further options tell when run against the backup database file? |
here's what i do to set up a test database using a full backup copy the db and log fill to a different folder ex: c:\databasse\test\ rename the db and log files c:\database\test\myDB.db > c:\database\test\test.db and c:\database\test\myDB.log > c:\database\test\test.log use Sybsse Central to change log file settings Tools > SQL Anywhere 16 > Change Log File Settings follow the prompts and your test db is ready to run |