Hi

We are having problems reliably recovering from a live backup setup on
v8.0.2. Sometimes it works, usually it doesn't.

Scenario

Start Position: Live backup running, creating log file in folder A on backup
server. Last night's full backup and log file in folder B.
1. Stop live backup job.
2. Start db server with -a switch to apply last nights log file (folder B)
to the database (folder B) so that any additional transactions in the log
file are caught. Completes successfully, server shuts down.
3. Start db server with -a switch to apply live backup log file (folder A)
to the database (folder B). Completes successfully, server shuts down.
4. Start db server normally, fails with error: "Cannot open the transaction
log file -- Can't use log file
"****.log" Since it has been used more recently than the database file.

Are we missing a stage here, do we need to dump the log file and start a new
one? Any thoughts gratefully received!

Justin Willey

Sounds like you are trying to start the engine in step 4 with a log
file that was used in step 2. Try moving that log file somewhere else
so the engine will create a new log file when it starts.


On 27 Apr 2006 09:59:41 -0700, "Justin Willey"
<gjw (AT) nospamatall (DOT) iqx.co.uk> wrote:

--
Breck Carter [Team iAnywhere]
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com
The book: http://www.risingroad.com/SQL_Anywhe...ers_Guide.html
breck.carter (AT) risingroad (DOT) com

Thanks - that will be it.

Justin

"Breck Carter [Team iAnywhere]" <NOSPAM__bcarter (AT) risingroad (DOT) com> wrote in
message news:e3u152ths7js436fgd1pemoagtid93vu0i (AT) 4ax (DOT) com...