cancel
Showing results for 
Search instead for 
Did you mean: 

Use of copy of database done with backup

Miro_Marek
Explorer
1,786

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?

View Entire Topic
t1950
Participant
0 Kudos

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