user database restore problem !!!

[hitgon]

I've create user database ACUTE in SYBASE ASE 15.0.2

I used 18 different database devices in ACUTE database
I used one separe log device and all the others are the data only
devices.
I've set 'truncate log on check point' database option in ACUTE db.


now i daily dump the ACUTE database.

and when i need to take recover the hole database.
I have to create new ACUTE db in new ASE Database installation.
then restore the latest dump in ACUTE db.
now what happen ,
that ....
database successfully restored. but in some db devices , data and log
will be mixed.
so is there any way to remove log from devices!!!

[Manish Negandhi]

Post by hitgon
I've create user database ACUTE in SYBASE ASE 15.0.2
I used 18 different database devices in ACUTE database
I used one separe log device and all the others are the data only
devices.
I've set  'truncate log on check point'  database option in ACUTE db.
now i daily dump the ACUTE database.
and when i need to take recover the hole database.
I have to create new ACUTE db in new ASE Database installation.
then restore the latest dump in ACUTE db.
now what happen ,
that ....
database successfully restored. but in some db devices  , data and log
will be mixed.
so is there any way to remove log from devices!!!

You need to create your target database with the fragments in exactly
the same order as the source database to avoid this problem, have a
look at sysusages entries for the source database and create the
target database exacly same way...

-HTH
Manish Negandhi
[TeamSybase]

[Michael Heaney]

Post by Manish Negandhi

Post by hitgon
I've create user database ACUTE in SYBASE ASE 15.0.2
I used 18 different database devices in ACUTE database
I used one separe log device and all the others are the data only
devices.
I've set 'truncate log on check point' database option in ACUTE db.
now i daily dump the ACUTE database.
and when i need to take recover the hole database.
I have to create new ACUTE db in new ASE Database installation.
then restore the latest dump in ACUTE db.
now what happen ,
that ....
database successfully restored. but in some db devices , data and log
will be mixed.
so is there any way to remove log from devices!!!

You need to create your target database with the fragments in exactly
the same order as the source database to avoid this problem, have a
look at sysusages entries for the source database and create the
target database exacly same way...

Ed Barlow includes a very nifty procedure (sp__revdb) in his
system stored procedures package which will reverse-engineer
the allocations, and output the correct create/alter database
DDL.


Michael Heaney
JCVI

[hitgon]

thanks a lots Manishbhai,

Post by Manish Negandhi

Post by hitgon
I've create user database ACUTE in SYBASE ASE 15.0.2
I used 18 different database devices in ACUTE database
I used one separe log device and all the others are the data only
devices.
I've set  'truncate log on check point'  database option in ACUTE db.
now i daily dump the ACUTE database.
and when i need to take recover the hole database.
I have to create new ACUTE db in new ASE Database installation.
then restore the latest dump in ACUTE db.
now what happen ,
that ....
database successfully restored. but in some db devices  , data and log
will be mixed.
so is there any way to remove log from devices!!!

You need to create your target database with the fragments in exactly
the same order as the source database to avoid this problem, have a
look at sysusages entries for the source database and create the
target database exacly same way...
-HTH
Manish Negandhi
[TeamSybase]- Hide quoted text -
- Show quoted text -