Sybase Database Refresh/Restore steps

How to restore Sybase Database Backup:

Performing Sybase Database backup on the quality server for performing the data refresh activity from Production server.

Follow the below procedure to restore the Sybase Database from Backup dump:

1. Login with Sybase user.

su - sidadm or syb

2. Use below command to login to Sybase Database:

isql64  -Usapsa -P -S  -X

use master

go

3. Use below command to restore the Database from backup dump file.

load database from ‘Backup dump directory with dump name’

go

And press “ENTER” to execute the restore command.

The restoration process will take some time to get all the data restore into the database once it is done then execute the below command to make database online.

ONLINE DATABASE
go


Now your database is online with latest restored backup.

Note:  Stop the sap application server. use below command

su - adm

stopsap r3