Backup and restore Sybase ASE 15.7 database

[ivan_martis3]

Hi,

I am new to Sybase database. I have just installed ECC6 EHP5 on Sybase database. I do not know how to backup and restore the database. Can anyone please guide me.

Regards

Ivan

[ivan_martis3 · Accepted solution]

Thanks Jan,

Now I am getting the error in DB13 or any DB related tcodes Database Connection +++SYBADM :SQL error 4002 [ASE error SQL 4002] Login failed.

Regards

Ivan

[JanStallkamp · Accepted solution]

Hi Ivan.

I would guess that the database connection used by the DBA Cockpit (DB13 is a part of the DBA Cockpit nowadays) is not configured properly. Please start transaction DBACOCKPIT. On the tab 'System Landscape' (should be the active one at startup) chose 'Database Connections' from the menu on the left. You should find a DB connection '+++SYBADM' in the Sybase ASE section. If you select this database connection you will see all the details of this connection. Check that the user is 'sapsa'. Click on the 'Test' button.

If the connection fails in this test I would guess the password was not set correctly and you have to change this. There is a 'Change' button available that opens a dialog for this.

If that's not helping: please open a message on BC-DB-SYB.

Regards,

Jan

[ivan_martis3 · Accepted solution]

Thanks Jan

[Former Member]

Hi,

I have login with smr( solution manager) , then put db13 , it shows like below.

There is no backup option is there in db13. I want full backup of my sybase ASE database.

[Former Member]

Hi,

how to take the sybase 15.7 backup.

[ivan_martis3]

Hi Srinivas,

from the command prompt run the command

isql -Usapsa -S<SID> -X

then run the following command at the sql prompt

1>dump database <SID> to "d:\backup\backupxxx.dmp" with compression = "101"

2>go

You can refer these notes

sapnote 0001588316  SYB Configure automatic database and logbackups

sapnote 0001585981 SYB Ensuring Recoverability for Sybase

sapnote_0001539125 SYB Configuration Guide for Sybase ASE 15.7.0

sapnote_0001539124 SYB Database Configuration for SAP on Sybase ASE

sapnote_0001611715 SYB How to restore a Sybase ASE Windows

sapnote_0001618817 How to restore a Sybase ASE UNIX

Regards

Ivan

[Former Member]

Dear Martis,

How to restore the database...in my system DB13 or DBCOCKPIT is working ...

All ready backup is taken by your above command prompt. isql...

pl.help me.

Regards,

M.Krishna

[Former Member]

small correction "DB13 or DBCOCKPIT is not working"

[ivan_martis3]

Hi Krishna,

To restore the database use the load command at the isql prompt

1>load database from 'd:\backup\xxxxx.dmp'

2>go

1>online database <DBSID>

2>go

SAP Note 1611715 How to restore a Sybase ASE database server windows

1618817 for unix

DBCOCKPIT or DB13 will not work in Sybase. You need to use DBACOCKPIT for all purposes.

SAP Note 1605680

1525407

Regards

Ivan Martis

[Former Member]

Hi Ivan,

Where you able to schedule your backup. ? If so can you please share the syntax that you used to schedule it. please see below command im running..

dump database SID to "f:\backup\backupxxxx.dmp" with compression = "101"

go

[Former Member]

Hi Manuela,

You can login with SIDADM or SYBADM & login to command prompt and execute the dump command .Before that use Isql  -Usapsa -SSID -->go.

You can also use dbisql utility also

Regards

IAsim

[Former Member]

Take a look on a Blog that I wrote. I believe it will be helpfull..

http://scn.sap.com/community/sybase-ase/blog/2013/05/31/backup-challenges-on-sybase

BR  

Fred

[JanStallkamp]

Hi Ivan.

Welcome to the SAP on Sybase ASE community! Please have a look at the following SAP Notes:

• 1585981   SYB: Ensuring Recoverability for Sybase ASE
• 1588316   SYB: Configure automatic database and log backups
• 1611715   SYB: How to restore a Sybase ASE database server (Windows)
• 1618817   SYB: How to restore a Sybase ASE database server (UNIX)

Beside that you might be interested into taking the class ADM540 which explains Sybase ASE for SAP applications.

Regards,

Jan