SAP SYBASE Backup configuration

[Shawn_1977]

Hello Team,

SAP Solution manager is running with 7.2,Windows and SYBASE DB. Can you please help how to configure and schedule Online backup and log backup?

Regards

Shan

[qwertie]

hello,

saphost-xxx:~ # su - syb<sid>

saphost-xxx /sybase/<SID>% isql -Usapsa -S<SID> -X

Password:

1>

create db backup

DB Backup:

1>dump database <sid> using config = '<sid>DB'

2>go

1>dump database master using config = '<sid>DB'

2>go

1>dump database sybsystemprocs using config = '<sid>DB'

2>go

1>dump database saptools using config = '<sid>DB'

2>go

for scheduling , you need to know your backuplandscape to integrate sybase.

checkout sapnote 1588316 - SYB: Automatische Datenbank- und Protokollsicherungen konfigurieren

best regards

[S_Sriram]

Hi Shan,

Using the Isql command you can create either the bat or cmd file in Windows OS, in windows OS you can use the Windows scheduler to schedule the backup of DB and truncate log everyday.

Regards

SS