| Author |
ASE dump/load database and trans log?
|
|
| Jayvee Vibar 2005-04-29, 3:26 am |
| After the executing: load database mydb from "/folder/mydb.dat".
Does it also initialize/restart/empty the transaction log segment?
How does the transaction log relate to the newly reloaded database,
are they match since the reload? Thanks.
| |
| Luc Van der Veurst 2005-04-29, 3:26 am |
|
"Jayvee Vibar" <jcnvibar@hotmail.com> wrote in message
news:4271a08b@forums
-1-dub...
> After the executing: load database mydb from "/folder/mydb.dat".
> Does it also initialize/restart/empty the transaction log segment?
No.
> How does the transaction log relate to the newly reloaded database,
> are they match since the reload? Thanks.
What do you mean with 'match since the reload' ? The transaction log is
part of the database. So when you dump a database, it contains the
log at the time the database was dumped. When loading a dump,
unfinished transactions are rolled back and the server continues to
add transactions to it. You empty the transaction log with the dump
transaction command.
Luc.
| |
| mpeppler@peppler.org 2005-04-29, 7:26 am |
| > After the executing: load database mydb from
> "/folder/mydb.dat". Does it also initialize/restart/empty
> the transaction log segment?
When you load a database the transaction log will be in the
same state as the source database when it was dumped.
So if, when you ran "dump database" the log was half-full it
will again be half-full when you've loaded that database
dump.
Michael
| |
| Jayvee Vibar 2005-05-02, 8:24 pm |
| Thanks.
> What do you mean with 'match since the reload' ?
You and m.peppler answered my post correctly though my question was not
quite clear. I mean 'match since the reload' is that the dump statement also
backup the transaction log and also get restored with load command.
|
|
|
|