I wanted to restore the Sybase 16.0 Database backup on quality server for performing the data refresh activity.
Follow the below procedure to restore the Sybase 16.0 Database from Backup dump:
1. Login with Sybase user.
su – sybSID
2. Use below command to login to Sybase Database:
isql -Usapsa -SSID -X
Enter password then you will get access to Database.
3. Use below command to restore the Database from backup dump file.
load database SID from ‘Backup dump path’
And press “ENTER” to execute the restore command.
The restoration process will take some time to get all the data restore into database once it is done then execute the below command to make database online.
ONLINE DATABASE SID
Now your database is online with latest restored backup.