Load/Restore SAP ASE Database instance on LINUX
- Kshitij Shrivastava
- Aug 4, 2017
- 1 min read
1 Prerequisites
a. Login access of sybsid user .
b. Login access of sapsa or sa user.
c. Should have proper compress Database dump.
d. SAP instance should be stop when executing load database.
3 Solutions
a. Stop sap instance – SIDADM user
b. Login to server with user SYBSID
c. Check path of Complete database backup
Exp: Highlighted database backup path and backup name /Sybase/SAPbackup/backups
d. Log in to ASE with isql as user 'sapsa' and execute the command:
1>use master
2>go
1> load database DBNAME from '/Database backup path with file name'
2> go
Successfully 100% execution
e. After successfully Load database now need to database online.
f. execute the command
1> use master
2> go
1> online database<DBNAME>
2>go
Successfully Restore an SAP Adaptive Server Enterprise (ASE) database instance on Linux.
g. Login to SIDADM user and start sap Instance.
Recent Posts
See All#!/bin/bash ############################################################################### #Script Name : kill sidadm sap process...
################################################################################ # UNIX Shell Script for Checking # 1. Whether SAP Has...
Comments