cancel
Showing results for 
Search instead for 
Did you mean: 

Sybase ASE database backup procedure.

Former Member
0 Kudos

Hi all,

Actually i configure the solution manager 7.1 system preparation and basic settings also finished. Currently i configured MOPZ for updating the Patch sp9 to sp14. So that now i want to take backup of sybase backup, i am new to sybase database . Please tell the procedure for sybase ASE databse backup.

Regards

Rajesh

Accepted Solutions (0)

Answers (3)

Answers (3)

former_member212573
Participant
0 Kudos

Hi Rajesh,

Please tell me about the below points

1.whether you have configured the backup dumping setup?

2. The OS you are using...

Regards,

Pankaj

Former Member
0 Kudos

Hi Pankaj,

Just few weeks before i installed solman with sybase OS , i am not configured dumping setup.

I am using OS is Windows 2012 R2 standard.

Regards

Rajesh

former_member212573
Participant
0 Kudos

Hi Rajesh,

Please follow the below step for dumping the database and its log in sybase ASE

configuration for Database backup in SYBASE

____________________________________________

1) Login to OS level and switch to syb<sid>

2) Ensure you have the folders created for backup

  e:\backup

  e:\backup\db #(for dumping database backup file)

  e:\backup\log #(for dumping database log backup file)

  2(A) to give permission and assign group to directory

3) Login to command line sql utility of sybase database as:

Here I have taken SID as SMD

 

  isql64 -Usa -P<password> -S<SID> -X

  Example:-isql64 -Usa -PApassw0#d -SSMD -X

4) You are only allowed to create the backup config in master database, the below command will help you create a config to be used for database backup

  1>sp_config_dump @config_name = 'SMDDB' ,

  2>@stripe_dir = 'E:\backup\db' ,

  3>@compression = '101' ,

  4>@verify = 'header'

  5>go #watch out for the ','

5) in case you are not in master database, you can check this and go to master database as follows:

  1>select db_name()

  2>go                #this command will give you the name of the database you are currently using

6) in case the result is not master, you can use master database using the following command:

  1>use master

  2>go

7) if the creation of backup config is successful, you will get the below confirmation message:

  The change is completed. The option is dynamic and ASE need not be rebooted for

  the change to take effect.

  (return status = 0)

configuration for transaction log backup in SYBASE

___________________________________________________

1) You are only allowed to create the backup config in master database, the below command will help you create a config to be used for transaction backup

  1>sp_config_dump @config_name='SMDLOG' ,

  2>@stripe_dir = 'E:\backup\log' ,

  3>@compression = '101' ,

  4>@verify = 'header'

  5>go

2) if transaction log truncate option se set to true, the log backup will not work and you will get a prompt from sybase database to set it to false, the message back from the sybase is as below:

  Msg 4208, Level 16, State 1:

  Server 'PID', Line 1:

  DUMP TRANsaction to a dump device is not allowed while the trunc. log on chkpt.

  option is enabled.  Disable the option with sp_dboption, then use DUMP DATABASE,

  before trying again.

   You can set the truncate option to false as below:

  1>sp_dboption SMD,'trunc',false

  2>go

3) After this you will be prompted to execute checkpoint in <SID> database which is done as below:

  1>use SMD

  2>go

  1>checkpoint

  2>go

Note:- After dumping transaction log you will be able to do database dumps

4) Once you are done with this, you may go back to master database and fire the dump transaction

(You will have to execute dump database before you can use dump transaction) as shown below:

  1>dump transaction SMD using config='SMDLOG'

  2>go

5) Now, you will be able to trigger the backup using the below command:

  1>dump database SMD using config = 'SMDDB'

  2>go

6) Once, this is successful, you may want to schedule this as a regular task in your database calender using DBACOCKPIT

Regards,

Pankaj

M:-+91 8511730039

mail:-pankaj3176@gmail.com

Former Member
0 Kudos

Hi Pankaj,

Thank you for valuable reply, I am having the issue i.e isql utility is not connecting.

Regards

Rajesh

Former Member
0 Kudos

Hi Rajesh,

Could you please brief step-by-step where you are failing

Regards,

Pankaj

hans-juergen_schwindke
Active Participant
0 Kudos

Hi,

you can find a description in my reply in this discussion:

Best regards,

Juergen

yakcinar
Active Contributor
0 Kudos

Hello Rajesh,

These blogs can help you.

Backup and restore Sybase ASE 15.7 database | SCN

Regards,

Yuksel AKCINAR

Former Member
0 Kudos

Hi Yuksel,

  I have login with my solman and executed tcode db13 but its shows correctly, then how do take backup.

yakcinar
Active Contributor
0 Kudos

Hello Rajesh,

Goto Database SMR first.


There you can see "Backup and Recovery" and "Jobs" tabs.

In Backup and Recovery you can see database dump history.


In Jobs you can use "Add" button to schedule an action.

In action selection there is SQL Script. For SQL script you can write "dump database SMR using config = 'SMRDB'" to schedule your DB backup and write dump transaction SMR using config = 'SMRLOG' for log backup.


(SMRDB and SMRLOG configurations must be prepared like the ones in note 1588316 - SYB: Configure automatic database and log backups)

If you donot want to use configurations you can write below SQL scripts directly for DB and transaction backups.

dump database SMR to 'D:\backup\SMRbck.dmp' with verify = full, compression = 100

go


dump transaction SMR to 'D:\backup\SMRTrns.trn' with compression = 101

go

You can define schedule date, recurrence in Add action wizard.

Regards,

Yuksel AKCINAR