on 11-07-2013 7:53 AM
Dear Gurus,
I'm new to sybase, I've just installed an ERP 6 EHP 7 on sybase ASE 15.7, I don't know how to start managing it, cannot find any documents that describe the architecture shortly, also I need to know how to manage it either using command line prompt or GUI, for the sake of backup for example.
Thanks in advance
Dear M Medhat,
Have a look at the Getting Started Guide , link is on the starting page of the SAP on Sybase .
( direct link http://scn.sap.com/docs/DOC-29524 )
It provides lots of links to relevant documents for a variety of DBA tasks. (amongst other backup and restore)
The command line tool to use is isql of course.
With kind regards
Tilman Model-Bosch
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear Mr Medhat,
More detailed instruction may get found in these SAP notes (referenced in the Getting Started Guide)
1588316 - SYB: Configure automatic database and log backups
1585981 - SYB: Ensuring Recoverability for Sybase ASE
1611715 - SYB: How to restore a Sybase ASE database server (Windows)
1618817 - SYB: How to restore a Sybase ASE database server (UNIX)
If your job is to administer Sybase ASE for a SAP Business Suite System , I suggest to also consider SAP training course ADM540
Lot of the basics of Sybase ASe are discussed therein.
HTH
Tilman Model-Bosch
Hi Ahmed,
for windows:
Login with <SID>adm, open command prompt and type below command.
cmd:>isql -Usapsa -S<SID> -X click enter
password: master password
1>dump database <SID> to "path\filename.dmp" (ex: "f:\backup\bkp.dmp" )
2>go
for AIX or Linux:
login to root and switch to <SID>adm and and type below command
Abc# isql -Usapsa -S<SID> -X
password: master password
1>dump database <SID> to "/mount point/filename.dmp" (ex: "/backup/bkp.dmp" )
2>go
Regards,
Bhaskar
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.