Friday, 28 December 2018

How to restore SAP Sybase DB in to the same host.

If you wan to restore SAP sybase DB into the Same host using the backup dump, please follow below steps:

1. First make sure the dump is available to the file system level.
2. Stop SAP system
    stopsap
3. Then start only Sybase database
    startdb
4. Now Switch use to syb<sid> then connect tot he DB
    su - syb<sid>
    isql64 -Usapsa -P<password> -S<SID> -X
5. Now trigger restore command:
    use master
    go
    load database <SDI> from '<path of the file/<filename>'
    go

6. After processing the load, it will ask run bring online command.
    online database <SID>
    go

7. Exit from sybase level and stop and start the SAP.

No comments:

Post a Comment