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?

asked 08 Apr, 15:34

Miro%20Marek's gravatar image

Miro Marek
61146
accept rate: 0%


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?

permanent link

answered 08 Apr, 16:06

Volker%20Barth's gravatar image

Volker Barth
36.9k343505765
accept rate: 34%

converted 09 Apr, 08:38

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

permanent link

answered 09 Apr, 08:33

Tom%20Mangano's gravatar image

Tom Mangano
672242737
accept rate: 8%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×12
×4

question asked: 08 Apr, 15:34

question was seen: 257 times

last updated: 09 Apr, 08:33