on 2020 Apr 08 4:34 PM
I have a database with db file on 😧 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?
Request clarification before answering.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
30 | |
10 | |
8 | |
8 | |
7 | |
6 | |
6 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.