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.

How to backup SAP Sybase Database

If you want to do a backup of Sybase Database for SAP, we can do in different ways.
1. From DBACOCKPIT you can schedule in the database calendar.
2. Run the backup command from OS Level.
3. Using the third party tools.


To take the backups in sybase we need to create dump configuration. this is required to perform the backup options 1 & 2.
Below are the steps to perform using Commands at OS Level (linux).
1. Login to OS level and switch to database user.
    su - syb<sid>
2. Connect to Sybase DB level
    isql64 -Usapsa -P<password> -S<SID> -X
3. connect to master database
    use master
    go
4. Now configure dump
    sp_config_dump @config_name='<sidDB>',
    @stripe_dir = '<backup path>' ,
    @compression = '101' ,
    @verify = 'header'
    go
5. Now trigger the backup providing the file name
    dump database <SID> using config = 'dump config file name(which      we created in the above step)'

    

How to donwload, Install and add HANA DB to Studio

Download HANA Studio software:

1.   Open portal: https://support.sap.com or directly open https://launchpad.support.sap.com/#/softwarecenter

2.       If you open first link, Select Download Software

3.  It will open a new window and you need SAP S user to login, select SUPPORT PACKAGES & PATCHES, then extract By Alphabetical Index (A-Z)

4. Choose letter H

5. Select HANA PLATFORM EDITION

6. Choose SAP HANA PLATFORM EDITION 2.0.
7. Select HANA Studio 2

8. Under downloads Select which operating system you want, here we are selected Windows, and download latest file.

 9.  Download SAPCAR file for Windows version from above place, search with name SAPCAR and download related to windows.

Installation of HANA Studio:

1. Then extract the HANA Studio.SAR using SAPCAR file.

 It will extract all files to install and creates a folder.

 2.       Double Click on hdbsetup

 Click on Finish.

 Adding HANA system in Studio:

Open HANA Studio by click below icon

 For the first time it will ask to select the workspace, if you want you can change it later.

 Click on launch

Below are the available consoles:

Click on Administration Console

And click Add system icon to add HANA system

 Enter details of HANA DB

 Click on Finish

It will add system like below:

 Click on the First line “ SYSTEMDB@XXXXXX”

You can get complete details at right side.