RE: Recovering or attaching a SAPDB database-how to

Yes, both data and log volumes are intact. It's just that I refered "without 
backup"  as having no backup created from the SAPDB Database Manager. I only 
need to attach the volumes again to SAP DB but don't know how. 
 
Big thanks to you Tilo, I will try the steps you gave on Monday.
 
Kind Regards,
 
Red

"Heinrich, Tilo" <tilo.heinrich@xxxxxxx> wrote:
Hello Christian,

I didn't understood that. If the data and log volumes are still there and no 
backup is available, one can do the following:

1.) Create a new database with the same parameters as the old one. Especially 
the number and sizes of data and log volumes should match the old database.

2.) Stop the new database.

3.) Substitute the data and log volumes of the new database with the 
corresponding data and log volumes from the old database.

4.) Restart the new database with the old volumes.

Best regards,
Tilo Heinrich
SAP Labs Berlin

-----Original Message-----
From: Knappke, Christian 
Sent: Friday, November 28, 2003 3:05 PM
To: 'maxdb@xxxxxxxxxxxxxxx'
Subject: RE: Recovering or attaching a SAPDB database-how to


> without a backup there is no way to restore your database to 
> the state directly before the server crashed. All you can do 
> is reinstall the SAP DB software and create a database that 
> looks like your old one.
> 
> Your attach db sounds to good to be true, how can it 
> recreate/restore a database after the complete OS is 
> formatted and reinstalled without any kind of backed up data?

As far as I have understood, the data and log volumes weren't lost. The OP is 
apparently looking for a step by step guide how he can re-use the existing 
volumes with a new DB instance without losing the database contents.

Regards
Christian
-- 
#include 
/* The opinions stated above are my own and not 
necessarily those of my employer. */


-- 
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/maxdb?unsub=tilo.heinrich@xxxxxxx

-- 
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/maxdb?unsub=redshadow48@xxxxxxxxx


---------------------------------
Do you Yahoo!?
Free Pop-Up Blocker - Get it now