What is backup and why it is necessary to take backup for database in Sybase ASE?
Backing up database is most important task reason when ever there is disaster happens
backup is basic unit of recovery in order to bring database to its consistent state
let me give one example
Lets consider there is unknown situation where hardware of server failure/crash etc
then we all must have DR plan in place i.e Disaster Recovery plan in order to bring back your database server original state
at that time you need to refer backup plan.
Yes Of course there is considerable time and energy will be consumed to prepared backup plan in case of DR failure.
Your DR plan should be tested and often need to be tested every 6 months ensure DR plan working in order to avoid 11th hours crisis.
What are roles required to perform backup operations
oper_role and dbo of the database can perform database backup
how to assign role to login
sp_role “grant”,oper_role,login_name
or
grant role oper_role to login_name
go
what are types of backup
ASE has 2 types of backup
1)Database dumps
2)Transaction dumps
i) Database dumps is full/complete backup of database backup and dump database is command is used
ii)Transaction dump is copy of transaction log only which means copy of changes in database and it uses dump transaction command
What are processes are running while database backup operation is in progress on host level
You can process sybmultbuf processes while database backup operation is in progress
you can see this processes by using top command on host level
In order to perform database backup on Sybase ASE need backup server to up and running.
How to check backup server running or not ?
login sybase ase and use below command
sp_who…SYB_BACKUP
go
How to start/ stop backup server if its not running
startserver -r RUN_SYB_BACKUP
shutdown SYB_BACKUPServerName with wait|nowait
Please check below link database refresh steps in sybase ASE.
goodpress489.wordpress.com 