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" <[EMAIL PROTECTED]> 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: '[EMAIL PROTECTED]' 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/[EMAIL PROTECTED] -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] --------------------------------- Do you Yahoo!? Free Pop-Up Blocker - Get it now
